When you start creating a worksheet you may not be sure how many columns you are going to use, so may just type a title or heading in row 1; once you have got your data into the worksheet, you may well decide that it would look better if your title was centred across the columns containing the main portion of your data.
To achieve this, in whichever version of Excel you are using, click in the first cell of the columns that you want to have text centred in, then drag with the mouse until you reach the last cell. Release the mouse.
If using Excel 2007, Excel 2010 or Microsoft Excel 2013, from the Home tab, in the Alignment group, click the
View original post 30 more words