Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Keyboard Command to go to next blank cell
Hello All
Excel 2K, Windows 2K Is there any keyboard command available that will take me to the next blank cell in my workbook? (it doesn't matter whether it's in the next column, the next row, ten rows down or ten columns across) ... the next blank one TIA for any assistance. Debra |
#2
|
|||
|
|||
Hold down <End, and hit an arrow key in the direction you're looking to go,
and you'll end up in the last cell with data. So, hit the arrow key twice to end up in the next blank cell. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Debra Farnham" wrote in message ... Hello All Excel 2K, Windows 2K Is there any keyboard command available that will take me to the next blank cell in my workbook? (it doesn't matter whether it's in the next column, the next row, ten rows down or ten columns across) ... the next blank one TIA for any assistance. Debra |
#3
|
|||
|
|||
Thanks tons RD!
Deb "RagDyer" wrote in message ... Hold down <End, and hit an arrow key in the direction you're looking to go, and you'll end up in the last cell with data. So, hit the arrow key twice to end up in the next blank cell. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Debra Farnham" wrote in message ... Hello All Excel 2K, Windows 2K Is there any keyboard command available that will take me to the next blank cell in my workbook? (it doesn't matter whether it's in the next column, the next row, ten rows down or ten columns across) ... the next blank one TIA for any assistance. Debra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Go to first blank cell | Excel Worksheet Functions |