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, 2022 in Database by Edureka
• 13,670 points
539 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, 2022 by Edureka
• 13,670 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, 2022 in Database by gaurav
• 23,260 points
231 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, 2022 in Database by Edureka
• 13,670 points
1,698 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, 2022 in Database by gaurav
• 23,260 points
1,525 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, 2022 in Database by gaurav
• 23,260 points
7,758 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, 2022 in Database by gaurav
• 23,260 points
397 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, 2022 in Database by gaurav
• 23,260 points
151,905 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, 2022 in Database by Edureka
• 13,670 points
5,039 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, 2022 in Database by Edureka
• 13,670 points
2,511 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP