how do I lock or freeze cells

G

grunt_02_gunny

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?
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
reverse pasting rows with alternate blank cells 0
Freeze Panes 5
Seperate text and number to different cells 3
Calculating Averages - Very Complex PLEASE HELP 7
copy and paste the cell with formula ="1" 3
Conditional Formatting with if statement 2

Top