Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Data Form
I am using Excel 2003 and set up a data entry form on my spreadsheet. I hate
it. How do I erase the data form from the spreadsheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Data Form
How did you build the data entry form?
Right-click on it and EditClear Try CTRL + a(twice in 2003) and EditClear All Alternative...............Right-click on the sheet tab and "Delete Sheet". Gord Dibben MS Excel MVP On Thu, 17 May 2007 09:05:01 -0700, Paddler wrote: I am using Excel 2003 and set up a data entry form on my spreadsheet. I hate it. How do I erase the data form from the spreadsheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Data Form
"Gord Dibben" wrote: How did you build the data entry form? Right-click on it and EditClear Try CTRL + a(twice in 2003) and EditClear All Alternative...............Right-click on the sheet tab and "Delete Sheet". Gord Dibben MS Excel MVP On Thu, 17 May 2007 09:05:01 -0700, Paddler wrote: I am using Excel 2003 and set up a data entry form on my spreadsheet. I hate it. How do I erase the data form from the spreadsheet? Thanks it worked -Edit-clear-all and I only had to rebuild the title row and first row of data. I built the form by highlighting the title and first data rows and then going to Data - Form. This is an annual database with probably 75 to 100 entries (typed data input in 5 columns). I liked the idea of an automatically expanding database to whatever size might be required. However, I didn't like the fact that every field on the database was converted to a dropdown search box. This would have been too confusing to the forms users and could have resulted in constant problem calls from them. The form seemed to foul up my sort macros. even though I used the 'database' range name for it and tried to select the correct range for the sort function. My first field was a dropdown box but I couldn't get it to work when the datasheet was in form view. Some of the users would have tried to enter data on the datasheet view and might not have used the * row. Overall, there just seemed to be too many possibilities for the users of the form to mess it up and need to call for help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
how to delete or remove checkbox form control in Excel? | Excel Discussion (Misc queries) | |||
how to delete the 1st letter form a set of rows of info. | Excel Worksheet Functions | |||
Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) |