ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I select a range of cells for header? (https://www.excelbanter.com/excel-programming/363922-how-can-i-select-range-cells-header.html)

emil

How can I select a range of cells for header?
 
How can I select a range of cells for header?
The cells are column labels in a table with many rows, and when I print it
I can not insert for each page that range.
Thanks for any help
Emil

Joergen Bondesen

How can I select a range of cells for header?
 
Hi Emil

Try Menu: Files - Page Setup - Sheet - Rows to repeate at top

In sheet when you scroll try: Select cell beneath 1st header to left -
Menu: Window - Freeze Panes

--
Best Regards
Joergen Bondesen


"emil" wrote in message
...
How can I select a range of cells for header?
The cells are column labels in a table with many rows, and when I print it
I can not insert for each page that range.
Thanks for any help
Emil




emil

How can I select a range of cells for header?
 
Thanks, with slight modification it looks like it will do the job.
I appreciate the work you put into the resolution. It was more than I
though it would take.
Emil


"Joergen Bondesen" a scris:

Hi Emil

Try Menu: Files - Page Setup - Sheet - Rows to repeate at top

In sheet when you scroll try: Select cell beneath 1st header to left -
Menu: Window - Freeze Panes

--
Best Regards
Joergen Bondesen


"emil" wrote in message
...
How can I select a range of cells for header?
The cells are column labels in a table with many rows, and when I print it
I can not insert for each page that range.
Thanks for any help
Emil






All times are GMT +1. The time now is 10:49 AM.

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