![]() ![]() Now, with a cell selected in the already created table use Data menu / Form choice to activate a form where you can add new rows of information, delete a row and use the Criteria button to search for specific records. ![]() It worked for me with only the column headings but if it doesn’t for you then be sure to add that first row of information.) (All the documentation says to have a row of data. Simply create the column headings for your table and one row of data. ![]() Yep, with this extension you have the Form choice and you’re good to go! (Once installed, don’t forget to close and re-start to be able to use it for the first time.) To get this feature in Calc you’ll need to download and install the Data Form extension. However, if you’ve changed to using Calc you may be missing the feature…Īs you can see the Data menu does not contain a form choice. ![]() Quick data entry with no cell navigation issues! Fill in the fields (tab to get to the next one) and use the enter key to add that row of data and a blank form will appear for the entry of the next set of information. What data form does is to give you a dialog window for entering rows of data in a table, avoiding actual navigation of the worksheet cells and the aggravating occurrences of data accidentally placed in the wrong location.Īs you can see, each column heading from the table is represented as a field on the form. If you’ve used MS Excel’s data form feature then you know how handy it is to have.įor those of you who haven’t used it, here’s the basic run-down of the feature… ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |