ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keyboard Command to go to next blank cell (https://www.excelbanter.com/excel-discussion-misc-queries/48567-keyboard-command-go-next-blank-cell.html)

Debra Farnham

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



RagDyer

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




Debra Farnham

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