ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   headers on excell worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/85427-headers-excell-worksheets.html)

Larson the Red Dog

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.

Pete_UK

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



All times are GMT +1. The time now is 11:40 AM.

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