Microsoft Office Tutorials and References
In Depth Information
Learning some handy data-entry techniques
3. In the list box on the left, select Form.
4. Click the Add button to add the selected command to your Quick Access Toolbar.
5. Click OK to close the Excel Options dialog box.
After performing these steps, a new icon appears on your Quick Access Toolbar.
To use a data entry form, follow these steps:
1. Arrange your data so that Excel can recognize it as a table by entering
headings for the columns in the ﬁ rst row of your data entry range.
2. Select any cell in the table and click the Form button on your Quick Access
Toolbar. Excel displays a dialog box customized to your data (refer to Figure 13.7).
3. Fill in the information. Press Tab to move between the text boxes. If a cell
contains a formula, the formula result appears as text (not as an edit box). In other
words, you can’t modify formulas using the data entry form.
4. When you complete the data form, click the New button. Excel enters the data
into a row in the worksheet and clears the dialog box for the next row of data.
You can also use the form to edit existing data.
Entering the current date or time into a cell
If you need to date-stamp or time-stamp your worksheet, Excel provides two shortcut keys
that do this task for you:
■ Current date: Ctrl+; (semicolon)
■ Current time: Ctrl+Shift+; (semicolon)
The date and time are from the system time in your computer. If the date or time isn’t
correct in Excel, use the Windows Control Panel to make the adjustment.
When you use either of these shortcuts to enter a date or time into your worksheet, Excel enters a static value into
the worksheet. In other words, the date or time entered doesn’t change when the worksheet is recalculated. In most
cases, this setup is probably what you want, but you should be aware of this limitation. If you want the date or time
display to update, use one of these formulas:
Using Flash Fill
The Text to Columns Wizard works well for many types of data. But sometimes you’fill
encounter data that can’t be parsed by that wizard. For example, the Text to Columns
Wizard is useless if you have variable-width data that doesn’t have delimiters. In such a