Forum Discussion

LynRiddle's avatar
LynRiddle
Copper Contributor
Mar 11, 2022

Excel Spreadsheet Heading

Please can someone help with the following;

 

I am doing a very basic spreadsheet, heading across the top, customer names down column A.

 

Without inserting a page break as I print I would like my heading Row 1 & 2 to appear on each sheet without having to retype it please.

2 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Goto Page Layout -> click Print Titles. In the Page Setup pop up window you should be on the tab called Sheet. Then the 3 line is "Rows to repeat at top:" and enter 1:2

Resources