Forum Discussion
Hypno60871
Sep 19, 2023Copper Contributor
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...
Patrick2788
Sep 19, 2023Silver Contributor
Maybe it's not hidden but filtered. Go to the Data menu and select Clear Filter.
AlphaHypnosisNZ
Sep 25, 2023Copper Contributor
Thanks. Unfortunately, the "Clear Filters" is greyed out on my PC. Would someone in IT know how to change this do you think?
- Patrick2788Sep 25, 2023Silver ContributorIf '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