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
• 9,320 points
20 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
• 9,320 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 Edureka
• 8,820 points
39 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
• 9,320 points
27 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 Edureka
• 8,820 points
26 views
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 Edureka
• 8,820 points
51 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 Edureka
• 8,820 points
25 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 Edureka
• 8,820 points
27 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
• 9,320 points
54 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
• 9,320 points
30 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