Filter seems locked

  • Thread starter Thread starter SShelton
  • Start date Start date
S

SShelton

I was working on a spreadsheet and had only one filter utilized. I now
cannot remove it, even with going to data, filter, show all. I removed the
filters and now only the filtered rows appear. How can I now "unfilter" this
worksheet to again see all of my data?
 
Select all the rows that have data and then click FORMAT in the menu, select
ROWS and then click UNHIDE.

Hopefully this will solve your problem...
 
Thanks for your reply. I tried this and it did not work. I will keep
playing around to see if I can fix it.... Tx.
 

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

data filters 1
Removing an Advanced Filter 3
Using the Median function with Auto-filter 1
Excel 2007 Filtering range 1
How do I Copy and Paste onto Same Rows after filtering out rows. 2
Restoring Filter 1
unfilter 2
How do I delete only the unfiltered row? 1

Back
Top