There are several ways to add a custom title to a spreadsheet in Microsoft Excel. Titles are not just for file names – you can place one just above the spreadsheet data so that viewers can more easily understand it.
Add a title to Excel
Click the “Insert”; tab at the top left of the workbook to add a title heading.
Click the “Text” menu to the right of the ribbon area and click the “Header and Footer” option.
You will zoom out from the workbook so you can see all your data on one page. We will describe how to get back to the normal view in a moment.
Click anywhere in the “Heading” section and enter your text.
To return to the default view of the workbook, click on the “Normal” page layout icon at the bottom of the document.
When you return to the “Normal” workbook view, you will notice that your text is not displayed. In Excel, these headings do not appear while you are working in the workbook, but they will appear after it has been printed. Keep reading if you are looking for a title bar that always pops up.
Add an always visible top row
If you want to add an always visible title, you can place it in the top row of the spreadsheet.
First right-click anywhere in cell A1 (the first cell at the top left of the spreadsheet) and select “Insert”.
Select “Full Row” and click “OK” to add a row of free space.
Write the title of the spreadsheet anywhere in the new line. The exact cell you choose does not matter because we merge them in just one second.
Select the part of your new line that you want to center your title in. In this case, we select from A1 to E1 and center our title in the top line.
Click the “Home” heading in the ribbon and click “Merge and Center.” Your text should now be centered within the new line.
That’s it – you can use these techniques to quickly add headings to your Excel spreadsheets in the future.