Are you tired of manually numbering your items on a regular basis? Whether it’s for a database, inventory lists or any other entries in columns or rows, manually filling in a hundred thousand cells can be a daunting task. But did you know that you can fill in a hundred thousand cells in just a few seconds with this neat trick in Excel?
Here’s how you can quickly enter numbers 1 through 100,000 in the left column. First, type “1” in cell A1. Then, go to the Home tab, click on the editing section, and select “Fill”. Click on “Series” and choose “Columns” to make it go up and down in column A. If you select “Rows”, it will make it go left to right. Keep the linear step value at 1, which is the value you would like to increase each cell by. If you want to go by 10, you can make the step value 10 instead of 1. Set the stop value to 100,000, and click OK.
Now, you can quickly navigate to cell 100,000 by hitting Ctrl and the down arrow on your keyboard. This trick will save you a lot of time if you need to fill in numbers on a regular basis.
If you’d like to follow along with the tutorial, you can download the workbook at teachexcel.com by searching for this video tutorial.
In conclusion, filling in a hundred thousand cells in Excel doesn’t have to be a tedious task. By using this simple trick, you can save time and increase efficiency.