View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how do I lock or freeze cells

Just make sure all columns are selected prior to sorting on column B


Gord Dibben MS Excel MVP

On Thu, 16 Apr 2009 13:42:07 -0700, grunt_02_gunny
wrote:

I have alpha data A1-A99, on B1-B99 numbers. I would like to sort the imput
numbers in "B" BUT, keep A1-99 & B1-99 tied together i.e. A1 & B1 next A2 &
B2 ect, ect. If I add a third column "C" I would eventually want to insure I
could lock the data as well within i.e. A1, B1, & C1. How can this be done?