Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to freeze cells to always remain the same value
I want to be able to have all numbers in column a remain the same, no matter
if rows are deleted, or re-sorted with the other corresponding columns. How do I go about doing this? For example at the moment I have numbers 1-200 listed in column A, but when you do any sort function on any of the other columns it jumbles or the numbers around. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
cells visable and following. Not freeze | Excel Worksheet Functions | |||
Can formulas in cells be made to remain if the data is deleted? | New Users to Excel | |||
Can some cells remain unprotected in a protected spreadsheet ? | Excel Discussion (Misc queries) | |||
How do I freeze or lock cells to show up on each page without typ. | Excel Discussion (Misc queries) |