Topic: Data Entry

The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.

Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Entering Dates in Excel If the information you enter in a cell can possibly be understood as a date, Excel will try to fit it into a date format. This tip discusses differing ways that dates can be entered into Excel. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Entering Dates Without Separators When you enter dates into a cell, Excel pays attention to the separators you use between the month, day, and year. While entering dates could be done a lot quicker without the separators, that doesn’t mean that entering dates in that manner is the best approach for your worksheet. This tip discusses several approaches you can use. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Entering Large Time Values When using Excel to track elapsed time, you may want to enter a large time value (thousands of hours or more) into a cell. Enter too large of a value, and Excel treats your input as text. Here’s how to get around Excel’s confusion about your entry. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Inserting Symbols Using the Character Map to insert symbols in Excel. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Jumping to the Start of the Next Data Entry Row If you routinely jump to the bottom of your worksheet to enter new data, this tip provides a macro you may find helpful. It jumps to the first cell (column A) of the first empty row after your data table. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Modifying Default Year for Dates When entering dates into a worksheet, you may want the dates to default to last year instead of this year. Here’s a way you can accomplish this type of data input. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Quickly Entering Dates and Times Do you use Excel to track dates and times, perhaps for a timesheet? You can make entering the data much easier if you learn a couple of quick shortcuts that allow you to enter the current date and time. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Recording a Data Entry Time When you use Excel for data entry, you might want to keep track of the time when each entry is entered. Coming up with a manual or formulaic way to accomplish the task is unnecessarily difficult; it is better to use an automatic macro, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using Early Dates Excel, by default, won’t recognize dates before January 1, 1900. This tip discusses ways you can approach that limitation and work around it. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

More Topics

Tips, Tricks, and Answers

Problems with Dates?

Helpful Links

Great Info!

RSS Feeds