ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to get number series in excel 1 2 3 4 etc (https://www.excelbanter.com/excel-worksheet-functions/38225-how-get-number-series-excel-1-2-3-4-etc.html)

Demain

how to get number series in excel 1 2 3 4 etc
 
DO A RUNNING SERIES, 21368 WHEN i HIGHLIGHT AND PRESS FILL DOWN SERIES i
expect 21369, 21370 and so on. thanks

Bob Phillips

Enter the first two and then fill-down.

--
HTH

Bob Phillips

"Demain" wrote in message
...
DO A RUNNING SERIES, 21368 WHEN i HIGHLIGHT AND PRESS FILL DOWN SERIES i
expect 21369, 21370 and so on. thanks




Duke Carey

You state what you expect; what are you getting?

Are you selecting a range first? What happens if you right-click on the
fill handle (small square at the bottom right corner of the cell) and drag?


"Demain" wrote:

DO A RUNNING SERIES, 21368 WHEN i HIGHLIGHT AND PRESS FILL DOWN SERIES i
expect 21369, 21370 and so on. thanks



All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com