ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Worksheet (https://www.excelbanter.com/excel-worksheet-functions/235190-worksheet.html)

Denver

Worksheet
 
Hi,

I have a worksheet in excel 2003 I have around 10 headings in that worksheet
and there are about 5 pages when I click on print preview.

I want that my headings in each column of my worksheet be printed to all
those 5 pages, How to do that in excel? Only the first pages have the column
printed.


thanks for any help, I appreciate

joel

Worksheet
 
File - Page Setup - Sheet - Rows to repeat at top of each page

"Denver" wrote:

Hi,

I have a worksheet in excel 2003 I have around 10 headings in that worksheet
and there are about 5 pages when I click on print preview.

I want that my headings in each column of my worksheet be printed to all
those 5 pages, How to do that in excel? Only the first pages have the column
printed.


thanks for any help, I appreciate


Jacob Skaria

Worksheet
 
Select the headers rows from

FilePage SetupSheetPrint Titles'Rows to repeat at top'

If this post helps click Yes
---------------
Jacob Skaria


"Denver" wrote:

Hi,

I have a worksheet in excel 2003 I have around 10 headings in that worksheet
and there are about 5 pages when I click on print preview.

I want that my headings in each column of my worksheet be printed to all
those 5 pages, How to do that in excel? Only the first pages have the column
printed.


thanks for any help, I appreciate



All times are GMT +1. The time now is 03:09 PM.

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