| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to freeze cells to always remain the same value
First lock the cells and then turn on sheet protection
-- Gary''s Student gsnu200708 "Alex" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to freeze cells to always remain the same value
In A1 enter =ROW()
Copy down to A200. Deleting rows or sorting will not affect column A. Gord Dibben MS Excel MVP On Thu, 1 Mar 2007 08:43:25 -0800, Alex wrote: 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. |
| Reply |
| 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) | |||
Linear Mode
