Forum Discussion
Unable to delete empty rows and columns
I am unable to delete empty cells / rows / columns from my worksheet - I choose Delete and nothing happens. I have tried just cutting and pasting my data to a new document, but all of the empty cells...
yes, that is what I have done - then nothing
Even with closing and reopening the file?
If Inquiry is available (check File->Options->COM Add-ins) you may try
yes, I have saved, closed, then re-opened and then performed delete and they are still there. I don't have 'inquire' I am using Excel 2016
Inquiry is for Pro versions and is not shown by default, you shall to activate it in Options.
Perhaps you may submit your file removing all sensitive information to play with it.