Use rows 1-3 for header on all 13 pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My spreadsheet has 15 columns of numbers and is quite long. I want the first
3 rows (my header) to print at the top of each page. Is there a way to do
this.

Thanks,
SJL
 
File>Page Setup>Sheet tab, Rows to repeat at top

--
Kind regards,

Niek Otten

| My spreadsheet has 15 columns of numbers and is quite long. I want the first
| 3 rows (my header) to print at the top of each page. Is there a way to do
| this.
|
| Thanks,
| SJL
 
I have done this but I'm not quite sure what to add in the space. What ever I
put it states "reference invalid" ... what am I doing wrong???
 
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

use a range for a print header 2
Row 1 HEADERS on EVERY printed page 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Printing header rows.. 5
spreadsheet 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
Access Sorting and grouping using multiple tables 0
Header in row to column 1

Back
Top