Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 03:07 PM
Grant
 
Posts: n/a
Default Numbering every second row

When i type 1 in the first cell and drag it down it creates a nice numbered
list. Is there a way to number only every second row?

Thanks,
Grant



  #2   Report Post  
Old May 16th 05, 03:24 PM
Jason Morin
 
Posts: n/a
Default

Select the cell with 1 *and* the cell below it. Now fill down.

HTH
Jason
Atlanta, GA

"Grant" wrote:

When i type 1 in the first cell and drag it down it creates a nice numbered
list. Is there a way to number only every second row?

Thanks,
Grant



  #3   Report Post  
Old May 16th 05, 03:25 PM
Max
 
Posts: n/a
Default

Try this ..

Put in A1: 1, in A3: 2
Select A1:A4, fill down asdesired
(note that the selected range includes a 2nd blank cell, A4)
--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----
"Grant" wrote in message
...
When i type 1 in the first cell and drag it down it creates a nice

numbered
list. Is there a way to number only every second row?

Thanks,
Grant




  #4   Report Post  
Old May 16th 05, 03:37 PM
Grant
 
Posts: n/a
Default

Beauty, thanks for your prompt help!!

"Grant" wrote in message
...
When i type 1 in the first cell and drag it down it creates a nice
numbered list. Is there a way to number only every second row?

Thanks,
Grant





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
Numbering add in Paul Excel Discussion (Misc queries) 2 March 23rd 05 03:46 PM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 05:41 AM
excel numbering add-in Fran Excel Discussion (Misc queries) 2 February 3rd 05 09:43 PM
Page Numbering Silver Excel Discussion (Misc queries) 1 January 13th 05 06:55 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 11:49 PM


All times are GMT +1. The time now is 02:21 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017