title row

  • Thread starter Thread starter David Cleland
  • Start date Start date
D

David Cleland

Hi

I have an excel of about 150 rows the first row is a title when I print the
title is on the first page but not the others - can I get it to auto add to
each page ?

David
 
Use File | Page Setup; open the Sheet tab and set the Rows to be Repeated at
Top to cover the rows needed for you headings.
Note: you CANNOT do this from Print Preview |Page SetUp !
best wishes
 
Back
Top