Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with tab in Excel
I would like to setup a spreadsheet like a form, and have users tab from one
cell to the next, (not in the same row or column) only selecting the next cell that needs data entered into it, and skipping all in between. Entering data and then going to the next cell that would need to be populated. I remember doing this previously, but forgot. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with tab in Excel
Under format cell, protection tab, unlock all the cells that you want the
user to fill out. Then, protect the worksheet, allowing users to only select unprotected cells. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mike Busch" wrote: I would like to setup a spreadsheet like a form, and have users tab from one cell to the next, (not in the same row or column) only selecting the next cell that needs data entered into it, and skipping all in between. Entering data and then going to the next cell that would need to be populated. I remember doing this previously, but forgot. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with tab in Excel
Cell locking/unlocking and sheet protection will allow tabbing to unlocked
cells but only in a left to right pattern. Is that OK with you? If not in that pattern you could use a named range or VBA For how to use a named range method see Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0008.html For VBA post back. Gord Dibben MS Excel MVP On Wed, 7 Oct 2009 06:39:01 -0700, Mike Busch wrote: I would like to setup a spreadsheet like a form, and have users tab from one cell to the next, (not in the same row or column) only selecting the next cell that needs data entered into it, and skipping all in between. Entering data and then going to the next cell that would need to be populated. I remember doing this previously, but forgot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|