• Lowell

Excel Data Entry Tips

Updated: Dec 10, 2020

Microsoft Excel is one of my favorite programs. I have used it for simple database applications, for time reporting applications, and for course registrations at a senior center I used to support. I’d like to share some shortcuts for entering data that will save you time and increase accuracy.

In the following examples, you'll see notations like Ctrl+character. This means to hold the Ctrl key down (on windows computers), tap the key denoted by character, and then release the keys.

Enter Today’s Date - Excel generally recognizes when we’re entering a date. It interprets entries like 8-1 or 8/1 as a month and day for the current year. To enter the current date, use the keyboard shortcut Ctrl+; (that’s a semicolon). It’s much quicker and it eliminates typos as long as the date on your computer is correct.

Enter the Current Time - In this example, we add the Shift key to our shortcut. Pressing Ctrl+Shift+; (semicolon) will enter the current time into a cell, as long as your computer’s clock is correct.

Enter Current Date and Time Into a Cell - First, press Ctrl+;, then type a space, then press Ctrl+Shift+;.

Enter Same Data into Multiple Cells - I track COVID-19 cases in three states, six counties, and eighteen Zip codes by date. Rather than typing the current date into each date cell, I first select all the date cells by holding the left mouse button down and dragging across the cells. Then I use Ctrl+; and Ctrl+Enter to insert the current date in all cells.

If you’d like to follow my COVID-19 graphs, go to https://public.tableau.com/profile/lowell3106#!/

Feel free to share the link with anyone. I've usually updated everything by 7:30 PM each day.


Related Posts

See All

Calculation Order/Operator Precedence in Excel

If you are new to Excel, you may wonder why a formula does not yield expected results. This is often due to the order in which Excel performs calculations in your formulas, versus how we might process

Excel AutoFill and Keyboard Shortcuts

This post provides a brief summary of using Excel's AutoFill capability and some keyboard shortcuts. I'm providing some animated GIF videos to demonstrate. I track Covid-19 cases in a few states and c

Enter your email address to receive blog post notifications and newsletters, usually 2-3 per month.