 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2004Control+ End should take you to end of data but....
... due to formatting changes or something my the contol+end takes you to the very last possible cell available. How can I reset Contol+End to take me to the last cell of actual Data? Go to the row after the data ends, select the whole row, press ctrl + down arrow do edit>delete do the same for the columns but press ctrl + right arrow, do edit>delete save the workbook  SignatureRegards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "ng1001 (remove this) @cox.net" <anonymous@discussions.microsoft.com> wrote > ... due to formatting changes or something my the > contol+end takes you to the very last possible cell > available. How can I reset Contol+End to take me to the > last cell of actual Data? Thanks Peo, >-----Original Message----- >Go to the row after the data ends, select the whole row, press ctrl + down [quoted text clipped - 11 lines] > >. Thanks Peo I had tried that earlier but that did not correct it. After your reply, I tried again just to be sure and still no luck. I could copy and paste just the active cells in a new worksheet but this means juggling 45K lines worth of data plus a large array formula. Trying to copying that over blows the whole thing up - not enough memory - therefore I have to start over! Was hoping to find a way to reset the "end"!I do appreciate your input! Thanks and have a good evening! Tina C. >-----Original Message----- >Go to the row after the data ends, select the whole row, press ctrl + down >arrow [quoted text clipped - 10 lines] > >. Tina, Peo's suggestion is correct, only it will take effect once yoyu have saved the workbook after you delete the rows and columns, not before. Nikos "ng1001 (remove this) @cox.net" <anonymous@discussions.microsoft.com> wrote > Thanks Peo > I had tried that earlier but that did not correct it. [quoted text clipped - 27 lines] > > > >. You might even have to close and re-open the workbook. SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- snip Shouldn't that be "Shift + End + DownArrow"? Crtl + DownArrow select row 65536 only. Not much point in deleting one row. Gord Dibben Excel MVP >Tina, > [quoted text clipped - 35 lines] >> > >> >. Thanks Peo and Nikos! Here I was beating my head againest the wall and it was something as simple as deleting, saveing, closing and reopening!! And, yes I did try it and it worked wonderfully! Thanks for your time and energies on this. Have a great weekend : ) >-----Original Message----- >Tina, [quoted text clipped - 3 lines] > >Nikos There are instructions here for manually or programmatically resetting the used range: http://www.contextures.com/xlfaqApp.html#Unused ng1001 (remove this) @cox.net wrote: > Thanks Peo > I had tried that earlier but that did not correct it. [quoted text clipped - 34 lines] >> >>. SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.