If you have a tag or heading on a spread sheet in Excel that you want to center across a specific number of cells, there are couple of methods you can do this, with or without merging cells. We’ll reveal you both ways.
Initially, we’ll focus message throughout cells by merging cells. To do this, select the cells you want to merge.
In the “Alignment” area of the “Home” tab, click the “Merge & Center” button.
The cells are combined and the message is focused in the single resulting cell.
If you don’t intend to combine the cells, you can still center message across them. Enter your text in the first of the cells across which you wish to focus the message, pick the cells, as well as click the “Alignment Settings” button in the lower-right corner of the “Alignment” section on the “Home” tab.
NOTE: You can likewise right click the chosen cells and pick “Format Cells” from the popup menu.
See to it the “Alignment” tab is energetic. If you opened up the “Format Cells” dialog box by right-clicking on the chosen cells, you have to click on the “Alignment” tab as it’s not the active tab by default.
Select “Center Across Selection” from the “Horizontal” drop-down list.
KEEP IN MIND: You can additionally select the “Merge cells” check box on the “Alignment” tab on the “Format Cells” dialog box to merge the picked cells. However, this does not center the text. You have to do that individually.
The text is focused across the selected cells, yet the cells are not merged into one.
If you center text across an option without combining the cells typically, you can tape a macro for the treatment and also placed a button on the Quick Access Toolbar to quickly focus text throughout selected cells.