Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 447
Default Headings to appear on next pages?

How do I get the headings I choose for page 1 to appear on subsequent pages?
I'm sure its a protection thing, but need help!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default Headings to appear on next pages?

Hi,

From File Page setup, you may go to Sheet and use Rows to repeat at the
top

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Karen" wrote in message
...
How do I get the headings I choose for page 1 to appear on subsequent
pages?
I'm sure its a protection thing, but need help!


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,203
Default Headings to appear on next pages?

If you are talking about a single Excel tab that prints to multiple sheets of
paper, use File Page Setup and choose the [Sheet] tab in the dialog and
identify the rows from the top of the tab that you want to appear as headers
on each sheet printed.

Hope this helps.

"Karen" wrote:

How do I get the headings I choose for page 1 to appear on subsequent pages?
I'm sure its a protection thing, but need help!

Reply
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
how do I repeat page headings on seperate pages? popjams Excel Discussion (Misc queries) 1 November 20th 08 02:08 PM
Show headings on all pages Excel 2003 Bons Excel Discussion (Misc queries) 3 November 7th 08 01:54 PM
Print column headings on pages 1-7 only of an 8 page spreadsheet Frank Excel Discussion (Misc queries) 1 July 11th 07 08:32 PM
row headings on pages - proper formatting in page set up connie Excel Discussion (Misc queries) 1 May 18th 06 07:13 PM
Can I set column headings on every page and exlcude some pages? Julia Excel Discussion (Misc queries) 1 September 28th 05 05:13 PM


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

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

About Us

"It's about Microsoft Excel"