Excel 2013 will not allow me to delete columns

1124845 pts.
Tags:
Microsoft Excel
I have a huge issue with Excel 2013. A co-worker gave me this huge spreadsheet to work on with tables, graphs, etc. A couple of the sheets have empty columns that I want to delete but Excel won't let me. The document is password protected but I went ahead and added the password in with no issues. Still can't delete the columns. Any suggestions?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you don’t want the columns and they are in the middle of the spreadsheet , just hide them. Are you getting an error trying to delete them? It might be the cells are used in calculations or referenced by another spreadsheet.  

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Check if that particular file is in Read only mode. If yes, Excel will not allow to do any kind of work on the same file. If it is not in Read only mode, try opening this file on a different machine or in a later version of Excel and check if that helps.
    130,760 pointsBadges:
    report
  • azohawk
    You may need Modify rights to spreadsheet.
    3,990 pointsBadges:
    report
  • Subhendu Sen
    Also you can copy the whole contains of your document except the empty columns in another blank document or Excel file and save the file with different name. However this procedure is time consuming.
    130,760 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: