Labels help identify spreadsheet data and present informative tables. When your data and label reside in a single column, applying Excel 2013's Center alignment effect is all that is required to center the label. However, things get more complicated when your data spans multiple columns because centering only applies the effect within a single cell. The solution is to merge multiple cells together and simultaneously center the resulting merged cell.
Type your label in the first column of the row located above your data. As an example, if your data resides in cells A2 through C20, enter your label in cell A1.
Click the label, and drag your mouse to select each data column on the same row. Continuing with the example, select cells A1 through C1.
Click the "Home" tab, and select the "Merge & Center" button in the Alignment group to merge the selected cells and center the label.
Tips & Warnings
- If you only need to center a label in a single cell, click the "Center" button from the Home tab's Alignment group.