Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Go To a Row or Column?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Go To a Row or Column?
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 "Brandy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Go To a Row or Column?
Thank you, thank you, thank you....
Brandy "Peo Sjoblom" wrote: 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 "Brandy" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Go To a Row or Column?
Peo, thank you, thank you, thank you
"Peo Sjoblom" wrote: 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 "Brandy" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Go To a Row or Column?
Ctrl + G will do the same thing.
Regards, Ryan--- -- RyGuy "Brandy" wrote: Peo, thank you, thank you, thank you "Peo Sjoblom" wrote: 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 "Brandy" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Go To a Row or Column?
So will typing the cell address directly into the Name Box (the field to the
left of the Formula Bar). -- Rick (MVP - Excel) "ryguy7272" wrote in message ... Ctrl + G will do the same thing. Regards, Ryan--- -- RyGuy "Brandy" wrote: Peo, thank you, thank you, thank you "Peo Sjoblom" wrote: 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 "Brandy" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Go To a Row or Column?
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" wrote in message ... So will typing the cell address directly into the Name Box (the field to the left of the Formula Bar). -- Rick (MVP - Excel) "ryguy7272" wrote in message ... Ctrl + G will do the same thing. Regards, Ryan--- -- RyGuy "Brandy" wrote: Peo, thank you, thank you, thank you "Peo Sjoblom" wrote: 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 "Brandy" wrote in message ... 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Go To a Row or Column?
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). -- Rick (MVP - Excel) "Peo Sjoblom" wrote in message ... 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" wrote in message ... So will typing the cell address directly into the Name Box (the field to the left of the Formula Bar). -- Rick (MVP - Excel) "ryguy7272" wrote in message ... Ctrl + G will do the same thing. Regards, Ryan--- -- RyGuy "Brandy" wrote: Peo, thank you, thank you, thank you "Peo Sjoblom" wrote: 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 "Brandy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) |