![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 07:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com