Mastering Fill feature in Microsoft Excel

When working with Microsoft Excel, sometimes you have to repeatedly enter the same information and get sick because you see that? Fill feature will help you complete tasks in a fast and extremely convenient.



We start with a simple data table as follows:

 
First you select the bottom row of the table and a line below it:

 
Then, click the Fill icon on the Home ribbon tab:

 
You choose the Down command in the drop-down menu:

 
Immediately you will receive:


The results show that when you select Fill and then Down, all selected cells will be filled in the content of the cells above them.
Next, select the table right column and a blank column next to it:


Then click on the Fill and Right, you will receive:

 
The results show that when you choose Fill Right then, all the selected cells will be filled cell contents left them.
Similarly, select the top row of the table and a blank row immediately above it:


And then click on Fill Up, you will receive:


The results show that when you select Fill it Up, all selected cells will be filled in the content of the cells below them.
And finally, select the left column of the table and a blank row to the left of it:


Then click on the Fill and the Left, you will receive:


The results show that when you select Fill and then Left, all selected cells will be filled in the cell's contents to them. simple but very useful.
Another option is inside another Fill Series, to see how the operation of this feature, select a blank cell and type the word 'January' then select 11 cells to the right:


Click Fill and Series, a popup menu will open:


Select AutoFill:


Then click OK you will get results:


This suggests that the purpose of the Fill Series is a series of auto-fill information and help you may not have been typed information into each cell. In the above example, the months of the year have been added automatically after you type just before the word 'January'. Besides the month, you can also work with the day of the week or even the special day of the year.
Let's try another example, typing on a cell number 25, then select a cell right next to it, and then click Fill Series, this time with you to default to the entry Rows in Series and Linear for the Type:


Excel has "guess" is you want to create a series of numbers count up from 25, of course with the help of you: you have to know this is a linear chain and the value of number is increased by 1 unit each time. Rather than just increased by 1 unit, you can increase the number of string values ​​with larger errors. For example, you start with the cell containing the number 5, then enter the following:

 
The results will be added to each cell 5 units:


Quite similarly, if you want your chain of a number of multiples each time, type a number in the first box, select all the cells to fill in automatically, select Fill and then Series, this time selecting Growth and type of deficit in the Step Value box:

 
Starting from number 5, we have been a series of numbers double in each of the next cell:

 
Microsoft Excel's Fill feature is really useful when working with spreadsheets, leaving little time to master it early will save you a lot of time working on next.