| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Freezing a cell range
In my shared excel file, users will be adding information to the first free
row at the bottom of a list. I want to be able to freeze the top 5-6 "header" rows so that when users add new rows at the bottom, the "header" stays at the top and won't get pushed out of sight. I don't believe this is the same as protecting the cell range. I can split the screen to keep it there, but was wondering if there is a more elegant way of doing this. tia, -- JMorrell |
|
#2
|
|||
|
|||
|
Select cell A7.
Choose Window/Freeze Panes. In article , "JMorrell" wrote: In my shared excel file, users will be adding information to the first free row at the bottom of a list. I want to be able to freeze the top 5-6 "header" rows so that when users add new rows at the bottom, the "header" stays at the top and won't get pushed out of sight. I don't believe this is the same as protecting the cell range. I can split the screen to keep it there, but was wondering if there is a more elegant way of doing this. |
|
#3
|
|||
|
|||
|
If you want to freeze the top 6 rows on place, click into Cell A7 and choose
Window | Freeze Panes. tj "JMorrell" wrote: In my shared excel file, users will be adding information to the first free row at the bottom of a list. I want to be able to freeze the top 5-6 "header" rows so that when users add new rows at the bottom, the "header" stays at the top and won't get pushed out of sight. I don't believe this is the same as protecting the cell range. I can split the screen to keep it there, but was wondering if there is a more elegant way of doing this. tia, -- JMorrell |
|
#4
|
|||
|
|||
|
Perfect! Thank you.
"JE McGimpsey" wrote: Select cell A7. Choose Window/Freeze Panes. In article , "JMorrell" wrote: In my shared excel file, users will be adding information to the first free row at the bottom of a list. I want to be able to freeze the top 5-6 "header" rows so that when users add new rows at the bottom, the "header" stays at the top and won't get pushed out of sight. I don't believe this is the same as protecting the cell range. I can split the screen to keep it there, but was wondering if there is a more elegant way of doing this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Cell value as chart scale maximum | Charts and Charting in Excel | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Linear Mode
