software

Is there a way to find by a row number or column letter like you can find by
data or cell reference? I couldn't find an option using CTRL F or the Data,
Form.

For example, if I am at the top of a worksheet and would like to quickly
move to row 782, how is this accomplished?

I searched the previous posts for this same question but did not find it.

Thanks!
Laura :-)

Hi Laura,
Try Edit/GoTo then key in whatever cell you're looking for, for instance
A782. I know I'm sending you to a specific cell, but I hope this is helpful
anyway.

Ellen :-D

quot;Laura Parsonquot; wrote:

gt; Is there a way to find by a row number or column letter like you can find by
gt; data or cell reference? I couldn't find an option using CTRL F or the Data,
gt; Form.
gt;
gt; For example, if I am at the top of a worksheet and would like to quickly
gt; move to row 782, how is this accomplished?
gt;
gt; I searched the previous posts for this same question but did not find it.
gt;
gt; Thanks!
gt; Laura :-)

Try something like this:

Press the [F5] key (that's the shortcut for lt;editgt;lt;gotogt;)
Type a reference in the input box:

Examples:
A782....to select cell A782
or
782:782.... to select entire row 782

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;Laura Parsonquot; wrote:

gt; Is there a way to find by a row number or column letter like you can find by
gt; data or cell reference? I couldn't find an option using CTRL F or the Data,
gt; Form.
gt;
gt; For example, if I am at the top of a worksheet and would like to quickly
gt; move to row 782, how is this accomplished?
gt;
gt; I searched the previous posts for this same question but did not find it.
gt;
gt; Thanks!
gt; Laura :-)

Thanks, Ellen! I can't believe I didn't think about putting the letter in
front of it!

Have a great day!

Laura :-)

quot;Ellenquot; wrote:

gt; Hi Laura,
gt; Try Edit/GoTo then key in whatever cell you're looking for, for instance
gt; A782. I know I'm sending you to a specific cell, but I hope this is helpful
gt; anyway.
gt;
gt; Ellen :-D
gt;
gt; quot;Laura Parsonquot; wrote:
gt;
gt; gt; Is there a way to find by a row number or column letter like you can find by
gt; gt; data or cell reference? I couldn't find an option using CTRL F or the Data,
gt; gt; Form.
gt; gt;
gt; gt; For example, if I am at the top of a worksheet and would like to quickly
gt; gt; move to row 782, how is this accomplished?
gt; gt;
gt; gt; I searched the previous posts for this same question but did not find it.
gt; gt;
gt; gt; Thanks!
gt; gt; Laura :-)

In the quot;Name boxquot;, type A782 and press Enter......the cursor will be
transported to cell A782

Vaya con Dios,
Chuck, CABGx3
quot;Laura Parsonquot; wrote:

gt; Is there a way to find by a row number or column letter like you can find by
gt; data or cell reference? I couldn't find an option using CTRL F or the Data,
gt; Form.
gt;
gt; For example, if I am at the top of a worksheet and would like to quickly
gt; move to row 782, how is this accomplished?
gt;
gt; I searched the previous posts for this same question but did not find it.
gt;
gt; Thanks!
gt; Laura :-)

Thanks, Ron! That certainly does help!

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; Press the [F5] key (that's the shortcut for lt;editgt;lt;gotogt;)
gt; Type a reference in the input box:
gt;
gt; Examples:
gt; A782....to select cell A782
gt; or
gt; 782:782.... to select entire row 782
gt;
gt; Does that help?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;Laura Parsonquot; wrote:
gt;
gt; gt; Is there a way to find by a row number or column letter like you can find by
gt; gt; data or cell reference? I couldn't find an option using CTRL F or the Data,
gt; gt; Form.
gt; gt;
gt; gt; For example, if I am at the top of a worksheet and would like to quickly
gt; gt; move to row 782, how is this accomplished?
gt; gt;
gt; gt; I searched the previous posts for this same question but did not find it.
gt; gt;
gt; gt; Thanks!
gt; gt; Laura :-)

Thanks, Chuck!

quot;CLRquot; wrote:

gt; In the quot;Name boxquot;, type A782 and press Enter......the cursor will be
gt; transported to cell A782
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Laura Parsonquot; wrote:
gt;
gt; gt; Is there a way to find by a row number or column letter like you can find by
gt; gt; data or cell reference? I couldn't find an option using CTRL F or the Data,
gt; gt; Form.
gt; gt;
gt; gt; For example, if I am at the top of a worksheet and would like to quickly
gt; gt; move to row 782, how is this accomplished?
gt; gt;
gt; gt; I searched the previous posts for this same question but did not find it.
gt; gt;
gt; gt; Thanks!
gt; gt; Laura :-)

You're welcome.........thanks for the thanks.........

Vaya con Dios,
Chuck, CABGx3
quot;Laura Parsonquot; wrote:

gt; Thanks, Chuck!
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; In the quot;Name boxquot;, type A782 and press Enter......the cursor will be
gt; gt; transported to cell A782
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Laura Parsonquot; wrote:
gt; gt;
gt; gt; gt; Is there a way to find by a row number or column letter like you can find by
gt; gt; gt; data or cell reference? I couldn't find an option using CTRL F or the Data,
gt; gt; gt; Form.
gt; gt; gt;
gt; gt; gt; For example, if I am at the top of a worksheet and would like to quickly
gt; gt; gt; move to row 782, how is this accomplished?
gt; gt; gt;
gt; gt; gt; I searched the previous posts for this same question but did not find it.
gt; gt; gt;
gt; gt; gt; Thanks!
gt; gt; gt; Laura :-)