

Which is why I wrote this hub, since I know a lot of people have trouble with merging and unmerging. I have to teach people every day on functions i feel that are basic, but i know to others they may not be. This Hub is bound to save people from asking others at the office to "show me how to."ĭavid Livermore (author) from Bakersfield, California, United States on November 11, 2012: Literatelibran from Williamsburg, Virginia on November 15, 2012: I get bombarded with those questions daily when it comes to Word/Excel, so when I saw this hub up for grabs, I took it. How did you do the video? I'm just asking because it looks just like a screen shot, but I didn't know you could do video that way.ĭavid Livermore (author) from Bakersfield, California, United States on November 15, 2012: I am slightly addicted to Excel, so this hub caught my eye. Can be a tricky program to work with, but it did the job well enough.ĮxpectGreatThings from Illinois on March 25, 2013: It allows just a portion of the screen to be recorded.
#MERGING CELLS IN EXCEL MAILING LIST PROFESSIONAL#
Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.ĭavid Livermore (author) from Bakersfield, California, United States on March 25, 2013: This article is accurate and true to the best of the author’s knowledge. If you know the keys on the keyboard, this can be even faster than using the mouse. Any text in the cell will move to the first row and column of the previously merged cells. Then on your keyboard press "H", then "M", and then "U".
#MERGING CELLS IN EXCEL MAILING LIST HOW TO#
How to Access the "Format Cells" Menu in Excel This method takes longer, but is worth doing if you have multiple things you wish to do in the "Format Cells" menu. Click on the "Alignment" tab, if necessary, and then uncheck the box next to "Merge Cells".The information below describes how you can access that menu. In the screenshot above, it shows rows 1 - 2 and columns A - U selected. You will know when you have selected a group of merged cells when you see the row and column numbers change color. Click on the cell group you wish to unmerge.The second method to unmerge cells in Microsoft Excel involves the "Format Cells" menu, which can be accessed multiple ways. Using the Format Cells Menu to Unmerge Cells in Excel
