Add columns to Microsoft Excel spreadsheet

1137430 pts.
Tags:
Microsoft Excel
I was given a Microsoft Excel spreadsheet to work on from a co-worker (it was created by someone else). I noticed that after column IV, I can't add any more columns. It's just a shaded area. Is it not possible to add more columns?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
You should be fine as the max columns is 16,384. What version of Excel are you using? If this was created on another version of Excel you may have to have the original sender convert it so you can use it. OR try this

1- Open your file that has problem.

2- Select save as command from file menu.  

3- Select Excel 97-2003 format from Save as type. 

4- press Save button.

5- close your file.

6- then open the saved file.


Discuss This Question: 1  Reply

 
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.
  • ToddN2000
    You can also check to see if it's protected or restricted by this

    1. CTRL+A in the worksheet

    2. Right Click any cell > Format Cells > Protection tab > Uncheck Locked

    3. Review tab > Protect Sheet (Here you may choose what you want to allow users to do, leave Insert and Delete columns / rows unchecked)
    131,625 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: