| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep one column or row static while others move?
I remember years ago being able to freeze for lack of better word a column or
a row. Then when the spreadsheet was moved, this column or row did not move. It helped when using column headers. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to keep one column or row static while others move?
I think what you're looking for is "Freeze Panes". Select the row beneath,
or column to the right, of the cells you want to "Freeze". Then select "Freeze Panes" from the "Windows" menu. HTH, Elkar "Help with Excel" wrote: I remember years ago being able to freeze for lack of better word a column or a row. Then when the spreadsheet was moved, this column or row did not move. It helped when using column headers. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move from one column to another after a set condition | Excel Worksheet Functions | |||
| move column headings from row to column | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| How do I get a column heading to show up at the top and not move . | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Linear Mode
