Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - data autofilter, then data sort how do you view all
Once you've selected the data auto filter and then data sort, how do you go
back and view all the original data. The data is still there, but now you have to select the auto filter dropdown button to view the other data. Do you know how to fix this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - data autofilter, then data sort how do you view all
Hi Peg,
The first choice on the AutoFilter drop-down is (All). Select this. If your AutoFilter spans several columns, you may have to do it on each column, although I think you just need do it to the last column you filtered. Have I understood your question? Regards - Dave. "Peg" wrote: Once you've selected the data auto filter and then data sort, how do you go back and view all the original data. The data is still there, but now you have to select the auto filter dropdown button to view the other data. Do you know how to fix this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - data autofilter, then data sort how do you view all
That is normal.
Nothing to "fix" Gord Dibben MS Excel MVP On Wed, 23 Apr 2008 11:30:01 -0700, Peg wrote: Once you've selected the data auto filter and then data sort, how do you go back and view all the original data. The data is still there, but now you have to select the auto filter dropdown button to view the other data. Do you know how to fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
how do I view all the data on a CD-R if it is too big for excel? | Excel Discussion (Misc queries) | |||
Create view using data autofilter | Excel Discussion (Misc queries) | |||
Excel 2002 - Is it possible to use Data,Filter,Autofilter as X-Axi | Charts and Charting in Excel |