SpringWater
New Member
- Joined
- Jun 17, 2010
- Messages
- 9
How can I make the Autofilter function in Excel 2010 stop at a blank row? Excel 2010 ignores the blank row and sorts everything!
I have about 100 spreadsheets set up in Excel (pre-2010 version) which uses the blank row to limit the extent of the filter\sort. The blank row is not always the same row number.
For clarity, I need to sort data above the blank row but not below it and I would rather use the Autofilter dropdowns because it is not me doing the sorting, it is a variety of staff - so the simpler the better.
I have about 100 spreadsheets set up in Excel (pre-2010 version) which uses the blank row to limit the extent of the filter\sort. The blank row is not always the same row number.
For clarity, I need to sort data above the blank row but not below it and I would rather use the Autofilter dropdowns because it is not me doing the sorting, it is a variety of staff - so the simpler the better.