Forum Discussion
revert to original row order
Hello, probably a dumb/obvious answer to this, however; I have a spreadsheet with rows ordered in a logical format for it's intended use. I want to be able to filter by one or more of the columns, wh...
DanBScott Filtering and unfiltering should not change the order of the data, but sorting will. So, when you want to be able to reset the sort order to its original state you indeed need an indexing column.
With respect to wanting an empty row between sections in a data set is generally a bad idea. It will make it more difficult to use some of Excel's built-in capabilities in case you ever want to create reports/summaries out of the whole data set.
- thanks Riny
