How do I create a header row in Excel 2010?
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. –OR– Click the Table Design tab > Style Options > Header Row.
How do you put headings on an Excel spreadsheet?
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.
How do I put a header on every page in Excel?
Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles]. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].
How do I get column headings to print on every page in Excel?
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.
How do I print headings on every page in Excel?
How do you make headings in Excel appear on every page?
How to Repeat Excel Spreadsheet Column Headings at Top of Page
- Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles].
- Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon.
- Click and select the row you wish to appear at the top of every page.
What is column headings in Excel?
In Excel and Google Sheets, the column heading or column header is the gray-colored row containing the letters (A, B, C, etc.) used to identify each column in the worksheet. used to identify each row in the worksheet.