How do I Go To a Row or Column?

B

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
 
P

Peo Sjoblom

Press F5, type D: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
 
B

Brandy

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

Brandy

Peo Sjoblom said:
Press F5, type D: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
Click to expand...
 
B

Brandy

Peo, thank you, thank you, thank you

Peo Sjoblom said:
Press F5, type D: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
Click to expand...
 
R

Rick Rothstein

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

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
 
R

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).
 
Top