+ Reply to Thread
Results 1 to 3 of 3

Deleting unwanted and empty rows...

  1. #1
    Jim
    Guest

    Deleting unwanted and empty rows...

    Hello,

    I'm setting up a Sales Journal in Excel. I only need 50-60 rows and the
    document I have open and set up has over 65,000 rows. And...of course....the
    totals for the columns appear at the very bottom (row 65,000+)

    So....how do I get rid of all those rows??? I've tried to highlight and
    delete but they don't go away?????

    As always....thanks for your help!
    --
    CWJ

  2. #2
    Bob Phillips
    Guest

    Re: Deleting unwanted and empty rows...



    "Jim" <Jim@discussions.microsoft.com> wrote in message
    news:DD0F2941-3865-4818-BA7E-6440803B6990@microsoft.com...
    > Hello,
    >
    > I'm setting up a Sales Journal in Excel. I only need 50-60 rows and the
    > document I have open and set up has over 65,000 rows. And...of

    course....the
    > totals for the columns appear at the very bottom (row 65,000+)


    Why do they?

    >
    > So....how do I get rid of all those rows??? I've tried to highlight and
    > delete but they don't go away?????


    A spreadsheet has 65000+ rows. You can't delete the excess, there will
    always be 65000+



  3. #3
    Henry
    Guest

    Re: Deleting unwanted and empty rows...

    Jim,

    Put your totals in row 70 and ignore all that is below that row.

    Henry


    "Jim" <Jim@discussions.microsoft.com> wrote in message
    news:DD0F2941-3865-4818-BA7E-6440803B6990@microsoft.com...
    > Hello,
    >
    > I'm setting up a Sales Journal in Excel. I only need 50-60 rows and the
    > document I have open and set up has over 65,000 rows. And...of
    > course....the
    > totals for the columns appear at the very bottom (row 65,000+)
    >
    > So....how do I get rid of all those rows??? I've tried to highlight and
    > delete but they don't go away?????
    >
    > As always....thanks for your help!
    > --
    > CWJ




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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