Lotus had buttons (icons) for first & last cell does excell? Marty 08.07.2006 15:31:01 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?

Re: Lotus had buttons (icons) for first & last cell does excell? "Nick Hodge" <nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS> 08.07.2006 15:54:52 Marty No Icon, but Ctrl+Home, Ctrl+End is the same thing -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS "Marty" <Marty[ at ]discussions.microsoft.com> wrote in message news:B04CA6C8-16EF-4759-9B4A-A22794A979B4[ at ]microsoft.com... [Quoted Text] > 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?

Re: Lotus had buttons (icons) for first & last cell does excell? SteveW <sj_walton[ at ]nothotmail.com> 08.07.2006 15:59:11 On Sat, 08 Jul 2006 16:31:01 +0100, Marty = <Marty[ at ]discussions.microsoft.com> wrote: [Quoted Text] > Lotus used to have two icons, one that took you to the first cell of t= he > 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 th= e = default setting (iirc) -- = Steve (3)

Re: Lotus had buttons (icons) for first & last cell does excell? Gord Dibben <gorddibbATshawDOTca> 08.07.2006 16:17:58 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 On Sat, 8 Jul 2006 08:31:01 -0700, Marty <Marty[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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?

Re: Lotus had buttons (icons) for first & last cell does excell? Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 08.07.2006 16:23:56 And if Window>Freeze Panes is turned on, Ctrl+Home will activate the first cell in the non-frozen part of the window. Gord Dibben wrote: [Quoted Text] > 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 > > > > On Sat, 8 Jul 2006 08:31:01 -0700, Marty <Marty[ at ]discussions.microsoft.com> > wrote: > > >>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? > > -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html

Re: Lotus had buttons (icons) for first & last cell does excell? SteveW <sj_walton[ at ]nothotmail.com> 08.07.2006 16:39:28 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 On Sat, 08 Jul 2006 17:17:58 +0100, Gord Dibben <gorddibbATshawDOTca> = wrote: [Quoted Text] > 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 > > > > On Sat, 8 Jul 2006 08:31:01 -0700, Marty = > <Marty[ at ]discussions.microsoft.com> > wrote: > >> 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? > -- = Steve (3)