ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to get some rows and columns on every printed page (https://www.excelbanter.com/excel-programming/327416-how-get-some-rows-columns-every-printed-page.html)

helpwithXL

how to get some rows and columns on every printed page
 
Hi all,
Could someone please tell me how can I have a fixed number of rows and
columns printed on every printed page? by this i mean that i want to
have the first 5 rows (which contain calendar info like
year,month,calendar week etc) and first 2 columns ( which have project
names in first row and persons associated to that project in 2nd row)
of my excel sheet in all the printed pages.
i have a big excel sheet with 80-100 columns and 400-500 rows and
largest sheet available to me for printing is A3. so when i try to
print this my excel sheet, the first 5 rows and 2 columns only get
printed in the first printed sheet and not on the subsequent printed
sheets(so this is the normal or defualt print behaviour) and so i have
to always need the first printed sheet to find out, for example, a
month or a calendar week for printed sheets 2 onwards.
so basically i want the first 5 rows and 2 columns to be printed on
every printed sheet, something like top header and left header.
Can someone guide me in the right direction please.
TIA
amit


[email protected]

how to get some rows and columns on every printed page
 
Hi
Look in File, Page SetUp... and choose the Sheet Tab. You will see the
settings there.

regards
Paul



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

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