We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Want to become a Forum Ambassador? Visit the Community Noticeboard for details on how to apply

Insert new columns at end of Excel spreadsheet

Jolaaled
Jolaaled Posts: 1,063 Forumite
Part of the Furniture 500 Posts Name Dropper Combo Breaker
in Techie Stuff
Hi all...really hope someone can help!

I have a large Excel (MS 2007) spreadsheet that I use for my personal budgetting.

It's pretty big and finally, I have reached column 'IV'. I now need to enter new data on further columns, but, for some reason, I am unable to add anymore columns. (Have tried the usual: right click-insert-columns) I'm using MS Excel 2007 Home version.

I get an error message to say that I need to clear cells..have done that...the cells in my final column are cleared...but I still cannot add new columns.

If anyone can help, it would be really appreciated!!

THANK YOU

Comments

  • Andy_L
    Andy_L Posts: 13,154 Forumite
    Part of the Furniture 10,000 Posts Name Dropper
    Haven't got excel on this computer to check but having reached column IV that may be the maximum number of columns (256 IIRC) you can have in your version of excel.
  • System
    System Posts: 178,419 Community Admin
    10,000 Posts Photogenic Name Dropper
    You need to save your spreadsheet as a 2007 spreadsheet (xlsx) and then re-open it. This should give you the 16k columns that Excel 2007 is capable of.
    This is a system account and does not represent a real person. To contact the Forum Team email forumteam@moneysavingexpert.com
  • Jolaaled
    Jolaaled Posts: 1,063 Forumite
    Part of the Furniture 500 Posts Name Dropper Combo Breaker
    !!!!!! wrote: »
    You need to save your spreadsheet as a 2007 spreadsheet (xlsx) and then re-open it. This should give you the 16k columns that Excel 2007 is capable of.

    It worked!!!! THANK YOU SO MUCH!!
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.9K Banking & Borrowing
  • 254.3K Reduce Debt & Boost Income
  • 455.2K Spending & Discounts
  • 246.9K Work, Benefits & Business
  • 603.5K Mortgages, Homes & Bills
  • 178.3K Life & Family
  • 261K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture