Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freeze worksheet?
I use a workbook with a large number of worksheets.
Is it possible to freeze one or more worksheets, so they are always visible on screen? Also, is there a way of stopping worksheets from moving out of their original order? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freeze worksheet?
#1. Maybe you could use
window|New window (xl2003 menu system) Then use window|arrange|vertical (or what you want) And arrange them so that you can always see the worksheet you want in one of the windows. When you're tired of this, click on the window you want to close and hit ctrl-w. #2. You can protect the workbook's structure tools|protection|protect workbook|Check Structure (still xl2003 menu system) This stops you from inserting/deleting/hiding/unhiding/moving sheets. Be aware that this protection is easily broken, though. Ray wrote: I use a workbook with a large number of worksheets. Is it possible to freeze one or more worksheets, so they are always visible on screen? Also, is there a way of stopping worksheets from moving out of their original order? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Align Worksheet & Freeze Panes | Excel Discussion (Misc queries) | |||
Can I have multiple freeze panes in one worksheet? | Excel Worksheet Functions | |||
How do I freeze more than one location on my worksheet? | Excel Worksheet Functions | |||
freeze the worksheet panes | Excel Discussion (Misc queries) | |||
How do you "freeze" an excel worksheet? | Excel Worksheet Functions |