Thread: cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Heidi
 
Posts: n/a
Default cells

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 DataSort and sort by your new column. Your questions will
be in random order.

Heidi

"Jared" wrote:

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?