Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells
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 -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=504628 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells
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. "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |