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. |
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