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....

Already a member? log in here.

Upcoming CPE Webinars

Sep 18
In this course, Amber Setter will shine the light on different types of leadership behavior- an integral part of everyone's career.
Sep 24
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Sep 30
This webcast will include discussions of important issues in SSARS No. 19 and the current status of proposed changes by the Accounting and Review Services Committee in these statements.
Oct 23
Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.