| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I fix (prevent scrolling) of part of an Excel worksheet?
How do I fix the first few rows of a .xls file so that they remain visible
when I scroll the worksheet down? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I fix (prevent scrolling) of part of an Excel worksheet?
Hi,
Use Freeze Pannels, Position yourself one row down the data you want to be visible and then go to the menu, Window, Freeze pannels "katherin" wrote: How do I fix the first few rows of a .xls file so that they remain visible when I scroll the worksheet down? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I fix (prevent scrolling) of part of an Excel worksheet?
Suppose you want the top 4 rows to remain on screen as you scroll
down. Position the cursor in cell A5 then click on Window | Freeze Panes. If you also want the first column to be visible if you scroll to the side, put your cursor in B5 and then Window | Freeze Panes. Hope this helps. Pete On Jan 5, 3:49*pm, katherin wrote: How do I fix the first few rows of a .xls file so that they remain visible when I scroll the worksheet down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lock a screen to prevent scrolling? | Excel Discussion (Misc queries) | |||
| Prevent both worksheets from scrolling when in arrange view? | Excel Worksheet Functions | |||
| how to prevent unlimited scrolling in unprotected cells | Excel Discussion (Misc queries) | |||
| Scrolling within a section of an excel worksheet | Excel Worksheet Functions | |||
| navigate in Excel worksheet without scrolling | Excel Worksheet Functions | |||
Hybrid Mode
