• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Entering and Editing Labels a... > Entering Data Quickly with Auto Fill

Entering Data Quickly with Auto Fill

Excel features a couple of tricks for quick data entry. It can copy an entry from one cell into as many additional cells as you like, or it can fill several cells with a series of entries, such as the months of a year or a series of numbers that increase incrementally (5, 10, 15, 20, 25...). You simply type one entry and then order Excel to fill in the rest.

The easiest way to fill a series of neighboring cells is to use the cell selector’s fill handle. The fill handle appears as a tiny dark square in the lower-right corner of the selected cell. To use the fill handle to copy an entry into other cells or to fill neighboring cells with a series of entries, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint