Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |