Thread: Lotus had buttons (icons) for first & last cell does excell?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default Lotus had buttons (icons) for first & last cell does excell?
And if WindowFreeze Panes is turned on, Ctrl+Home will activate the
first cell in the non-frozen part of the window.

Gord Dibben wrote:
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
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

Reply With QuoteReply With Quote