Forum Discussion

Copper Contributor

Feb 17, 2020

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...

excel

SergeiBaklan

Diamond Contributor

Feb 17, 2020

G_Torres

Select them, try

and click on Save.

G_Torres
Copper Contributor
Feb 17, 2020
SergeiBaklan
yes, that is what I have done - then nothing
- SergeiBaklan
  Diamond Contributor
  Feb 17, 2020
  G_Torres
  
  Even with closing and reopening the file?
  
  If Inquiry is available (check File->Options->COM Add-ins) you may try
  - G_Torres
    Copper Contributor
    Feb 17, 2020
    SergeiBaklan
    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