Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

Three Ways To Quickly Fill/ Populate Data

Date:2022-1-14 Author:Sandra

Populating data or Auto-fill data is an essential step in our daily work. I guess many people will choose to drag and fill. Actually, this kind of way is simple to operate. But it is only suitable for the case of relatively few data.

Three Ways To Quickly Fill/ Populate Data

In today’s tutorial. We will get to learn three more useful ways of filling data.

What if you need to enter the number 1 to 100 or even 10000? Let’s take the example below.

Three Ways To Quickly Fill/ Populate Data

Highlight cell A1 and go to the Home tab and click on the arrow of Fill and choose Series.

Three Ways To Quickly Fill/ Populate Data

You can choose Data Type, unit, and Step value.. here. Then, hit OK.

Three Ways To Quickly Fill/ Populate Data

The second way is the fastest. You just need to double-click the black solid cross.

Three Ways To Quickly Fill/ Populate Data
Three Ways To Quickly Fill/ Populate Data

How to quickly fill in the same data?  This method is similar to the drag and fill, but with a few differences.

Three Ways To Quickly Fill/ Populate Data

Select the area including the value you want to repeat and press Ctrl and D keys to quickly fill down.

Press Ctrl and R to quickly fill right.

Three Ways To Quickly Fill/ Populate Data
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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