A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Clearing unseen data



 
 
Thread Tools Display Modes
  #1  
Old December 1st, 2005, 02:05 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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  
Old December 1st, 2005, 03:15 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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  
Old December 1st, 2005, 06:42 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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  
Old December 2nd, 2005, 12:25 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.