Use Fill-in-the-Blank Form to Enter Excel Spreadsheet Data

If you have already created a spreadsheet containing a list of information, and you need to make additional entries to the list, here's a quick and easy way to add to the information already entered on your spreadsheet.

Before using this tool, make sure that the first row of your data contains header information, and that there is at least one row of data beneath the header row. There can be no blank rows in your data list.

Position your mouse pointer in any occupied cell that is within the list area. Choose Data, Form from the Excel menu. A window appears with a heading that matches your sheet name (the heading will read "Sheet1" if you have not assigned a name to your spreadsheet). There will be a fill-in-the-blank box for each column of your data list, and the header name for each column appears next to each fill-in box.

To enter a new record to your data list, click the New button, then fill in the boxes for each piece of data, pressing Tab to move from one fill-in box to the next. Click the New button or press Enter when you have completed your entry and your new record will be added to the bottom of the data list.

This is a particularly useful tool when you are entering information into a list that stretches beyond the borders of your screen. You can use the fill-in-the-blank box to easily see all the fields that require data entry.

You may like these other stories...

Earlier this week I presented the Chart Edition of AccountingWEB’s High Impact Excel webinar series. One of the many topics I covered was the Sparklines feature, which was first introduced in Excel 2010. Several...
On January 30, I led a free, one-hour webinar, High Impact Excel: Pivot Table Edition. If you missed the presentation, it’s too late to get CPE credit, but you can watch an on-demand recording. After the webinar, I...
By David Ringstrom, CPA In Part 1 of this series I showed how to use a custom number format to conditionally display decimal places. Although the technique is simple, the downside is it may not work in every situation....

Upcoming CPE Webinars

Jul 31
In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel.
Aug 5
This webcast will focus on accounting and disclosure policies for various types of consolidations and business combinations.