Moving the cursor to only blank cells

Klasdude

New Member
Joined
Sep 27, 2006
Messages
14
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?
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

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
 

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)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,542
Messages
5,529,438
Members
409,877
Latest member
DDhol
Top