Enter Data Automatically Previous Topic

Previous Page
Next Topic

Next Page

Avoid repetitive typing and save time by entering some kinds of data automatically. You can automatically enter the same information in several cells, or enter an incremental series. A series can be numerals, such as 10, 20, 30; ordinals, such as first, second, third; dates; or months.

Two screenshots of worksheet cells show how to enter data automatically.

Tip Icon

Fill a range of cells   To fill a range of cells with the same text or value, type the text or value into one cell in the range, and then drag the fill handle in any direction.

Bar above and below the Sidebar

Use the TAB Key and Automatic Return

Use the TAB key to move to the next cell to the right. When you reach the end of a row, press ENTER to move to the first cell in the next row. All you need is one complete row of data or labels to identify the columns of your list.

A handy way to use this feature is to type numbers and press ENTER using the numeric keypad with your right hand and to press TAB with your left hand.

Bar above and below the Sidebar


Getting Around | Contents | Index

<< Previous Topic | < Previous Page | Next Page > | Next Topic >>

©1996 Office Getting Results Book.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.