Microsoft Excel Tutorial: While building a telephone directory, you need to fill a column in Excel with the numbers 7900 to 7999. This episode shows you four different methods.
Update from 2022: There is a faster way to solve this using DOSE for Excel. Watch the newer video at [ Ссылка ]
Welcome to the MrExcel podcast. In this episode, we will be discussing how to fill a column with sequential numbers in Excel. This is a common task that many Excel users encounter, and there are multiple ways to achieve this. So, let's dive in and learn how to do it efficiently.
The question for this episode came in via Twitter: "I need help in Excel, I need a column of extension numbers from 7900-7999. How do I do this automatically?" I tweeted back with the answer, but it's one of those things that is hard to explain in 140 characters. So, I decided to create a video to demonstrate the process.
To start, enter the first number in the sequence (7900) in a cell and press Enter. Then, select that cell and go to the Home tab. Click on the "Fill" icon and choose "Series..." from the drop-down menu. In the Series window, change the option from "Rows" to "Columns" and enter the last number in the sequence (7999) as the "Stop value". Click OK and Excel will automatically fill the column with sequential numbers.
Another method to achieve this is by using a formula. In a new column, enter the first number in the sequence (7900) and in the cell below it, enter the formula "=B2+1" (previous cell +1). Then, double-click on the fill handle to fill the formula down to the desired number. However, this method may cause issues if a row is deleted in the future. To avoid this, you can copy and paste the values instead of the formula.
Another handy trick to fill a column with sequential numbers is by using the fill handle while holding down the Ctrl key. This will automatically extend the sequence to the desired number. You can also see a preview of the numbers before filling by hovering over the fill handle.
There are many other ways to fill a column with sequential numbers in Excel, but the method I suggested in the tweet was using the "Fill" and "Series" options. I hope this video was helpful in learning how to fill a column with sequential numbers in Excel. Don't forget to send in your questions via Twitter by tagging @MrExcel. Thank you for watching and we'll see you in the next episode of the MrExcel podcast.
Buy Bill Jelen's latest Excel book: [ Ссылка ]
You can help my channel by clicking Like or commenting below: [ Ссылка ]
Table of Contents:
(00:00) Episode Topic: Excel Fill a Column with Sequential Numbers
(00:21) Explanation of Different Methods
(01:06) Alternative Method: Using Formulas
(02:01) Alternative Method: Using the Fill Handle
(03:00) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelsequence #excelformulasandfunctions
This video answers these common search terms:
how to autofill numbers in sequence in excel
easy way to fill a sequence in excel
how to auto fill number sequence in excel
how to put sequential numbers in excel
how to autofill sequential numbering in excel
how do you sequence numbers in excel
how to get numbers in sequence in excel
how to enter number sequence in excel
how to populate numbers in sequence in excel
how to autofill number sequence in excel
how to fill in a number sequence in excel
how to fill sequence number in excel
Join the MrExcel Message Board discussion about this video at [ Ссылка ]
