Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why would Show All not be active in Filter part of Data menu?
When I attemp to use the "Show All" function in Filter under the "Data" menu
for deleting duplicate rows, the "Show All" is inactive (gray). What would cause Show All not to be active and what should I do to rectify the problem. Thanks much |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why would Show All not be active in Filter part of Data menu?
Is there a filter applied to the table? Maybe all the records are
currently showing, so Show All isn't applicable. Larry wrote: When I attemp to use the "Show All" function in Filter under the "Data" menu for deleting duplicate rows, the "Show All" is inactive (gray). What would cause Show All not to be active and what should I do to rectify the problem. Thanks much -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |