Add Spreadsheet Title For Free

On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.

Hold down SHIFT, and then select the same number of existing sheet tabs of the worksheets that you want to insert in the open workbook. For example, if you want to add three new worksheets, select three sheet tabs of existing worksheets. On the Home tab, in the Cells group, click Insert, and then click Insert Sheet.

Method 1: Insert the sheet name using built-in Excel functions. This formula obtains the filename ?=CELL(?filename?,A1)? and separates it after the character ?]?. If you want to get the name of another Excel sheet, you have to change the cell reference from ?A1? to any cell of the other worksheet.

Click anywhere in the table. On the Home tab on the ribbon, click the down arrow next to Table and select Toggle Header Row. Click the Table Design tab > Style Options > Header Row.

If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.

Follow these steps to do so: Click the "Insert" tab. Select the "Insert" tab from the top menu. ... Choose "Header & Footer" Select "Header & Footer" from the top menu. ... Select the header and add a title. Click on the newly added header at the top of the sheet.