Jessica

You could use a named range and no sheet protection.

Select second cell in the sequence then with CTRL key held down select the
next ones in turn ending off your selection with the first in sequence.

InsertNameDefine...........give your range a name like doodah and OK

In NameBox select doodah and start entering data.


Gord Dibben MS Excel MVP

On Wed, 10 Sep 2008 05:41:01 -0700, Jessica Donadio
wrote:

Hello,

I am trying to do this as well, but I would rather not protect the sheet,
because sometimes data would need to be inserted in the other cells that I
haven't included in the tabbing. However, that link doesn't work anymore.
Is there any way to do this without having to activate a macro while being
able to still modify data in other cells if need be?

Jessica

On Tue, 15 Jan 2008 10:30:01 -0800, Rich D
wrote:

I have a spreadsheet where I fill in information in various cells. When I
make an entry into a cell, I then want to skip to the next cell requiring
data...and then the next, etc. How do I get away from just moving right,
left, up, down to the adjacent cell? Thanks.