ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   numbering rows in a simple spread sheet (https://www.excelbanter.com/excel-discussion-misc-queries/188334-numbering-rows-simple-spread-sheet.html)

turtle

numbering rows in a simple spread sheet
 
How do you begin at A2 with the number 341209 and acend?

Gaurav[_3_]

numbering rows in a simple spread sheet
 
A2 341209
A3 341210

Select both the cells aand drag it down.

Or

A2 341209
B2 =A2+1

Select B2 and drag it down



"TURTLE" wrote in message
...
How do you begin at A2 with the number 341209 and acend?




Steve[_13_]

numbering rows in a simple spread sheet
 
On May 21, 11:50*am, TURTLE wrote:
How do you begin at A2 with the number 341209 and acend?


Highlight A2 and all cells below you want to fill
Edit, Fill, Series
Select your step value, click ok

David Biddulph[_2_]

numbering rows in a simple spread sheet
 
=A2+1
--
David Biddulph

"TURTLE" wrote in message
...
How do you begin at A2 with the number 341209 and acend?





All times are GMT +1. The time now is 08:34 PM.

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