I am a newbie for excel, so please excuse if this is a easy question.
I am trying to lock the entire row so that when I sort by a column all data to left and right of the column sorted stays in the same rows as originally was with sorted data.
Example
a 9 8 7 6
c 0 5 5 1
b 8 3 0 5
If sorted on column A new table would look like this
a 9 8 7 6
b 8 3 0 5
c 0 5 5 1
Thanks in advance for any help.
Bookmarks