how do I lock or freeze cells
 

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?

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?