Paging down to last entry

R

Richard

How do you page down to the last entry? Since I have formulas that do not
have any entries in them I want to page down to the last entry not the last
formula. Thanks in advance!
 
R

Rae Drysdale

Ctrl + End will take you to the last cell in the worksheet. Ctrl + Home will
take you to the first cell. Does this help?
 
R

Richard

Ctrl + End takes me to the last formula entered. since I've pasted the
formula down several thousand rows in advance, then I go back and enter data
as needed but sometimes I need to go back to the last entry not the last
formula. Kinda confusing? Thanks in advance!
 
R

RagDyeR

This *array* formula returns the row number:

=MAX((A1:A10000<>"")*ROW(A1:A10000))

--
Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the
regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

Since it's an array formula, you can't reference entire rows (A:A)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Ctrl + End takes me to the last formula entered. since I've pasted the
formula down several thousand rows in advance, then I go back and enter data
as needed but sometimes I need to go back to the last entry not the last
formula. Kinda confusing? Thanks in advance!
 
R

RagDyeR

Of course, I meant that you cannot reference entire *Columns* (A:A)!
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

This *array* formula returns the row number:

=MAX((A1:A10000<>"")*ROW(A1:A10000))

--
Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the
regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

Since it's an array formula, you can't reference entire rows (A:A)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Ctrl + End takes me to the last formula entered. since I've pasted the
formula down several thousand rows in advance, then I go back and enter data
as needed but sometimes I need to go back to the last entry not the last
formula. Kinda confusing? Thanks in advance!
 
Top