| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock a section of cells in place
I need to lock A1 - B25 in place so that when I scroll vertically they stay
and the right half of the sheet scrolls. I'd be fine with columns A and B locked with C on scrolling. I've tried freeze panes and split, but the info I need stationary still scrolls up and down with the rest of the page. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I lock a section of cells in place
Hi,
Try selecting cell C26 and then freeze panes. Hope this helps, Gav "Fenig D." wrote: I need to lock A1 - B25 in place so that when I scroll vertically they stay and the right half of the sheet scrolls. I'd be fine with columns A and B locked with C on scrolling. I've tried freeze panes and split, but the info I need stationary still scrolls up and down with the rest of the page. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find percentage of filled cells in one section | Excel Discussion (Misc queries) | |||
| place a blank row above certain cells | Excel Worksheet Functions | |||
| Lock row in place | Excel Discussion (Misc queries) | |||
| Lock column/row in place | Excel Discussion (Misc queries) | |||
| Lock a Chart in Place | Charts and Charting in Excel | |||
Linear Mode
