View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.