| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a cell that is self numbering with Excel
I am trying to create a control form that has three cells that need to be
self numbering. These numbers would increase by just one number. I do not want anyone to have to change these numbers but rather the form to do this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a cell that is self numbering with Excel
Why dont you write a formula i.e in the cell A3 (=A2+1) and drag it down
then protect the column A using the option Tools / Protection €¦. / Protect Sheet That will not permit any one to change the data in Column A Thanks Maged Elsabagh "cochum" wrote: I am trying to create a control form that has three cells that need to be self numbering. These numbers would increase by just one number. I do not want anyone to have to change these numbers but rather the form to do this. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a cell that is self numbering with Excel
Oh and then hide the first row with the initial number in it?
"maged_giza" wrote: Why dont you write a formula i.e in the cell A3 (=A2+1) and drag it down then protect the column A using the option Tools / Protection €¦. / Protect Sheet That will not permit any one to change the data in Column A Thanks Maged Elsabagh "cochum" wrote: I am trying to create a control form that has three cells that need to be self numbering. These numbers would increase by just one number. I do not want anyone to have to change these numbers but rather the form to do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Excel will not allow me to create a name of "C" for a cell! | Setting up and Configuration of Excel | |||
| How to create a hyperlink in excel, using the text in a cell. | Excel Worksheet Functions | |||
| How do I create automatic cell movement when using excel | Excel Worksheet Functions | |||
Linear Mode
