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