Data Entry

Tips, Tricks, and Answers

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

Accepting Only a Single Digit
Want a quick way to enter a series of single digits into consecutive cells? The best approach is with a macro, and this tip examines a couple that may do the job for you.

Entered Values are Divided by 100
Enter a value into a cell and "poof!" it is automatically divided by 100. What's going on, and how can you fix it so that Excel actually enters what you type into the cell?

Entering Dates in Excel
When you type information into a cell, Excel tries to figure out what type of information you are entering. If Excel can reasonably assume you are entering a date, it will convert the entry into a date, internally, and format the cell as a date.

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.

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.

Inserting Symbols
Using the Character Map to insert symbols in Excel.

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.

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.

Quickly Entering Dates and Times
Excel provides keyboard shortcuts for a variety of purposes. This tip examines two such shortcuts, designed to allow entering times and dates quickly.

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.

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.

 

More Information

The following are additional topics related to the subject of 'Data Entry'. A bracketed number after the topic indicates how many articles are related to that subject.