How to enter a series of numbers automatically in Excel

0 votes
I have so many records but I need to enter serial numbers automatically in Excel 2007. I have hundreds of records. Instead of entering them manually I want them to show up automatically. Please give me short example for 1 to 10.
Mar 31 in Database by Edureka
• 13,640 points
25 views

1 answer to this question.

0 votes
Excel, unlike other Microsoft Office programmes, does not have a button that automatically numbers data. However, by sliding the fill handle to fill a column with a succession of numbers or by using the ROW function, you may quickly add sequential numbers to rows of data.

Tip: If you have Access installed on your computer and want a more advanced auto-numbering method for your data, you may import the Excel data into an Access database. When you create a new record in a table in an Access database, you can establish a column that creates a unique number automatically.

Fill in the blanks in a column with a series of numbers.
Fill the first cell in the range with whatever you wish.

Fill in the series' initial value.

To start a pattern, type a value in the next cell.

Choose the cells that have the initial values in them.

When you select more than one cell holding data in Excel 2013 and later, the Quick Analysis button appears by default. To finish this procedure, you can disregard the button.
answered Apr 4 by Edureka
• 13,640 points

Related Questions In Database

0 votes
0 answers

How to split a string of text in excel based on a given word?

I have a list of combinations of ...READ MORE

Apr 4 in Database by gaurav
• 13,460 points
47 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
87 views
0 votes
1 answer

[Excel][VBA] How to draw a line in a graph?

Sub MakeChart() Dim x(20) ...READ MORE

answered Mar 24 in Database by gaurav
• 13,460 points
72 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How can I calculate deciles with a range of 12,000 cells in excel?

1. Enter the following formula in cell ...READ MORE

answered Mar 25 in Database by gaurav
• 13,460 points
127 views
0 votes
1 answer

How to add a named sheet at the end of all Excel sheets?

Kindly use this one liner: Sheets.Add(After:=Sheets(Sheets.Count)).Name = "new_sheet_name" Or ...READ MORE

answered Apr 5 in Database by gaurav
• 13,460 points
28 views
0 votes
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

First, pick the cells that contain dates, ...READ MORE

answered Apr 11 in Database by gaurav
• 13,460 points
210 views
0 votes
1 answer

How to view the XML form of an Excel file?

Excel is a spreadsheet programme. Click File->Open in ...READ MORE

answered Mar 25 in Database by Edureka
• 13,640 points
103 views
0 votes
1 answer

How to transform multiple tables in one excel sheet to one table with Power BI?

If my prediction is correct- You have a ...READ MORE

answered Apr 4 in Database by Edureka
• 13,640 points
85 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP