+ Reply to Thread
Results 1 to 2 of 2

accidental autosum huge document

Hybrid View

  1. #1
    Registered User
    Join Date
    11-21-2011
    Location
    boston, ma
    MS-Off Ver
    Excel 2007 /2010
    Posts
    2

    accidental autosum huge document

    So I have created the biggest "oops" in my life. I have a 45 page spreadsheet that i accidentally clicked one of the whole colums and clicked autosum. This has created a little bit more that 1 million rows. I have tried undo-ing, copying the content i need and deleting the column, and even trying to delete each row. Nothing has worked yet and I am desperately trying to find the answer to this question.

    It is actually quite easy to recreate: open an excel spreedsheet, add a few numbers in the same column, click the header of the column to select the whole column, and then click autosum.

    I would like to thank everyone in advance for helping me with this problem.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,229

    Re: accidental autosum huge document

    Hi powpow and welcome to the forum,

    Click at the bottom of the column you have selected autosum on and then press Ctrl-DownArrow. This will/should take you to the bottom of the sheet and you should see the formula to Sum all the rows above it. Clcik on this cell and delete the formula.

    This should undo the AutoSum formula and get you back to where you were.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1