Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education


Automatic filling series - fast data entry in Excel 2013

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.

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 column
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 cell numbers in a series using the Fill Handle

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.

Where to set up a new list to quickly fill cells in Excel

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

The list of texts for fast serial filling cells 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).

Fast filling predefined text cells in Excel