How do I Go To a Row or Column?

[Brandy]

How do I Go To a Row or Column?

Within a spreadsheet with over 100 columns, how can I do a search for a
particular column or a row?

How can I do a "Go To" for particular column or row?

Thanks

Brandy

 

[Peo Sjoblom]

Press F5, type D and press enter to go to select column D, if you just
want to move to the first cell in D press F5, type D1 instead and press
enter. Do the same for rows, to select row 5, F5, type 5:5 and press enter

--


Regards,


Peo Sjoblom

 

[Brandy]

Thank you, thank you, thank you....

Brandy

Press F5, type D and press enter to go to select column D, if you just
want to move to the first cell in D press F5, type D1 instead and press
enter. Do the same for rows, to select row 5, F5, type 5:5 and press enter

--


Regards,


Peo Sjoblom

 

[Brandy]

Peo, thank you, thank you, thank you

Press F5, type D and press enter to go to select column D, if you just
want to move to the first cell in D press F5, type D1 instead and press
enter. Do the same for rows, to select row 5, F5, type 5:5 and press enter

--


Regards,


Peo Sjoblom

 

[ryguy7272]

Ctrl + G will do the same thing.

Regards,
Ryan---

 

[Rick Rothstein]

So will typing the cell address directly into the Name Box (the field to the
left of the Formula Bar).

 

[Peo Sjoblom]

True but you can't get there without using the mouse so one might as well
click the header of the column/row

--


Regards,


Peo Sjoblom

 

[Rick Rothstein]

LOL... you know I read the OP's whole post at least twice and didn't pick up
on the fact that he was *not* asking about going to a particular cell or
range of cells. Yes, clicking the header would be just as easy. Well, just
as easy if the column or row is "nearby". However, if one wanted to go to,
say, Row 32000, it probably *is* easier to type A32000 or even 32000:32000
one wanted to select the whole row (similar treatment for columns as well).