Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut to select column with data in previous column
I am adding a column to my worksheet. This new column will contain a formula
that references the previous columns. The worksheet contains 25,000+ records. I would like a keyboard shortcut that allows me to select all of the cells in the new column at once, but will only go down as far as the previous column that contains data. I thought I knew a shortcut for this at one time, but if I did, it has slipped my mind. I also cannot find it on the internet again. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut to select column with data in previous column
select the top cell in the new column
hold the shift key and use the mouse or arrow to move one cell to the left continue holding the shift key press control and down arrow contine holding the shift key use the mouse or arrow to move one cell to the right the cells just to the right of the ast column are now selected "TJAC" wrote: I am adding a column to my worksheet. This new column will contain a formula that references the previous columns. The worksheet contains 25,000+ records. I would like a keyboard shortcut that allows me to select all of the cells in the new column at once, but will only go down as far as the previous column that contains data. I thought I knew a shortcut for this at one time, but if I did, it has slipped my mind. I also cannot find it on the internet again. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up previous data in column within an IF statement | Excel Worksheet Functions | |||
select detail in column B if column A = date | Excel Worksheet Functions | |||
select rows to print where there's data in specific column | Excel Discussion (Misc queries) | |||
In Excel: select the last 20 rows of data in a column | Excel Worksheet Functions | |||
Data in column predetermined by what has been entered in previous | Excel Discussion (Misc queries) |