Forum Discussion
How to delete a hidden row in Excel
I have had an unsubscribe request from someone on our Excel database. However that row seems to be hidden. NOTE: I have gone through all instructions on the help menu, to no avail. If I copy and pas...
Maybe it's not hidden but filtered. Go to the Data menu and select Clear Filter.
Thanks. Unfortunately, the "Clear Filters" is greyed out on my PC. Would someone in IT know how to change this do you think?
- If 'Clear' is dimmed out, it seems to suggest your data does not have a filter applied. Getting back to hidden rows, you could use the technique described here which is for unhiding first row and/or column (but is applicable to this situation for the method used to unhide).
https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9