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, col...
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.
