Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
vba select a range of cells | Excel Programming | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
select a range using "cells()" | Excel Worksheet Functions | |||
How to select range of cells | Excel Programming |