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.
Let’s take an example and understand:-
We have data in Excel showing in the below image:-
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:-
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:-
This is the way we can fill the values in right, down, left, and up side by using the Fill option.
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.