Lotus had buttons (icons) for first & last cell does excell?

[Marty]

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?

 

[Nick Hodge]

Marty

No Icon, but Ctrl+Home, Ctrl+End is the same thing

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[SteveW]

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)

 

[Gord Dibben]

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

 

[Debra Dalgleish]

And if Window>Freeze Panes is turned on, Ctrl+Home will activate the
first cell in the non-frozen part of the window.

 

[SteveW]

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