| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Sheet Page
How do I freeze a sheet page so you can't tab out of the area up or down? In
Excel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Freeze Sheet Page
Imagine your sheet is 10 columns wide by 40 rows. Highlight all the
columns from the 11th to the extreme right and Format | Column | Hide. Similarly, highlight all the rows from the 41st to the bottom and Format | Row | Hide. Hope this helps. Pete On Oct 11, 12:58*am, Marcus8 wrote: How do I freeze a sheet page so you can't tab out of the area up or down? In Excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I freeze a page tab? | Excel Worksheet Functions | |||
| freeze a heading so it will show on every page as I scroll down | Excel Discussion (Misc queries) | |||
| Why do Excel and Access freeze on the splash page? | Excel Discussion (Misc queries) | |||
| How do I freeze or lock cells to show up on each page without typ. | Excel Discussion (Misc queries) | |||
| freeze pane in a web page | Excel Discussion (Misc queries) | |||
Hybrid Mode
