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, 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?
posted by TRUELOTUS to Computers & Internet (5 answers total) 6 users marked this as a favorite
How many columns do you have? You're allowed up to 32.
posted by jeather at 1:15 PM on March 19, 2015

Response by poster: really why is it not working then :(
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

Response by poster: ok, thanks :)
posted by TRUELOTUS at 1:51 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

« Older Taking a client out to lunch in Beautiful Downtown...   |   Help me spend some money Newer »
This thread is closed to new comments.