LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
ESS Joan
 
Posts: n/a
Default format rows to print at top for multiple tabs

I regularly format large workbooks in Excel and would like to be able to
format all tabs with rows to repeat at the top of the page when printing.
When I highlight all tabs and go to page setup the rows to repeat at top
option is disabled. It would save a lot of time to be able to format the
entire workbook at once. How do I formatt many tabs within a workbook to
have a consistent area to print at the top of all sheets at once.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete empty rows from print in Excel Ashfaq Excel Worksheet Functions 2 March 27th 06 12:56 PM
print area selection slows excel, formula for hiding rows?? sbrimley Excel Discussion (Misc queries) 1 March 21st 06 11:26 PM
Print few rows with many colums so that rows wrap on printed pages usfgradstudent31 Excel Discussion (Misc queries) 1 October 20th 05 02:39 PM
How can I print noncontiguous rows on the same page? Mary A Walthall Excel Discussion (Misc queries) 1 April 26th 05 10:00 AM
make first few rows print on every page? CD New Users to Excel 3 January 3rd 05 06:07 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"