In this lesson you will learn how fill-down, fill-up, fill-left, fill-right, fill justify and fill series. Fill option is available in Home Tab in Editing group.
![Fill Option](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-0.jpg)
Fill-Down:
Fill down is used to fill the data from up side to down side. Shortcut Key is Ctrl+D.
In the below image he have a formula on cell “D2”. We can select the range “D2:D13” and press Ctrl+D to fill down the formula.
![Fill-down](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-1.jpg)
Formula will be filled down in the range.
![Fill down the formula](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-2.jpg)
Fill Up:
Fill Up is used to fill the data from down side to up side. Shortcut Key is Alt+E+I+U.
In the below image we have a formula in cell “D13”. We can select the range “D2:D13” and press Alt+E+I+U to fill up the formula.
![Fill Up](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-3.jpg)
Formula will be filled up in the range.
![Fill Up the formula](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-4.jpg)
Fill Right:
Fill Right is used to fill the data from left side to right. Shortcut Key is Ctrl+R.
In the below image he have a formula on cell “B4”. We can select the range “B4:H4” and press Ctrl+R to fill right the formula.
![Fill Right](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-5.jpg)
Formula will be filled right in the range.
![Fill Right the formula](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-6.jpg)
Fill Left:
Fill Left is used to fill the data from right side to left. Shortcut Key is Alt+E+I+L.
In the below image he have a formula on cell “H4”. We can select the range “B4:H4” and press Alt+E+I+L to fill left the formula.
![Fill Left](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-7.jpg)
Formula will be filled left in the range.
![Fill left the formula](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-8.jpg)
Fill Series:
Fill series is used to fill the data of a sequence . Shortcut Key is Alt+E+I+S.
For example we want to fill the serial number.
To fill the series below are the steps
- Select the first cell in the range that you want to fill.
- Type the starting value for the series.
- Press Alt+E+I+S
![Serial Number by Fill Series](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-9.jpg)
Below given window will be displayed
![Series Window in Excel](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-10.jpg)
Under Type, following options are available:
- Linear: Creates a series that is calculated by adding the value in the Step value box to each cell value in turn.
- Growth: Creates a series that is calculated by multiplying the value in the Step value box by each cell value in turn.
- Date: Creates a series that fills date values incrementally by the value in the Step value box and is dependent on the unit specified under Date unit.
- AutoFill: Creates a series that produces the same results as dragging the fill handle.
Click on linear, which is default selected in this case.
Click on OK button to fill the serial numbers.
![Serial Number by using series fill](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-11.jpg)
Fill Justify:
Fill Justify is used to fill the text in below cells if it is not fit in the cells . Shortcut Key is Alt+E+I+J.
For example we have a text PK: An Excel Expert in cell “I2” and It is not fill the cell.
Select the Cell “I2” and press Alt+E+I+J
![Fill Justify](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-12.jpg)
Below given massage will be displayed. Click on OK.
Text will be displayed like this now.
![Fill Justify](https://www.pk-anexcelexpert.com/wp-content/uploads/Fill/FillSeries/Fill-14.jpg)
Visit our YouTube channel to learn step-by-step video tutorials