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 doing data entry into a worksheet, you might want to enter dates without the need to type the separators that are normally part of those dates. Here’s a discussion on how this can be done in Excel, along with the benefits and drawbacks of using such an approach. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Entering Large Time Values If you need to input humongous times into a worksheet, you may run into a problem if you need to enter times greater than 10,000 hours. This tip explains the full problem and provides some ideas on getting around the problem. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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 Want a quick way to jump to the end of your data entry area in a worksheet? The macro in this tip makes quick work of the task. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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 is brilliant at handling dates—as long as they aren’t dates earlier than the base date used by the program. If you need to use earlier dates, then you’ll want to be aware of the information in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

More Topics

Tips, Tricks, and Answers

Problems with Dates?

Helpful Links

Great Info!

RSS Feeds