+ Reply to Thread
Results 1 to 4 of 4

Clearing unseen data

  1. #1
    Ralphael1
    Guest

    Clearing unseen data

    I have a Excel page with data that ends at linbe 602 however when I
    click alt end it jumps down to 2750.
    I have tried deleting all the rown 603 to 2750 and clearing the
    contents but it does not work. Anyone have a to solve this.
    Thanks,
    Ralphael, the OLD one


  2. #2
    Niek Otten
    Guest

    Re: Clearing unseen data

    After deleting the rows, save the file. That will set the new last cell.

    --
    Kind regards,

    Niek Otten

    "Ralphael1" <[email protected]> wrote in message
    news:[email protected]...
    >I have a Excel page with data that ends at linbe 602 however when I
    > click alt end it jumps down to 2750.
    > I have tried deleting all the rown 603 to 2750 and clearing the
    > contents but it does not work. Anyone have a to solve this.
    > Thanks,
    > Ralphael, the OLD one
    >




  3. #3
    Gord Dibben
    Guest

    Re: Clearing unseen data

    And make sure you delete the rows, not just "Clear Contents".


    Gord Dibben Excel MVP

    On Thu, 1 Dec 2005 15:15:36 +0100, "Niek Otten" <[email protected]> wrote:

    >After deleting the rows, save the file. That will set the new last cell.



  4. #4
    Ralphael1
    Guest

    Re: Clearing unseen data


    Gord Dibben wrote:
    > And make sure you delete the rows, not just "Clear Contents".
    >
    >
    > Gord Dibben Excel MVP
    >
    > On Thu, 1 Dec 2005 15:15:36 +0100, "Niek Otten" <[email protected]> wrote:
    >
    > >After deleting the rows, save the file. That will set the new last cell.


    Thank you Gord, you have relieved a portion of my computer pain.

    Ralphael, the OLD one


+ 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