cells

J

Jared

I have created a worksheet in which I would like to enter through cells. The
worksheet has a series of questions where you type in the answers. The only
thing is that the cells you type the answer in are all over the worksheet. I
would like to go from one cell to the other. Example, I would like to go
from I 1 to I 2 to B 11 to I 13 etc.... Is there a way to randomly skip
around a worksheet when you hit enter?
 
S

SteveG

Jared,

You can if you don't mind protecting the rest of the sheet. Select all
the cells that you want to skip through so they are all highlighted
(start by selecting the first cell, then hold down the control key as
you select the others). Right mouse click, Format Cells, Protection
and deselect the Locked checkbox. Click on OK.

Then protect your sheet making sure that you deselect the "Select
locked cells" option.

The user will then only be able to select the cells that are not
locked. Excel will also only move to the next unlocked cell when the
user hits enter.

HTH

Steve
 
H

Heidi

Jared,

You can't have the "enter" button send you randomly through your worksheet,
but you can sort the questions randomly so that they are not in the same
order every time.

To do this, add a column to your data. In the first cell, enter the formula:
=rand()

Then fill this formula down to the end of your data.

Finally, go to Data>Sort and sort by your new column. Your questions will
be in random order.

Heidi
 
T

TC

I have forms set up like Steve recommends but I use the Tab key key to move
around the sheet. Unless someone unprotects the sheet. This will stop people
from deleting your questions or calculations if you have any.
 
Top