If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
Clearing unseen data
After deleting the rows, save the file. That will set the new last cell.
-- Kind regards, Niek Otten "Ralphael1" wrote in message oups.com... 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
|
|||
|
|||
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" wrote: After deleting the rows, save the file. That will set the new last cell. |
#4
|
|||
|
|||
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" 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 06:55 PM |
Data Source issues. ??data.access.pages | Phil | Database Design | 2 | October 11th, 2004 02:42 AM |
Data Source issues | Philippe | Database Design | 1 | October 10th, 2004 09:45 PM |