Creating a data entry form in Excel
March 19, 2015 1:00 PM Subscribe
Hey Hivemind,
So I am just beginning to foray into excel. I have create a worksheet for data entry and it has a lot of columns. To make my life easier, I viewed this website which provide a tip to make data entry more manageable. The author suggested to create a data entry form,
http://www.launchexcel.com/excel-data-entry-power-tips. However, I cannot get this to really work in excel, it only partially works, excel is saying that the table is too large. Any ideas on how I can do this? Is there a work around?
Response by poster: really why is it not working then :(
I have 22
posted by TRUELOTUS at 1:18 PM on March 19, 2015
I have 22
posted by TRUELOTUS at 1:18 PM on March 19, 2015
Are all the other columns blank? Try adding a blank column after your 22 headers in case something got stuck in there.
posted by jeather at 1:26 PM on March 19, 2015
posted by jeather at 1:26 PM on March 19, 2015
Maybe try Google Docs? The form data appears as a spreadsheet and would be easy to copy to Excel.
posted by peanut_mcgillicuty at 2:18 PM on March 19, 2015
posted by peanut_mcgillicuty at 2:18 PM on March 19, 2015
This thread is closed to new comments.
posted by jeather at 1:15 PM on March 19, 2015