How to Quickly Copy Cell Value or Fill a Series in MS Excel

MS Excel is the ultimate tool to choose if you want to maintain rows and columns of data, and want to apply some basic rules like filtering, sorting and data conditions. However, working on the same and editing or copying cell values is a little time consuming and, kinda boring.

Here is a cool tip on multiple ways of copying a cell value to the rows beneath it or filling the rows with a number series.

Method 1

Select a cell or a number occupied cell that you would like to copy to or fill the series with, in the cells below it. Hover towards the bottom right corner of the cell till your mouse pointer turns into a cross symbol.

Pull Cross

Now drag the cross up to the row till where you would like to copy the selected cell or fill the number series with. When you leave the mouse a tiny box would appear. Click on that box and choose the option that fits best to your requirement.

Choose Option

Method 2

Select a cell and drag the cross symbol while holding the Ctrl key to fill the rows with continued series. Doing so with the Alt key held will copy the cell’s value to the rows till where you drag the mouse pointer.

Method 3

If two consecutive row cells have the same value, you can select both of them and drag the cross symbol to copy the value to rows below them.

Clone Cells

If they have consecutive number values, selecting them together and dragging them fills the series.

Fill Series

Do you think this will ease your tasks and working methods with an Excel sheet? Will it work as a time saver for you?  It does for me. Tell us what you think.

Last updated on 03 February, 2022

The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.