Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am trying to create a form in Excel. In my form I want to be abl
I am trying to create a form in Excel. In my form I want to be able to Tab
from Cell to cell and input information. Not every cell will need this function. For example In A1 I need a gray space to indicate that you should type some information...here is a visual... Contact Phone: ___________(this is actually another cell, that I want grayed out, and someone can click on that cell and automatically start typing. Then I want them to be able to press tab OR enter to be navigated to the next cell that requires information. I dont want anyone able to change the format of the cell that is asking for the info...for example, the cell named "contact phone" should not be able to be changed. But I want its corresponding cell to be able to be changed and then once done filling in that infomration I want to be able to click enter or tab and be directed to thenext cell which I have to enter something. I tried all the protecting sheet steps and it did not do what I was wanting. Thank you in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am trying to create a form in Excel. In my form I want to be abl
Now is this on a form or on your sheet, if a form look into tab stop. If it
is a sheet you can protect what you don't want changed then when protecting uncheck the box that says Select Locked Cells -- -- -John Please rate when your question is answered to help us and others know what is helpful. "AngelaD" wrote in message ... I am trying to create a form in Excel. In my form I want to be able to Tab from Cell to cell and input information. Not every cell will need this function. For example In A1 I need a gray space to indicate that you should type some information...here is a visual... Contact Phone: ___________(this is actually another cell, that I want grayed out, and someone can click on that cell and automatically start typing. Then I want them to be able to press tab OR enter to be navigated to the next cell that requires information. I dont want anyone able to change the format of the cell that is asking for the info...for example, the cell named "contact phone" should not be able to be changed. But I want its corresponding cell to be able to be changed and then once done filling in that infomration I want to be able to click enter or tab and be directed to thenext cell which I have to enter something. I tried all the protecting sheet steps and it did not do what I was wanting. Thank you in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am trying to create a form in Excel. In my form I want to be
Technically its a sheet, but I created a form on that sheet
"John Bundy" wrote: Now is this on a form or on your sheet, if a form look into tab stop. If it is a sheet you can protect what you don't want changed then when protecting uncheck the box that says Select Locked Cells -- -- -John Please rate when your question is answered to help us and others know what is helpful. "AngelaD" wrote in message ... I am trying to create a form in Excel. In my form I want to be able to Tab from Cell to cell and input information. Not every cell will need this function. For example In A1 I need a gray space to indicate that you should type some information...here is a visual... Contact Phone: ___________(this is actually another cell, that I want grayed out, and someone can click on that cell and automatically start typing. Then I want them to be able to press tab OR enter to be navigated to the next cell that requires information. I dont want anyone able to change the format of the cell that is asking for the info...for example, the cell named "contact phone" should not be able to be changed. But I want its corresponding cell to be able to be changed and then once done filling in that infomration I want to be able to click enter or tab and be directed to thenext cell which I have to enter something. I tried all the protecting sheet steps and it did not do what I was wanting. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
Can I create an Excel User Form without VB install on my PC? | Excel Discussion (Misc queries) | |||
how do i create a data collection form in excel? | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
View of Excel form is different on different computers. | Excel Discussion (Misc queries) |