MVP #25: A Super Easy Way to Enter Data into an Excel Table or Create Excel Database

, , No Comments
Ever tried creating a table or database in Excel? For most people, entering data and making corrections can be very frustrating in Excel.

Today, I'll be sharing with you a super easy way to enter data into an Excel table or create from scratch an Excel database. 

It's so easy that you will stop using Microsoft Word for your database/tables/lists once you try this out.

I will show you how to enable and start a Data Entry form in Excel that works like magic. Below is a screenshot of what I did with it.

It's like using an interactive tool to create the table. It also allows you to search for any entry, scroll between entries and make corrections easily.

So how do you enable this inbuilt tool in Excel? Very easy. Just follow this steps (I'm hoping you use Excel 2007, 2010 or 2013).

Right-click on the Quick Access Task bar at the upper left corner of Excel. See the image below. You can even right-click on the Save (Floppy Disk) icon.

Click on Customize Quick Access Toolbar

In the "Choose commands from" box, select "Commands Not in the Ribbon" and in the box below, scroll down and select "Form..." Click on the Add button 

And you're almost done. In fact, you won't have to do this set again whenever you want to enable the Data Form tool. You only do this once for every PC you use.

Next is to now enable the Data Form tool itself.

Highlight the table (in my case, I've got just the table headers). And click on the Form tool we just added to the Quick Access Toolbar.

You'll get a dialogbox like the one below if your table has only headers, like mine. Just click on OK.

And Voila! The magic tool pops up. Enter your data entries one by one. Click New when done. You can scroll, Search for a record or make changes to old records.

And that's the magic tool!


Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.