Chapter-1: Fill-Down,Up,Left,Right,Justify and Series

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
Fill Option

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
Fill-down

Formula will be filled down in the range.

Fill down the formula
Fill down the formula

 

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
Fill Up

Formula will be filled up in the range.

Fill Up the formula
Fill Up the formula

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
Fill Right

Formula will be filled right in the range.

Fill Right the formula
Fill Right the formula

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
Fill Left

Formula will be filled left in the range.

Fill left the formula
Fill left the formula

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
Serial Number by Fill Series

Below given window will be displayed

Series Window in Excel
Series Window in Excel

Under Type, following options are available:

  • LinearCreates 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
Serial Number by using series fill

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
Fill Justify

Below given massage will be displayed. Click on OK.

Pop up of Fill justify

Text will be displayed like this now.

Fill Justify
Fill Justify

 

Visit our YouTube channel to learn step-by-step video tutorials

Youtube.com/@PKAnExcelExpert

Next Chapter