| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't remember....please assist
I cannot remember how to do the row repeat from the workbook itself, so that
when I scroll down from page to page I can see the header that I have. Please assist. -- Fluffy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't remember....please assist
On Screen:
Choose cell in row below the one(s) you want to remain in view, then from the Menu bar: Windows | Freeze Panes Go there again later and use Windows |Unfreeze panes to undo it. In printout: File | Page Setup and on the Sheet tab, look for the 'Rows To Repeat at Top' area. Hope this helps some. "Latina" wrote: I cannot remember how to do the row repeat from the workbook itself, so that when I scroll down from page to page I can see the header that I have. Please assist. -- Fluffy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't remember....please assist
Maybe you mean WindowFreeze Panes. Select cell A2 first
-- Kind regards, Niek Otten Microsoft MVP - Excel "Latina" wrote in message ... |I cannot remember how to do the row repeat from the workbook itself, so that | when I scroll down from page to page I can see the header that I have. Please | assist. | -- | Fluffy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't remember....please assist
THANK YOU!!!!!!!
How simple.....I totally forgot that -- Fluffy "JLatham" wrote: On Screen: Choose cell in row below the one(s) you want to remain in view, then from the Menu bar: Windows | Freeze Panes Go there again later and use Windows |Unfreeze panes to undo it. In printout: File | Page Setup and on the Sheet tab, look for the 'Rows To Repeat at Top' area. Hope this helps some. "Latina" wrote: I cannot remember how to do the row repeat from the workbook itself, so that when I scroll down from page to page I can see the header that I have. Please assist. -- Fluffy |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't remember....please assist
THANK YOU!!!!!!
-- Fluffy "Niek Otten" wrote: Maybe you mean WindowFreeze Panes. Select cell A2 first -- Kind regards, Niek Otten Microsoft MVP - Excel "Latina" wrote in message ... |I cannot remember how to do the row repeat from the workbook itself, so that | when I scroll down from page to page I can see the header that I have. Please | assist. | -- | Fluffy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't able to open a particular file in excel 97. Please assist. | Excel Discussion (Misc queries) | |||
| Rosters - is there a function or formula to assist with this | Excel Discussion (Misc queries) | |||
| Excel does not remember printer settings | Setting up and Configuration of Excel | |||
| can't remember password | Excel Worksheet Functions | |||
| I downloaded excel and don't remember password how do I get | Excel Discussion (Misc queries) | |||
Linear Mode
