Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply headings to all worksheets
I have a customized heading and footnote which I want to use for all
worksheets in one file. Can someone tell me how please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply headings to all worksheets
contor+tab of the worksheets . all worksheets will be selected
now you type in sheet 1 whatever header you want. it will be repeated in all the sheets remember to select any one of the sheets so that selection of all sheets is deselected "bill" wrote in message ... I have a customized heading and footnote which I want to use for all worksheets in one file. Can someone tell me how please? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply headings to all worksheets
If the cells of a spreadsheet with data in them cover one or several pages, then any header and footer will automatically be printed on one or several pages too. -- cycling-rod ------------------------------------------------------------------------ cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520 View this thread: http://www.excelforum.com/showthread...hreadid=495884 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply headings to all worksheets
One way would be to copy and paste the heading from your spreadsheet into a Header, and the footnotes into a footer. They will them be automatically printed on each page. Also, it is possible to repeat the printing of titles on every page: Quote from excel help file: If you have column or row labels on a worksheet, they can appear on every page of the printed worksheet. To set these print titles, click Page Setup on the File menu, and then click the Sheet tab. -- cycling-rod ------------------------------------------------------------------------ cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520 View this thread: http://www.excelforum.com/showthread...hreadid=495884 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Won't apply to all worksheets | Setting up and Configuration of Excel | |||
How do I save & apply sorts subtotals in excel to new worksheets? | Excel Discussion (Misc queries) | |||
apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
make custom header and footer in excel apply to all worksheets | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |