| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Data/form
In Office 2003 I can select from my toolbar Data/Form and get a pop up from
which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
Hi Lynne
You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
Hello Ron,
Is this site you created made to assist Microsoft in creating Office 2007, or just your own helpful page for others? "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
Hi Lynne
or just your own helpful page for others? I hope you think it is usuful -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, Is this site you created made to assist Microsoft in creating Office 2007, or just your own helpful page for others? "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
Hello Ron,
I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
Quick Access Toolbar
This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
OK Ron, I will go to my laptop and see if I can make it work. Thanks.
Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
It's not available in Office 2007. This has to be an oversight! Below is what
I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
Look good, It is there
The name is "Form" From my site 1) Office Button Excel Options 2) Customization 3) Choose "Commands Not in the Ribbon" 4) Select the command 5) Add 6) OK -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... It's not available in Office 2007. This has to be an oversight! Below is what I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
I will give it another shot. This should not be so difficult, Why not just
have the option from the start? If one doesn't want it, they can just choose to ignore it. It sure seems easier to me. Thanks. I will let you know if I succeed. "Ron de Bruin" wrote: Look good, It is there The name is "Form" From my site 1) Office Button Excel Options 2) Customization 3) Choose "Commands Not in the Ribbon" 4) Select the command 5) Add 6) OK -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... It's not available in Office 2007. This has to be an oversight! Below is what I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
Well, I tried. Found 1-3 and when I got to 4 to select the command, Data Form
was not there. I'm telling you Microsoft forgot to put this in Office 2007! Would you please go to Excel 2003 and open a database, put your curser in 1A and choose data/form and say yes. This is what I am looking for. I had already tweaked my toolbar and couldn't find it. You gave me a different way of getting there. I just right-clicked and chose then customization of my toolbar. "Ron de Bruin" wrote: Look good, It is there The name is "Form" From my site 1) Office Button Excel Options 2) Customization 3) Choose "Commands Not in the Ribbon" 4) Select the command 5) Add 6) OK -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... It's not available in Office 2007. This has to be an oversight! Below is what I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
The name is "Form"
-- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Well, I tried. Found 1-3 and when I got to 4 to select the command, Data Form was not there. I'm telling you Microsoft forgot to put this in Office 2007! Would you please go to Excel 2003 and open a database, put your curser in 1A and choose data/form and say yes. This is what I am looking for. I had already tweaked my toolbar and couldn't find it. You gave me a different way of getting there. I just right-clicked and chose then customization of my toolbar. "Ron de Bruin" wrote: Look good, It is there The name is "Form" From my site 1) Office Button Excel Options 2) Customization 3) Choose "Commands Not in the Ribbon" 4) Select the command 5) Add 6) OK -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... It's not available in Office 2007. This has to be an oversight! Below is what I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
I understand the name if Form, but it is not on the list. Since I have
already gone through the list and put them in the order I want them on my toolbar. Please do me a favor a just show me the exact path to be able to put data/form as an option on my toolbar. I am a beta tester for Vista and if not successful this time, I will just call them, or else email my son who also works for Microsoft as a TAM. "Ron de Bruin" wrote: The name is "Form" -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Well, I tried. Found 1-3 and when I got to 4 to select the command, Data Form was not there. I'm telling you Microsoft forgot to put this in Office 2007! Would you please go to Excel 2003 and open a database, put your curser in 1A and choose data/form and say yes. This is what I am looking for. I had already tweaked my toolbar and couldn't find it. You gave me a different way of getting there. I just right-clicked and chose then customization of my toolbar. "Ron de Bruin" wrote: Look good, It is there The name is "Form" From my site 1) Office Button Excel Options 2) Customization 3) Choose "Commands Not in the Ribbon" 4) Select the command 5) Add 6) OK -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... It's not available in Office 2007. This has to be an oversight! Below is what I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
See
http://www.rondebruin.com/images/form.png -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... I understand the name if Form, but it is not on the list. Since I have already gone through the list and put them in the order I want them on my toolbar. Please do me a favor a just show me the exact path to be able to put data/form as an option on my toolbar. I am a beta tester for Vista and if not successful this time, I will just call them, or else email my son who also works for Microsoft as a TAM. "Ron de Bruin" wrote: The name is "Form" -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Well, I tried. Found 1-3 and when I got to 4 to select the command, Data Form was not there. I'm telling you Microsoft forgot to put this in Office 2007! Would you please go to Excel 2003 and open a database, put your curser in 1A and choose data/form and say yes. This is what I am looking for. I had already tweaked my toolbar and couldn't find it. You gave me a different way of getting there. I just right-clicked and chose then customization of my toolbar. "Ron de Bruin" wrote: Look good, It is there The name is "Form" From my site 1) Office Button Excel Options 2) Customization 3) Choose "Commands Not in the Ribbon" 4) Select the command 5) Add 6) OK -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... It's not available in Office 2007. This has to be an oversight! Below is what I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
That did it. What I wasn't doing was changing the drop down to the proper
place. Thank you for your determination. I have copied your information as I am sure many others will have the same problem. Microsoft fixed something that was not broken. Now it is because it was so difficult to obtain. Case Closed. "Ron de Bruin" wrote: See http://www.rondebruin.com/images/form.png -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... I understand the name if Form, but it is not on the list. Since I have already gone through the list and put them in the order I want them on my toolbar. Please do me a favor a just show me the exact path to be able to put data/form as an option on my toolbar. I am a beta tester for Vista and if not successful this time, I will just call them, or else email my son who also works for Microsoft as a TAM. "Ron de Bruin" wrote: The name is "Form" -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Well, I tried. Found 1-3 and when I got to 4 to select the command, Data Form was not there. I'm telling you Microsoft forgot to put this in Office 2007! Would you please go to Excel 2003 and open a database, put your curser in 1A and choose data/form and say yes. This is what I am looking for. I had already tweaked my toolbar and couldn't find it. You gave me a different way of getting there. I just right-clicked and chose then customization of my toolbar. "Ron de Bruin" wrote: Look good, It is there The name is "Form" From my site 1) Office Button Excel Options 2) Customization 3) Choose "Commands Not in the Ribbon" 4) Select the command 5) Add 6) OK -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... It's not available in Office 2007. This has to be an oversight! Below is what I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Data/form
Glad you found it Lynne <g
Have a nice day -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... That did it. What I wasn't doing was changing the drop down to the proper place. Thank you for your determination. I have copied your information as I am sure many others will have the same problem. Microsoft fixed something that was not broken. Now it is because it was so difficult to obtain. Case Closed. "Ron de Bruin" wrote: See http://www.rondebruin.com/images/form.png -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... I understand the name if Form, but it is not on the list. Since I have already gone through the list and put them in the order I want them on my toolbar. Please do me a favor a just show me the exact path to be able to put data/form as an option on my toolbar. I am a beta tester for Vista and if not successful this time, I will just call them, or else email my son who also works for Microsoft as a TAM. "Ron de Bruin" wrote: The name is "Form" -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Well, I tried. Found 1-3 and when I got to 4 to select the command, Data Form was not there. I'm telling you Microsoft forgot to put this in Office 2007! Would you please go to Excel 2003 and open a database, put your curser in 1A and choose data/form and say yes. This is what I am looking for. I had already tweaked my toolbar and couldn't find it. You gave me a different way of getting there. I just right-clicked and chose then customization of my toolbar. "Ron de Bruin" wrote: Look good, It is there The name is "Form" From my site 1) Office Button Excel Options 2) Customization 3) Choose "Commands Not in the Ribbon" 4) Select the command 5) Add 6) OK -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... It's not available in Office 2007. This has to be an oversight! Below is what I am talking about. I found it on the MSFT site under Tricks and Tip for 2002. There is no way to get it with 2007. What a shame! I was under the impression that you tried and found the solution. Create Forms for Easier Data Entry From Rajesh Chintala, Delhi, India Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time. To use a data entry form to edit a list: Click a cell in the labeled row you want to add the record to. On the Data menu, click Form. Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list. To add a new record Click New. Type the information for the new record. When you finish typing data, press the ENTER key to add the record. When you finish adding records, click Close to add the new record and close the data form. "LynneH10" wrote: OK Ron, I will go to my laptop and see if I can make it work. Thanks. Lynne "Ron de Bruin" wrote: Quick Access Toolbar This is a toolbar above or below the ribbon You can see how to do it here http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... Hello Ron, I didn't get the answer yet. What is the QAT? Thanks for any assistance. Lynne "Ron de Bruin" wrote: Hi Lynne You can add it to the QAT See http://www.rondebruin.nl/0307commands.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LynneH10" wrote in message ... In Office 2003 I can select from my toolbar Data/Form and get a pop up from which I can type data and it lays down on my spreadsheet after every enter. In Office 2007 beta version, I don't see that option anymore. Is it going to be included in the new office? Also, I can't format a cell to give me a date option of 9/06 for September, 2006. It wants to change the cell to September 6, 2006. How can I fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Linear Mode
