How to set the print file to repeat a row on every page

  • Thread starter Thread starter Guest
  • Start date Start date
Easiest way is to go to the Page Set-up Properties.

Go to your "File" Menu
Select "Page Set-up"
Select "Sheets"

There are several features:

There will be a line asking you "Rows to repeat at top" with a rang
selector, use that and you should be set
 
File > Page Setup > Sheet tab. Click inside the box
marked "Rows to repeat at top" and select row 2 on the
sheet.

HTH
Jason
Atlanta, GA
 
When I go to the sheet tab, the boxes for Print tiles are greyed out and won't allow me to select rows or columns to repeat. Do you have any idea how to 'ungrey' the boxes?
 
I would suspect that you are accessing the "SetUp" menu *from* the
PrintPreview screen.
That doesn't work !

From the main WS screen, use:
<File> <PageSetUp> <Sheet> tab,
And you should find all features available (ungrayed).
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

When I go to the sheet tab, the boxes for Print tiles are greyed out and
won't allow me to select rows or columns to repeat. Do you have any idea how
to 'ungrey' the boxes?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row to repeat while printing 3
Repeating Rows - Exception 1
Print headings/labels on every page 3
Footer 1
Repeat Rows at Top - Except Final Page 2
Repeated rows when printing 2
Rows to repeat on every page does not work? 5
Insert automatic page numbering into a cell, not a header or foote 1

Back
Top