I have an Excel worksheet that has some cells with text in them and some that are blank. This sheet is a form that needs all of the blanks filled in. Is there a way to skip cells that have text in them and move from blank to blank to fill in the form?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Moving the cursor to only blank cells
- Thread starter Klasdude
- Start date
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
Hi, Klasdude
Welcome to the Board !!!!!
unlock the cells to fill in
(other cells must be locked)
protect the sheet
using TAB you will go to next unprotected cell
kind regards,
Erik
Welcome to the Board !!!!!
unlock the cells to fill in
(other cells must be locked)
protect the sheet
using TAB you will go to next unprotected cell
kind regards,
Erik
Upvote
0
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
You're WELCOME 
this will feel like a quick lucky start for you
check out the search-function (see link on top of the page next to FAQ)
this will feel like a quick lucky start for you
check out the search-function (see link on top of the page next to FAQ)
Upvote
0
Similar threads
- Solved
- Solved
