To Fill Values Right or Down in a List in Excel

In this article, we will learn how to fill values in right of cell or down of cell.

In Microsoft Excel, to fill the same content of cell in the right, left, down, up cell, we have Fill option in Home tab under the Editing section.

 

image 1

 

image 2

 

 

Let’s take an example and understand:-

We have data in Excel showing in the below image:-

 

image 3

How to fill down in Excel?

In the above shown Excel sheet, we want to fill the finance till the last active cell (B9).

Follow below steps to fill down finance till the last active cell:-

  • Select the range B2:B9.
  • Go to Home tab > Editing > Fill > Down.
  • We can use shortcut key Ctrl+D

image 4

 

image 5

 

How to fill right in Excel?

In the above shown Excel sheet, we want to fill the finance in the right side range C2:C9.

Follow below steps to fill finance in the right side range:-

  • Select the range C2:C9.
  • Go to Home tab > Editing > Fill >Right.
  • We can use shortcut key Ctrl+R

image 6

 

image 7

 

This is the way we can fill the values in right, down, left, and up side by using the Fill option.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.