Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
headers in worksheet
I have a six page worksheet or workbook as a template. The top part looks
like a header but is not because nothing come up in view header/footer. Presently the six individual sheets of the worksheet do not appear connected: 1. How can i put the contents of say the top five lines into a header? 2. how do i then link the sheets for header/footer so that any change in one say the third sheet appears on the other sheets also? If you feel I have asked too much, the answer to 1. is more important than 2. Thank you Aamir |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
headers in worksheet
Hi
"aamir" wrote in message ... I have a six page worksheet or workbook as a template. The top part looks like a header but is not because nothing come up in view header/footer. You mean in File Page Setup Header/Footer? No need for this, instead check next tab of Page Setup Wizard (Sheet), right.click on selector button to right of 'Rows to repeat at top', and select top 5 rows from active sheet (or simply enter $1:$5 or whatever into this field). Repeat this for every page. Presently the six individual sheets of the worksheet do not appear connected: 1. How can i put the contents of say the top five lines into a header? 2. how do i then link the sheets for header/footer so that any change in one say the third sheet appears on the other sheets also? After you are finished with designing 1st sheet, link header fields on another worksheet to according header fields on designed one. P.e. you designed header for sheet Sheet1. On sheet Sheet2 into cell A1 ebter the formula =IF(Sheet1!A1="","",Sheet1!A1) , and copy this formula to whole header range. After that you may select the header range on Sheet1, copy it, select A1 on Sheet2, and paste special at first with Formats selected, and afterwards with Column Widths selected. But when you did have some header cells on Sheet1 formatted as text, then on Sheet2 according cells must be formatted as General (because no formulas will work in cells formatted as Text) Arvi Laanemets |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
headers in worksheet
A correction: must be
.... check next tab of Page Setup Wizard (Sheet), click on selector button to right of 'Rows to repeat at top', ... Arvi Laanemets |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
headers in worksheet
Arvi
To change one header & or footer and have all worksheets be changed group the worksheets you want affected. To group all between select the first one and hold the "Shift" key and select the last one and all will be "grouped". To only group selected worksheets select the first sheet you want changed and while holding "CTRL" select each sheet you want grouped, make your changes. When finished making your changes "UNGROUP" your worksheets. Because any change made to any one grouped worksheet is applied to all grouped worksheets. HTH Mike Rogers "Arvi Laanemets" wrote: Hi "aamir" wrote in message ... I have a six page worksheet or workbook as a template. The top part looks like a header but is not because nothing come up in view header/footer. You mean in File Page Setup Header/Footer? No need for this, instead check next tab of Page Setup Wizard (Sheet), right.click on selector button to right of 'Rows to repeat at top', and select top 5 rows from active sheet (or simply enter $1:$5 or whatever into this field). Repeat this for every page. Presently the six individual sheets of the worksheet do not appear connected: 1. How can i put the contents of say the top five lines into a header? 2. how do i then link the sheets for header/footer so that any change in one say the third sheet appears on the other sheets also? After you are finished with designing 1st sheet, link header fields on another worksheet to according header fields on designed one. P.e. you designed header for sheet Sheet1. On sheet Sheet2 into cell A1 ebter the formula =IF(Sheet1!A1="","",Sheet1!A1) , and copy this formula to whole header range. After that you may select the header range on Sheet1, copy it, select A1 on Sheet2, and paste special at first with Formats selected, and afterwards with Column Widths selected. But when you did have some header cells on Sheet1 formatted as text, then on Sheet2 according cells must be formatted as General (because no formulas will work in cells formatted as Text) Arvi Laanemets |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
headers in worksheet
Arvi
I just re-read your post!!! You can still effect the change you want by grouping, changing the top five rows and ungrouping. By grouping you can formate and place the top five the way you want. Group, entering the info you want and ungroup. There are some limitations with this but not knowing you layout this should get you in the ball park. HTH Mike Rogers "Mike Rogers" wrote: Arvi To change one header & or footer and have all worksheets be changed group the worksheets you want affected. To group all between select the first one and hold the "Shift" key and select the last one and all will be "grouped". To only group selected worksheets select the first sheet you want changed and while holding "CTRL" select each sheet you want grouped, make your changes. When finished making your changes "UNGROUP" your worksheets. Because any change made to any one grouped worksheet is applied to all grouped worksheets. HTH Mike Rogers "Arvi Laanemets" wrote: Hi "aamir" wrote in message ... I have a six page worksheet or workbook as a template. The top part looks like a header but is not because nothing come up in view header/footer. You mean in File Page Setup Header/Footer? No need for this, instead check next tab of Page Setup Wizard (Sheet), right.click on selector button to right of 'Rows to repeat at top', and select top 5 rows from active sheet (or simply enter $1:$5 or whatever into this field). Repeat this for every page. Presently the six individual sheets of the worksheet do not appear connected: 1. How can i put the contents of say the top five lines into a header? 2. how do i then link the sheets for header/footer so that any change in one say the third sheet appears on the other sheets also? After you are finished with designing 1st sheet, link header fields on another worksheet to according header fields on designed one. P.e. you designed header for sheet Sheet1. On sheet Sheet2 into cell A1 ebter the formula =IF(Sheet1!A1="","",Sheet1!A1) , and copy this formula to whole header range. After that you may select the header range on Sheet1, copy it, select A1 on Sheet2, and paste special at first with Formats selected, and afterwards with Column Widths selected. But when you did have some header cells on Sheet1 formatted as text, then on Sheet2 according cells must be formatted as General (because no formulas will work in cells formatted as Text) Arvi Laanemets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring data from one worksheet to another based on criteria | Excel Discussion (Misc queries) | |||
Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |