LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
LPS LPS is offline
external usenet poster
 
Posts: 108
Default Auto Fill With Letters

Usign Excel 2000, can you create an autofill list using the letters of the
alphabet? For example, if I type a 1 in one cell and a 2 in the cell below,
I can then select both those cells and drag the autofill notich down to
create a numeric list, say, 1 2 3 4 5 6 7 8.

Can I do that with letters? If I type the letter a in one cell and the
letter b the cell below and then select both cells and drag the autofill
notch, all I get is the series: a b a b a b.

Any helpis greatly appreciated.

Thx,
L.




--
LPS
 
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
Auto Fill - working as expected? LynnS New Users to Excel 1 October 17th 06 08:20 PM
Formula to auto fill in following month. MagnoliaSouth Excel Worksheet Functions 7 October 2nd 06 02:10 AM
can I auto fill zip code column when city is typed Elsie C. Excel Worksheet Functions 1 September 28th 06 08:40 PM
turn off auto fill options box Excel 2003 martock Excel Discussion (Misc queries) 2 October 13th 05 02:23 AM
Auto Fill Options adarling Excel Discussion (Misc queries) 1 April 8th 05 03:09 AM


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

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

About Us

"It's about Microsoft Excel"