Microsoft Office Tutorials and References
In Depth Information
The Excel User Interface
The following list of data-entry tips can help those moving up to Excel from another
● To enter data without pressing the arrow keys, enable the After Pressing Enter, Move
Selection option on the Advanced tab of the Excel Options dialog box (which you access
from the Office➜Excel Options command). You can also choose the direction that you
want to go.
● You may find it helpful to select a range of cells before entering data. If you do so, you can
use the Tab key or Enter key to move only within the selected cells.
● To enter the same data in all cells within a range, select the range, enter the information
into the active cell, and then press Ctrl+Enter.
● To copy the contents of the active cell to all other cells in a selected range, press F2 and
then press Ctrl+Enter.
● To fill a range with increments of a single value, press Ctrl while you drag the fill handle at
the lower-right corner of the cell.
● To create a custom AutoFill list, select the Edit Custom Lists button on the Popular tab of
the Excel Options dialog box.
● To copy a cell without incrementing, drag the fill handle at the lower-right corner of the
selection; or, press Ctrl+D to copy down or Ctrl+R to copy to the right.
● To make text easier to read, you can enter line breaks in a cell. To enter a line break, press
Alt+Enter. Line breaks cause a cell’s contents to wrap within the cell.
● To enter a fraction, type , a space, and then the fraction (using a slash). Excel formats the 0
cell using the Fraction number format.
● To automatically format a cell with the currency format, type your currency symbol before
● To enter a value in percent format, type a percent sign after the value. You can also
include your local thousand separator symbol to separate thousands (for example,
● To insert the current date, press Ctrl+; (semicolon). To enter the current time into a cell,
● To set up a cell or range so that it accepts entries only of a certain type (or within a certain
value range), choose the Data➜Data Tools➜Data Validation command.
Object and cell selecting
Generally, selecting objects in Excel conforms to standard Windows practices. You can select a
range of cells by using the keyboard (by pressing the Shift key, along with the arrow keys) or by
clicking and dragging the mouse. To select a large range, click a cell at any corner of the range,
scroll to the opposite corner of the range, and press Shift while you click the opposite corner cell.