 |
 | 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 / July 2006Lotus had buttons (icons) for first & last cell does excell?
Lotus used to have two icons, one that took you to the first cell of the sheet and the second that took you to the last used cell of the sheet. ARe there icons in excel for this? Marty No Icon, but Ctrl+Home, Ctrl+End is the same thing  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > Lotus used to have two icons, one that took you to the first cell of the > sheet and the second that took you to the last used cell of the sheet. > ARe > there icons in excel for this? > Lotus used to have two icons, one that took you to the first cell of the > sheet and the second that took you to the last used cell of the sheet. > ARe > there icons in excel for this? No, but Ctrl+Home and Ctrl+End work for me - though this isn't always the default setting (iirc) SignatureSteve (3) No buttons. CTRL + Home will take you to A1. CTRL + End will take you to last cell in used range. Be aware that Excel has a habit of over-estimating the used range, so CTRL + End can take you to some pretty strange places. Gord Dibben MS Excel MVP >Lotus used to have two icons, one that took you to the first cell of the >sheet and the second that took you to the last used cell of the sheet. ARe >there icons in excel for this? And if Window>Freeze Panes is turned on, Ctrl+Home will activate the first cell in the non-frozen part of the window. > No buttons. > [quoted text clipped - 10 lines] >>sheet and the second that took you to the last used cell of the sheet. ARe >>there icons in excel for this? SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Neat little function I picked up (probably here) Sub Set_Sheet_Size() ActiveSheet.UsedRange End Sub Useful after you have redued the working size of the sheet, deleted unwanted columns etc etc click on the *real last cell* and run the function Steve > No buttons. > [quoted text clipped - 16 lines] >> ARe >> there icons in excel for this? SignatureSteve (3) |
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.