Accelerating data entry


show more Accelerating data entry provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Accelerating data entry

Data entry is generally a fairly boring topic, but we do throughout the course of using Excel need to put data in this worksheet, that worksheet. A few tips here are going to make this a little bit easier. In column A we have Name. We are going to be building a small list here, let's imagine. In column B we want to put in for example a current salary or 2011 salary. I would like to have the 2011 appear above Salary because maybe the entry below, it's not going to be that wide. So rather than putting in an entry and then using a command to format this, you can as you type an entry, press Alt+Enter to force a line break.

Keeps the data in the same cell, but it puts the data under the previous entry. I pressed Alt+Enter after the 2011. I am typing Salary. Now I am pressing Enter. It looks like this. And you could stack these up multiple times too. If I want to put in 2011 Tax Rate, the indicator below that maybe is only going to be a letter or two, 2011, Alt+Enter, Tax, Alt+Enter, Rate. ...

Accelerating data entry
Video duration: 6m 27s 3h 43m Intermediate

Viewers:

Accelerating data entry provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...