Having a Row Appear as the First Row on Every Page

  • Thread starter Thread starter guilbj2
  • Start date Start date
G

guilbj2

I have a large grid type sheet with a row about 60 columns wide with al
of the column headings in it. I'd like this row to apear as the firs
one on every page. I haven't been able to get it to work as a heade
so I'm looking for another solution. To date I've just copied an
pasted it but that means a lot of work to adjust page breaks etc. a
the report changes. If anyone knows how to get a row to appear as th
first one on every page, I'd really appreciate the advice
 
Hi

Go to File / Page Setup and the Sheet tab gives you the option of 'rows to
repeat at top'. Just enter $1:$1

Andy.
 
File>PageSetup>Sheet "Rows to Repeat At Top"

(Note: this setting is only available through File>PageSetup, not through
PageSetup in PrintPreview.)
 
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

Page Breaks- Printing selected rows on same page 1
Making first row Fixed/Static 2
rows and columns on worksheet 1
Remove page breaks 2
how can i print (row) titles on all pages except the last page? 3
reference every other row 2
Repeating first Row AND first column on every page 1
REPEAT ROW HEADINGS ON EACH PAGE 1

Back
Top