Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What's an efficient way to go to either:
1. The last non-empty cell in a column, or 2. The empty cell below it? Ctrl-down-arrow stops at every empty cell in the column. There are lots of them. A two step process would work: 1. go to the last cell in the column (row 65535) 2. Ctrl-Up-Arrow But I don't know of an efficient way to do step one. I'm sure I could write a VBA macro, but I'm looking for something "universal" if possible. Using Excel 2000 Many thanks, Fred Holmes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to: Find first empty cell in column | Excel Worksheet Functions | |||
find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
Autofilling next empty cell in column? | New Users to Excel | |||
Using last cell in a column that is not empty in a calculation | Excel Worksheet Functions | |||
help locating first empty cell in a Column | Excel Worksheet Functions |