Lotus 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?

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

Marty

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Marty" wrote in message
...
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 had buttons (icons) for first & last cell does excell?
 

On Sat, 08 Jul 2006 16:31:01 +0100, 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?

No, but Ctrl+Home and Ctrl+End work for me - though this isn't always the
default setting (iirc)

--
Steve (3)

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

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?

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

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

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:

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?




--
Steve (3)