Merging cells in Excel is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to merge cells and how to spruce up our data table a bit to make it pop.
Let’s take a look at table below:
The table details the sales in September for a variety of cities. Merging the three cells above the table will help the title stand out a bit more.
Step 1: Select the cells you want to merge
In our example, we’ve selected the cell containing the text “September Sales” as well as the other two cells above the table. (Note: Merging cells will only keep the text/data that is in the upper left most cell you want to merge)
Step 2: Select Merge & Center from the home page.
You’re done. Let’s look at the finished product:
It’s looking a lot better. Before we finish formatting our table with some final tweaks, you should know there’s a very easy to use keyboard shortcut to access the same home page drop-down button. The video below from our Instagram channel demonstrates that shortcut (ALT+H+M+C)
View this post on Instagram
How to merge and center text across many cells. Easy to do with the mouse but did you also know there’s a keyboard shortcut for this? #excel #excelnerds #data #dataanalytics #datascience #merge #center #video #spreadsheets #googlesheets #text #office #work #microsoftexcel #microsoft #keyboard #keyboardshortcut #shortcut #productivity #hack
Step 3: Spruce up your table to make it stand out against the standard Excel background.
While our table does look better with the title merged above, let’s remove the gridlines behind it.
In the “View” tab, click “Gridlines” to remove them from being shown on this tab.
Better. Let’s add a border around each cell and bold the title.
- To bold the title, click CTRL+B while selecting it.
- To add borders, select “All Borders” from the homepage dropdown menu:
MUCH better. Sometimes the smallest tweaks can make a big difference.