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.

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts