Excel Column Sorting Question
Is there a way to prevent certain columns from sorting on a sheet?
I have 5 columns of data – 1500 lines in A, their attributes are in columns B-E, listed in a header row (1), i.e., size, shape, color, etc.
I can filter all columns, just fine. Then, I added a ‘cheetsheet’ of text to remind me of what the attributes are for each column (B-E). I added this text in column G (leaving column F empty) with the hope that when I sort (filter) any other columns (A-E), the text in G would be unaffected.
Can I (easily) separate G from the filers and sorting in columns A-E?
Is there a way to prevent certain columns from sorting on a sheet?I have 5 columns of data – 1500 lines in A, their attributes are in columns B-E, listed in a header row (1), i.e., size, shape, color, etc. I can filter all columns, just fine. Then, I added a ‘cheetsheet’ of text to remind me of what the attributes are for each column (B-E). I added this text in column G (leaving column F empty) with the hope that when I sort (filter) any other columns (A-E), the text in G would be unaffected. Can I (easily) separate G from the filers and sorting in columns A-E? Read More