Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default numbering rows in a simple spread sheet

How do you begin at A2 with the number 341209 and acend?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 127
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer CELL value and spread it among 24 ROWs on another sheet rhhince[_2_] Excel Worksheet Functions 1 June 22nd 07 11:00 AM
how to do numbering of rows in excel sheet anshu Excel Worksheet Functions 1 April 16th 07 02:32 PM
Printing a spread sheet and skipping rows. WAVIS Excel Discussion (Misc queries) 3 August 7th 06 05:02 PM
I'm creating a simple spread sheet Jan in Excel Excel Discussion (Misc queries) 2 January 2nd 06 07:48 PM
How do I get the top 4 rows of a spread sheet to print on each pa. joetut Excel Discussion (Misc queries) 1 December 28th 04 07:12 PM


All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"