發布於 2014-06-30
觀看次數: 304733
  • 00:47 1.
    Autofill
  • 00:58 2.
    Fill pattern
  • 00:51 3.
    Copy Formulas
  • 00:41 4.
    Double Click Fill Handle
  • 01:17 5.
    Create a Custom List
  • Index
  • Note
  • Discuss
  • Fullscreen
Using AutoFill to Enter Data
04:36, 發布於 2014-06-30 by Excel Mr.
This demo page shows you how those powerful features of Camdemy, including keypoint, FAQ, video note, video quiz, video index, work with your videos.

Instead of entering data manually on a worksheet, you can use the AutoFill feature to copy data or add a series of data with a specific pattern. For example, you can type in the first value of month, weekdays, or a series of numbers, and let Excel fill in the rest.
 
5eba8c06248c043c6fb1263b95fde153.png
1.
Add a pre-set list of data
To quickly fill a series of regular data, such as Sunday, Monday ... Saturday or 1, ,2, 3, 4..., you can enter data into the first cell and use the Fill Handle to fill in the rest. The following are the steps to fill in the days of a week.
 
      a. Enter 'Sunday' in a cell and click on the cell.
      b. Move the mouse pointer to the bottom right corner and it will appear the Fill Handle.
      c. Drag the Fill Handle to auto fill the days from Monday to Saturday.
62fcfb6e86819507990df3b7248fd93f.png

NOTE: Here are some examples of regular data
  • days of week: Sun, Mon, ...
  • month of year: January, Feburary, ...
  • month and year: Jan-2014, Feb-2014, ..., Dec-2014
2.
Add a series of numbers
You can use the Fill Handle to add a series of numbers to an Excel spreadsheet. The following are the steps to fill a series of incremental numbers: 1, 2, 3, 4...
 
      a. Type '1' and '2' in the first and second cells, respectively.
      b. Select the two cells.
      c. Drag the Fill Handle down to fill the numbers.
5c1dc3e587581c395f4a9e100aa3766c.png

NOTE: Notice that you should enter enough data to show Excel the pattern.
For example, if you want the series 1, 3, 5..., type 1 and 3 in the first two cells to match the pattern of odd number.
3.
Fill adjacent cells
There's a more efficient way to copy data. Drag the Fill Handle of the selected range to quickly fill the adjacent cells. Excel will repeat the pattern if the data doesn't match the pre-set list. This function is especially useful for copying formulas. Here is an example:
      a. Enter a formula in the first cell.
      b. Drag the Fill Handle down to copy the formula to adjacent cells.
d6440890345546ececa6529b97e587e8.png

Tips: Double-clicking the Fill Handle copies your selection downward when there is data in an adjacent column. Excel will auto fill the following cells as far as there is data in the adjacent column. This is especially useful when you are working with larger amounts of data.
4.
Add a custom list of data
In addition to the built-in list, you can define a custom list of your own for any sequence of data, such as a list of names or sales region. The newly defined list will be in effect the next time you drag the Fill Handle.

To create the custom pre-made series, you can
      a. Click File and choose Options.
      b. In Advanced category, inside General region choose Edit Custom Lists.
1d89b05f973aff152088771733c59a83.png
 
      c. In List entries, enter data to create your own custom lists.
      d. Press Add to add the list.
755b0bdf403f30d479071f9ffe269b1b.png
 
       e. Enter the data of your list and drag the Fill Handle down. It shows the custom list that you've added.
ee0cbb5661f66185e6a511fba187df96.png