Excel Spreadsheet Heading

Copper Contributor

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
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

mtarler_0-1646960428443.png