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