Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Larson the Red Dog
 
Posts: n/a
Default headers on excell worksheets

Does anyone know how I can have a header on only the first page of an Excel
Worksheet with no top margin above it, but still have the following pages
with a top margin that would have the text start at the same height as the
text on the first page? Think of using a letterhead for the first page &
blank paper for all pages thereafter.

Hopefully this makes sense. Need same info for Word.

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default headers on excell worksheets

In Excel you can set up your "header" by using the first few rows of
the worksheet - if you don't select these to be repeated at the top of
each page then you will have what you want.

In Word you can set up Section Breaks, with a different header in each
Section. You will thus need a Section Break at the bottom of page 1
with your header defined for page 1 but with no header for subsequent
pages.

Hope this helps.

Pete

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
Excell budget worksheets F_disk New Users to Excel 2 April 5th 06 11:04 AM
Excell Headers Ed Excel Worksheet Functions 1 March 5th 06 04:16 PM
how do i duplex different orientation worksheets in excell steve clarke Setting up and Configuration of Excel 1 January 31st 06 03:07 AM
Pre-set headers and footers for new worksheets robertwesley Excel Discussion (Misc queries) 4 April 27th 05 11:14 AM
In Excel, can I copy Headers and Footers between Worksheets? Brian Excel Worksheet Functions 1 November 12th 04 01:14 PM


All times are GMT +1. The time now is 02:05 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"