Write the steps to create an auto series(1,3,5.....999) in ms excel
Answers
Answered by
1
It's easy and fast to create a number series in Microsoft Excel. Understanding how to use the spreadsheet correctly to generate an automatic number series will save you a lot of time, especially if you are working with a large amount of data.
The steps are given below:-
1. Open Microsoft Excel.
2.Double-click on “blank workbook” to open it. Or, if you already have an Excel spreadsheet filled with data, open the spreadsheet.
3.Click on the cell that you want to start the number series in.
4.Figure out the increment for your number series.
5.Click and hold to highlight all the cells with your numbers.
6.Hover your cursor over the little black (or green) square in the bottom right cell.
7.Left click on your mouse while hovering your cursor over the plus sign.
8.
Use an Excel formula to generate a number series. Put your cursor in that cell. This means the block that is located where Column A meets Row 1.
In that cell, type =ROW(). This formula should generate the first number in your series. Select the fill handle on the bottom right of that cell, and drag down or across to create the number series.
If you want to find the number of any cell, you can put your cursor in it, and type =ROW(C10), replacing C10 with the coordinates of that cell.
9. Hit enter.
10.Right click on the plus sign with your mouse, and drag the fill handle.
The steps are given below:-
1. Open Microsoft Excel.
2.Double-click on “blank workbook” to open it. Or, if you already have an Excel spreadsheet filled with data, open the spreadsheet.
3.Click on the cell that you want to start the number series in.
4.Figure out the increment for your number series.
5.Click and hold to highlight all the cells with your numbers.
6.Hover your cursor over the little black (or green) square in the bottom right cell.
7.Left click on your mouse while hovering your cursor over the plus sign.
8.
Use an Excel formula to generate a number series. Put your cursor in that cell. This means the block that is located where Column A meets Row 1.
In that cell, type =ROW(). This formula should generate the first number in your series. Select the fill handle on the bottom right of that cell, and drag down or across to create the number series.
If you want to find the number of any cell, you can put your cursor in it, and type =ROW(C10), replacing C10 with the coordinates of that cell.
9. Hit enter.
10.Right click on the plus sign with your mouse, and drag the fill handle.
Similar questions