Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Location
    Ellettsville, Indiana, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    can't insert rows or columns in excel 2010.

    working in excel 2010, The spreadsheet stopped letting me insert rows or even columns. I don't know what I've done! No hidden rows, columns or data.
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Unsure as I opened it and could insert without a problem -- although I did get a warning that it could take some time because of the amount of adjustments.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I can instert rows. Inserting columns is a problem since row 1488 in Units has all the columns already filled...

    Some of the other worksheets have more area "used" than they should (click end-home to see what XL beleives is the last used row and column). Delete rows and columns at the ends of the data in each sheet, then resave the workbook and this should clean it up...

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •