ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   use a range for a print header (https://www.excelbanter.com/excel-discussion-misc-queries/85168-use-range-print-header.html)

sjl

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

Don Guillett

use a range for a print header
 
Filepage setupsheetrows

--
Don Guillett
SalesAid Software

"sjl" wrote in message
...
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




Gord Dibben

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




All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com