Why would Show All not be active in Filter part of Data menu?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Is there a filter applied to the table? Maybe all the records are
currently showing, so Show All isn't applicable.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro - filter - show all data 2
Excel filter dropdown shows all data 3
Referncing Rows of Filtered Data 8
DROP DOWN MENU "source" 5
Formula to count text string in column cells of filtered rows 3
Create "other" filter 5
Showing the function in the active cell 5
Not filtering entire Database 2

Back
Top