What MS Excel method or shortcut can we utilize to insert more Roll No. in serial.
Question
What MS Excel method or shortcut can we utilize to insert more Roll No. in serial.
Solution
To insert more Roll No. in serial in MS Excel, you can use the Fill Handle tool. Here are the steps:
-
Enter the first two roll numbers in the first two cells. For example, if you start with roll number 1, enter '1' in the first cell and '2' in the second cell.
-
Select both cells.
-
Move your cursor to the bottom-right corner of the selection until it turns into a small black cross.
-
Click and drag the fill handle down the column to the last cell where you want the roll numbers to end. Excel will automatically fill in the rest of the roll numbers in sequential order.
-
Release the mouse button, and the selected cells will be filled with roll numbers in serial order.
This method is very useful when you need to create a large number of roll numbers.
Similar Questions
Q44. Pivot table option are located in .............. menu. Data Tools Insert Format
How many steps can be recorded on the Macros in MS Excel?20 - 30 steps or more50 - 100 steps or more100 - 200 steps or more
This OLAP Operation rotates the data, and delivers an alternative to the original presentation. pivotsliceroll-updice
Which technique for dragging and inserting a column of cells displays a dialog box asking you how you want the cells shifted?
In Open Office Calc, the formula” = Max (A2:A10)” stored in cell A11 when copied to cell B11it changes to ___________
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.