Excel set up print headers

Sometimes you need to display the header on every page so that you can see the data, so let's look at an exercise.

1. Start Excel

1 Click "Start-All Programs-microsoft-microsoft Office Excel 2003";

2 There is a blank window full of grid, this is a spreadsheet, the first grid look at the border to be thicker, in the selected state;

2, print the table head

1 to open the "score sheet" previously saved;

2 Use the automatic filling method, drag the contents of the datasheet to two pages;

3 point Menu "file-page settings", come out a dialog box;

4 Find the top right corner of the "Worksheet" tab, click to select, and then in the "Top header row" in Click;

5 Move the mouse to the worksheet, with the Drag method, select the first row and the second row, then click OK;

6 Point Menu "file-print preview", go to the second page to see, you can see also show the title;

Close the return to "Print header" as the filename, save the file to your own folder;