Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find by row number
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 :-) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find by row number
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 "Laura Parson" wrote: 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 :-) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find by row number
Try something like this:
Press the [F5] key (that's the shortcut for <edit<goto) 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, WinXP "Laura Parson" wrote: 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 :-) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find by row number
Thanks, Ellen! I can't believe I didn't think about putting the letter in
front of it! Have a great day! Laura :-) "Ellen" wrote: 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 "Laura Parson" wrote: 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 :-) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find by row number
In the "Name box", type A782 and press Enter......the cursor will be
transported to cell A782 Vaya con Dios, Chuck, CABGx3 "Laura Parson" wrote: 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 :-) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find by row number
Thanks, Ron! That certainly does help!
"Ron Coderre" wrote: Try something like this: Press the [F5] key (that's the shortcut for <edit<goto) 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, WinXP "Laura Parson" wrote: 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 :-) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find by row number
Thanks, Chuck!
"CLR" wrote: In the "Name box", type A782 and press Enter......the cursor will be transported to cell A782 Vaya con Dios, Chuck, CABGx3 "Laura Parson" wrote: 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 :-) |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find by row number
You're welcome.........thanks for the thanks.........
Vaya con Dios, Chuck, CABGx3 "Laura Parson" wrote: Thanks, Chuck! "CLR" wrote: In the "Name box", type A782 and press Enter......the cursor will be transported to cell A782 Vaya con Dios, Chuck, CABGx3 "Laura Parson" wrote: 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 :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I find prime factors of a number | Excel Worksheet Functions | |||
find the lowest value in a row and add a number to it | Excel Worksheet Functions | |||
Find number of days between to dates | Excel Worksheet Functions | |||
How do I find highest number in a row and change color? | Excel Worksheet Functions | |||
How do I find the first value in a column less than a number? | Excel Worksheet Functions |