Center Headings Without Merging Cells In Excel

In Excel, its best, if you can avoid merging cells in this example, we've got a little table, and we're going to try and Center the headings for each quarter over the three months in that quarter. So you might be tempted to just select the three cells and merge them. And that will solve the problem.

But merge cells can make it harder to sort or filter the data later, so we're going to Center them without merging, and I'll show you a couple of other little tricks for finishing up this table as well. So. This cell I've, typed the heading quarter one and then quarter two in column, E I want it centered over these three columns, so I'm going to select those three cells and then go to the alignment group on the Home tab and click this alignment, Settings button in the format cells window I'm on the alignment tab and under horizontal I'm going to click the arrow and select Center across selection, then click OK. So it looks like those cells are merged. We can see that we can click on each cell individually. If I click where it looks like, it says, quarter, one, there's, nothing in the formula bar that text is really in cell b3. I can also make this look a bit nicer if I put an outside border.

So up on the Home tab, again, I'll go to the borders and click outside border. And once I have that set up I can select those three cells on the Home tab click, the format painter and then click the quarter two cells and that automatically puts the same formatting, the border and the center across selection onto those. Columns and one last thing I'll do here to finish up this table, I want to get my totals, so I'm going to select all the cells with the numbers and go out a bit further to select all the blank cells, where I want the totals and then on the ribbon I'll click, the autosum button, and that puts in the totals across and down for all the cells for more excel tips and tutorials and to download the sample file for this video. Please visit my contexture z-- website at w. When textures, calm.


Dated : 18-Apr-2022

Leave Your Comment