Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
sjl
 
Posts: n/a
Default use a range for a print header

I need the first 3 rows of my spreadsheet to show as a header on every page.
I have a lot of columns with numbers in them and need a header to follow
through on each page.

Thanks you for any help.
SJL
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default use a range for a print header

FilePage SetupSheet.

Rows to repeat at top.

Enter $1:$3


Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 12:59:02 -0700, sjl wrote:

I need the first 3 rows of my spreadsheet to show as a header on every page.
I have a lot of columns with numbers in them and need a header to follow
through on each page.

Thanks you for any help.
SJL


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multi-page print, but only one header miketv Excel Discussion (Misc queries) 0 February 22nd 06 04:22 PM
Print header Minerva Excel Worksheet Functions 0 February 21st 06 09:58 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 09:02 PM
FITTING HEADER ON SECOND PAGE TO PRINT katenwoods Excel Worksheet Functions 0 September 8th 05 06:38 PM
how to move header and footer within print margins excel Rohit Excel Discussion (Misc queries) 2 May 4th 05 04:52 PM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"