Turn On Spreadsheet Title For Free

When you have the file open in Excel, go to File -> Info. The screen should now show the properties near the top right of the screen. Click on the Title text and change to what you want.

Here's how: On the Insert tab, in the Text group, click Header & Footer. This will display the worksheet in Page Layout view and get the Design tab to appear. On the Design tab, in the Header & Footer group, click the Header or Footer button, and select the built-in header or footer of your choosing.

Show or hide the Header Row 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.

Click on the cell where you want to reference the current sheet name. Type =CELL("filename") in the formula bar and press Enter. The result will be a string that contains the full path and name of the workbook, followed by a square bracket, followed by the sheet name in quotes. For example: [Book1.

Print row or column titles on every page Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK. On the File menu, click Print.

Rename a worksheet Double-click the sheet tab, and type the new name. Right-click the sheet tab, click Rename, and type the new name. Use the keyboard shortcut Alt+H > O > R, and type the new name.

Show or hide the Header Row 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.