Centre a title across a worksheet

Its really easy to make your spreadsheets look more professional by centering your tittle across the top of your sheet.

In the example our heading for our sales sheet is ‘SalesWidgets Inc’.  This is currently in cell A1.

To centre it highlight cells A1:D1 and in Excel 2007 on the Home tab hit merge and centre.

If you are using earlier versions of Excel

1. Highlight the cells and right click on them

2. Select the format cells.

3. Hit the Alignment tab.

4. Select the cells to centre your title across

5. Click the Merge and Centre button on the formatting toolbar,

Your title will be centred across the range of cells that you selected.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.