Paging down to last entry
 

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!

Paging down to last entry
 

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


"Richard" wrote:

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!

Paging down to last entry
 

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!

"Rae Drysdale" wrote:

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


"Richard" wrote:

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!

Paging down to last entry
 

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!
================================================== ===

"Richard" wrote in message
...
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!

"Rae Drysdale" wrote:

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


"Richard" wrote:

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!

Paging down to last entry
 

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 !
----------------------------------------------------------------------------
-------------------

"RagDyeR" wrote in message
...
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!
================================================== ===

"Richard" wrote in message
...
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!

"Rae Drysdale" wrote:

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


"Richard" wrote:

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!