Store Spreadsheet Title For Free

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.

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.

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.

Save your workbook Click File > Save As. Under Save As, pick the place where you want to save your workbook. ... Click Browse to find the location you want in your Documents folder. ... In the File name box, enter a name for a new workbook. ... To save your workbook in a different file format (like . ... Click Save.

Excel Tricks - Freeze the Column Headings - YouTube YouTube Start of suggested clip End of suggested clip There are several choices but we'll select freeze top row. Now when scrolling through the documentMoreThere are several choices but we'll select freeze top row. Now when scrolling through the document the top row stays in view. So you can easily keep track of the columns.

Select the worksheet you want to add a header or footer to. Click the Insert tab, and click Header & Footer. This displays the worksheet in Page Layout view. The Header & Footer Tools Design tab appears, and by default, the cursor is in the center section of the header.

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.