Without the Filter buttons on the top, I tried to show hidden rows by unhiding rows without success…
So what to do to show all value?
No panic. What you saw was a result from Advanced Filter. You may clear the filter easily: Data->Filter->Clear
Here we go!
If your hidden rows was not a result from advanced filter, you may want to read When unhide rows doesn’t work.
How can we filter a specific date ignoring years? For example, show only 1st of January of all years (say you have 10-years data). If you know how, please feel free to share with us by leaving a comment. Answers to be posted next week. 🙂