Choose Spreadsheet Title For Free

Use a Header Click the Insert tab. Click the Header & Footer button on the ribbon. The spreadsheet zooms out slightly and the Click to add header text box opens at the top of the spreadsheet. Click into the text box and type the spreadsheet title.

Excel Print Titles - YouTube YouTube Start of suggested clip End of suggested clip In the page Layout tab under the page setup group click the print titles command. If you wantMoreIn the page Layout tab under the page setup group click the print titles command. If you want columns to repeat at the left.

Click the top edge of the column header or the column in the table. The following selection arrow appears to indicate that clicking selects the column. Note: Clicking the top edge once selects the table column data; clicking it twice selects the entire table column.

Use a Header Click the Insert tab. Click the Header & Footer button on the ribbon. The spreadsheet zooms out slightly and the Click to add header text box opens at the top of the spreadsheet. Click into the text box and type the spreadsheet title.

Print column titles on every page Click the sheet. On the Layout tab, under Print, click Repeat Titles. Under Print titles, click in the Rows to repeat at top box, and then on the sheet, select the row that contains the column titles.Click OK. On the File menu, click Print.

Insert a cover page On the Insert tab, click Cover Page. Click a cover page layout from the gallery of options. After you insert a cover page, you can replace the sample text with your own text by clicking to select an area of the cover page, such as the title, and typing your text.

Click the cell, and then drag across the contents of the cell that you want to select in the formula bar. Press F2 to edit the cell, use the arrow keys to position the insertion point, and then press SHIFT+ARROW key to select the contents.