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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
Click to expand...

No, but Ctrl+Home and Ctrl+End work for me - though this isn't always the
default setting (iirc)
 
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
 
And if Window>Freeze Panes is turned on, Ctrl+Home will activate the
first cell in the non-frozen part of the window.
 
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
 
Back
Top