In this video we discuss how to merge and center, or combine cells in an excel spreadsheet. We go through an example of how to center a title above a table in the video

Transcript/notes
Let’s say that you have created a table, such as in this worksheet here, and you want to put in a title and center it above the table.

To do this, make sure you are on the home tab at the top of the worksheet, and start by left clicking on any one of the cells in the row above the table, so it is highlighted, I’m going to put it in cell B5. Next, we type in the name of the table, and then hit the enter key. From here, we are going to merge the cells together in row 5, and center the text in those merged cells. To do this, left click and hold on the furthest left cell that we want merged, in this case cell A5, and drag over to the last cell in the row that we want merger, cell F5, and release the click and hold, so all of the cells are highlighted.

Next, go up to the alignment section near the top of the worksheet, and there is a merge and center icon, left click on that, and the cells have been merged together and the title is centered.

свернуть