How to add a header to an excel table?

Open the excel table to which you want to add the header, and find the page layout above the excel table. Click on the page layout and find the print title. Click Print Title to find the title line at the top of the print. Select the title line with the mouse, click OK, and then open the print preview to see that there are titles on each page to be printed.

Demonstration model: Huawei MateBook X system version: win 10 APP version: excel20 13 1. Open the excel table with header and find the page layout above the excel table.

2. Click on the page layout and find the print title.

3. Click Print Title to find the title line at the top of the print.

4. Select the title line with the mouse, click OK, and then open the print preview to see that there are titles on each page to be printed.

Excel common shortcut key: Ctrl+N to create a new blank workbook.

Ctrl+O open

Ctrl+S save

Ctrl+P printing

Ctrl+C/V copy or paste

Ctrl+F/H find or replace

Ctrl+A selects all or pops up the function parameter window (enter the function, and the shortcut key pops up the function window).

Ctrl+X cut

Ctrl+Z undoes the last operation.

Ctrl+Y/F4 repeats the previous operation.

Ctrl+G/F5 navigation (go)

Ctrl+ 1 cell format

Ctrl+↓↓→ arrive quickly.

Ctrl+Shift+↓↓→ Select quickly.

Ctrl+Shift+L Filter or Unfilter

Ctrl+Enter batch input content