This tip is applicable to Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or the latest Microsoft Office Excel 365.<\/strong><\/em><\/p>\n Please check out both of these methods and my warning about their usage. Finally, read my preferred and recommended actions while centring titles in Excel spreadsheets.<\/p>\n Step 1: <\/strong>Select the range of cells where you want to center the text item. Take note that the text you want to center must be in one of these cells. Further, there should be no other text in the selected range, or it will be overwritten. Microsoft Excel will keep the text in the top-left cell of the selected range, and discard any other text in the selected range.<\/p>\n Step 2:<\/strong> Click on the Merge and center<\/em> button<\/strong>. This is present on the Home Tab<\/strong><\/em>, under the Alignment group<\/strong><\/em>. It looks like 2 cells on top, a double-headed arrow, and 2 cells at the bottom.<\/p>\n The selected text is merged and centered in the selection. If multiple rows were selected, the centered text will be at the bottom row.<\/p>\n In case you want to align the text in the middle too, you have to click on the Middle Align<\/strong><\/em> icon in the formatting toolbar. Now the text should be exactly in the middle horizontally and vertically.<\/p>\n CAUTION:<\/strong><\/em> While you may like this method of merging and centering text, because of its ease and convenience, we do not recommend to merge cells in Excel worksheets.<\/p><\/blockquote>\n All Excel pros adhere to this rule – never merge cells<\/strong>, unless you are presenting it in a report or dashboard, as an end result. Raw data should never be in merged cells.<\/p>\n Merged cells can cause havoc while trying to sort data.<\/strong><\/p>\n Basically, you can’t sort data if it contains even a single merged cell. So you have to unmerge the cells before you can sort it.<\/p>\n Further, data in an Excel Table can’t be merged too.<\/strong> This is because sorting and filtering get affected if you merge cells in Excel. In this case, you have to convert the Excel table into a normal range. Then only you can centre the text.<\/p>\n Some of the older versions of Excel did not contain the Merge and center option<\/strong><\/em> in the ribbon. This method 2 works when you are using such older versions,s but it also works in newer versions of Microsoft Excel, including Office 365.<\/em><\/p>\n And this method does not merge the cells. It only centers the text. Thus, our earlier problem with merged cells is actually eliminated.<\/strong><\/p>\n To use this “Center across Selection” method, do the following steps:<\/strong><\/em><\/p>\n Step 1:<\/strong> Select the multiple cells where the text is to be centered. The text should be present within this range.<\/p>\n Step 2:<\/strong> Click on Format Cells<\/strong><\/em> (Shortcut Control<\/strong><\/em> + 1<\/strong><\/em> on Windows). Or right click<\/em> the mouse button on the selection, and pick Format Cells<\/strong><\/em> from the Options<\/strong> <\/em>menu.<\/p>\n Step 3:<\/strong> On the Format Cells dialog box,<\/strong><\/em> stay on the Alignment Tab<\/strong><\/em>. In the Text alignment dropdown showing “Horizontal<\/strong>“, you will see the default alignment set to “General<\/strong>“. Pick “Center across Selection”<\/strong> <\/em>from the selection. See screen shot below.<\/p>\n This will center the text across the selection. But the cells won’t be merged. This is the preferred way of centering a title in Excel.<\/p><\/blockquote>\n If you have clicked on Excel’s Merge and center text icon, and now decided to unmerge it, just select the text, and click on the “Merge and center<\/strong><\/em>” icon again. This button acts like a toggle switch. The merged cells will be unmerged, and the centered text will go back into the first unmerged single cell.<\/p>\n If large cells, the text may appear at the bottom left corner. If you want to change the cell alignment vertically and horizontally, you need to click the Middle Align<\/strong><\/em> button & Center<\/strong> <\/em>buttons under the Alignment group<\/em><\/strong> under Home Tab<\/strong><\/em>. Now the text will move to the center of the cell.<\/p>\n When you create an Excel Chart, by default a Chart Title<\/strong> is added in the centre. In some old versions of Excel, you might not get the Title in the Chart. And in some cases, Excel can’t figure out what title to put, because the column name happens to be blank. In this case, you will end up without a chart title at all. But you can add a chart title by hand, manually and then center it.<\/p>\n![\"title](\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/07\/merge-and-center.png?resize=993%2C441&ssl=1\")
<\/p>\nMethod 1: Merge and Center Title Text<\/h2>\n
![\"Merge](\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/07\/merge-and-center-small.png?resize=905%2C381&ssl=1\")
<\/p>\n![\"Middle](\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/07\/middle-align-button-small.png?resize=790%2C319&ssl=1\")
<\/p>\nMethod 2: Center Across Selection<\/h2>\n
![\"center](\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/07\/align-center-center.png?resize=887%2C611&ssl=1\")
<\/p>\nHow to Unmerge Cells in Excel<\/h2>\n
How to Align Text within a Single or Merged Excel Cell<\/h2>\n
How to Center a Title in Excel Charts<\/h2>\n
![\"Chart](\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/07\/chart-with-title-centered.png?resize=839%2C500&ssl=1\")
<\/p>\nSteps to Center the Chart Title in Excel<\/h3>\n
\n
\n<\/em><\/li>\n![\"Adding](\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/07\/chart-title-above-chart-in-center.png?resize=988%2C478&ssl=1\")
<\/em><\/li>\nPrint Excel worksheets with Worksheet titles in header or footer of the print out<\/h2>\n
\n
![\"File](\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/07\/file-name-in-center-of-page.png?resize=659%2C351&ssl=1\")
<\/li>\n