It often happens that we need to quickly fill some data in working with Excel. Excel 2013 has fast filling cell range for certain defined values or text. For example, see the image below.
Fill Handle grip in Excel
Fill Handle on one cell
The Fill Handle is often used when copying the content of the Excel cell. Notice how it looks and what is 'Fill Handle'. When you click on a mouse cell, ie when you select or mark the cell in the lower corner, a small square appears (This green square is called the Fill Handle.) When the mouse pointer moves to the Fill Handle, it automatically transforms into a 'cross' filled with black. Left mouse button at that transformation moment, you have the ability to copy the contents of the cell concerned.
Fill Handle on Multiple Cells
If you select multiple cells, you also have Fill Handle. In this case, when selecting the Fill Handle range, it is located on the last selected cell in the lower right corner (so, the intersection of the last row and last column, a selected range).
How quickly enter several hundreds
or thousands of numbers in a series
If you wish to complete a series of serial numbers or series of numbers with a specific distance then we can do this through command 'Fill' => 'Series' on the toolbar 'Home'. Before running the commands required to enter the number of start number in the cell and select the respective cell. So after selecting a cell, click on the command "Fill" then the drop-down list, choose the command 'Series'.
This opens the dialog window 'Series' where you will see the options that you have available. Depending to the desire and intent of the direction in which you want to perform serial filling cells, choose Rows or Columns. You Set the step value as the distance between two numbers as well as to fill out, which is the last number in the series. Look at the two pictures below.
Serial numbers or filling values in the cell range you can do using the 'Fill Handle' grip.
'Fill Handle' grip is used to copy a cell and the value or formula in it.
The first way is to click your mouse pointer on the "Fill Handle" grip, hold the mouse button and drag down (or right). Note the expanding of the selected cell and the number or value that appears in the box during a dragged mouse cursor. When you reach the desired value, release the left mouse button.
Another way is to grip Fill Handle right-click mouse and hold. Drag the cursor down (or right), and when a number of the desired number in the box, release the right mouse button. Now you appear drop-down list to choose which one of the available commands. I am in this case chose Fill Series. (see images below).
How quickly fill cells names of Months of the Year or the names of Days of the Week.
In cases where you need to quickly write down the cells with specific text, then you can use a defined list with which you can quickly fill a range of cells. The 'Excel Options' => 'Advanced' => 'Edit Custom Lists' we can see that list are already defined.
Creating new lists for fast filling cells in Excel
To define a new list to fill a range of cells, do the following. In the dialog box Custom Lists please select the option 'New List' and then in the right part of the window, type your list, or choose from a list of cells on the worksheet, click on the button to switch to the worksheet, Excel, and after selecting the cells containing the list, click on the 'import' button to import list. (see picture below).
Based on the list (image above) create a table with data in a series, for example in Excel 2013, in the headings are the names of the months of the year or days of the week, Excel 2013 automatically recognizes the string and enters the data for us (see picture below).