Excel Tips - Quickly Fill Series of Numbers in a Few Seconds Fill Command

Toggle fullscreen Fullscreen button

Sharing buttons:

hi and welcome to this tutorial here I'm

going to show you a very neat trick to

fill a hundred thousand cells in just a

few seconds so what I'm going to show

you how to do is to enter the numbers 1

through 100,000 in the left column right

here oops

right here up and down now this is a

very important thing to learn if you

have to on a regular basis number your

items could be for a database could be

imported inventory lists anything that

you would like to have a number of for

the entries in the columns or the rows

so you may think to do it like this

enter 1 and to highlight them both grab

the quick fill handle and drag it down

right because you could fill it and you

could go like this and wait and wait and

wait but that's going to take a long

time if you're filling a hundred