fill data series automatically in Excel

Q113. In Excel, how can I fill a series of data automatically?

For example, I assign product codes as and when new products are added. The product codes are increments of 1 starting from 17000. Is there an alternative to typing in Product code in every field manually?

excel fill data series automatically

To do it in Excel, here is the answer:

a) Manually enter the first 2 values so that Excel can recognize the increment. Then click and drag bottom right corner (where there is a plus mark) to the rest of the column.

excel excel fill data series automatically

b) Excel auto fills the entire column.

excel excel excel fill data series automatically

c) This method could be used to auto fill numbers, dates, months etc.,


You can find similar Excel Questions and Answer hereunder

1) I have a very complex macro that runs for a long time - is there any way I can set up an audible alarm indicating macro run is over?

2) How can I get the count of number of series in a Chart using VBA?

3) How can I set the Source Data of charts using VBA?

4) I have a WorkBook that loads a form automatically when it is opened. In Excel, how can I suppress the form from loading on file open when required?

5) I have data arranged in rows of information. Is there any way I can enter new data through a form instead of entering it directly in SpreadSheet?

6) How can I filter and copy only filtered data using VBA?

7) How can I filter a table to get all records that have less than a particular value in a specific column?

8) How can I delete all shapes in a WorkSheet?

9) How can I fill a range of cells with incremental times?

10) How can I dynamically add series to an existing chart using VBA?

11) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

12) How can I get row count of filtered data?

13) How can I create dependent drop down lists?

14) How can I identify all cells with Data Validation in my WorkSheet?

15) How can I update a listbox based on data in a list using VBA?