Are you tired to do manual data entry into a spreadsheet? Would you like to make it easier with a form window? If you think this requires macros, no, it doesn’t require one. LibreOffice Calc can help you making data entry form instantly out of any table you have. Let’s create it now.
Beginners, learn here about Calc Formulas from SUM to VLOOKUP.
Dataset
Write first dataset and save document as calc-input-form.ods.
Keep second dataset to input later:
Create Form
1. Put cursor in the header row e.g. A1.
2. Click menu Data > Form > data entry form created.
3. First time, form will show entry number 1/6 namely ABI’s scores.
(Data entry form, showing record number 1/6 ABI)
Input Entries
1. On the form, click Next Record until New Record reached.
2. Enter the data of MATH, ENGLISH, SCIENCE, and SOCIAL according to second dataset.
3. Repeat 1-2 for the rest of second dataset.
4. Data entries finished.
5. Close the form.
(Data entry form, showing an empty new record to fill)
Reshow Form
When you closed the form:
1. Put cursor on the header row namely A1.
2. Click menu Data > Form > data form entry displayed again.
3. Form should displays all entries.
(Data entry form, filling a new data record)
Summary
To this point, now you should be able to create data entry form in LibreOffice Calc. If you forgot how to, just remember to access the menu Data > Form. See you later!