Forum Discussion
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?
If column F is empty, sorting columns A:E will not affect column G.
Hello Hans. Thank you for your quick reply. Words/terms matter - "sort" was the incorrect word to use. Sorry. What I meant is Filter. When I use filters to sort the data in A:E, all other cells get hidden as a result of the filter(s). Can I prevent filters from affecting other cells, like the text I've written in G? In other words, can I isolate G from the affects of A:E? I hope this clarifies my question. Thank you. HansVogelaar
A filter always hides entire rows, not just the columns in the range that you're filtering.
So it is not possible to hide rows in columns A:e while leaving the same rows in column G visible.
Thank you so much for the information.
