Ace My Paper - get your Excel tasks done by experts. - makes your homework shine.


Excel tutorials

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 in Excel

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'.

Quick filling data in cells of Excel 2013 with a command Fill - 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.

Quickly fill the serial numbers in Excel columns


Quick filling serial numbers in a series one row in Excel cells

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.

Fast filling of serial numbers using the Fill Handle and copying in Excel

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).

Fast filling the cells a series of numbers using the command Fill Handle in Excel

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.

Excel Options and settings of texts or values ​​for fast serial filling in Excel 2013

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).

Example enrollment list for fast filling cell range in Excel

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).

Auto-fill cell range with names of days of the week in Excel - Fast filling predefined text