Forum Discussion
Solved
Can I lock a column so it doesn't get sorted?
I have created a table on a sheet in excel. I made the first column a column of numbers, 1-100, so that when I print it all my rows will be numbered for easy reference. ie. me telling "Joe" look at l...
I ended up just creating a column to the left that wasn't included in the table that was numbered.
What I did was grids. The bold outline tells Excel that's a Header and don't sort that. I made a simple set when I decided I wanted to sort all the streaming music I listen to into a playlist of stuff I like to listen to. Then I noticed Pandora would put their concert dates in, so I extended it. My excel would be set like A (Artist) B (Song) C (Tour Date) D (Venue) E (Playlist) < an X if it was added to my faves.
The problem I came into was that 1 line of all the top stuff was sorted into it. AC/Dc would be before Artist if I sorted that way. What I did for a simple fix, was put thick outside borders for that top line.
The problem I came into was that 1 line of all the top stuff was sorted into it. AC/Dc would be before Artist if I sorted that way. What I did for a simple fix, was put thick outside borders for that top line.