Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on Create automatic series of a b c..z in excel within the Geeks Lounge forums, part of the Geeks Community category; I have tried to create automatic series of a b c..z in excel by dragging cells. But not coming properly.. Please help in this matter.....
|
|||||||
| Geeks Lounge General and off topic threads containing intellectual discussion |
![]() |
| LinkBack | Thread Tools | Display Modes |
|
|||
|
Create automatic series of a b c..z in excel
I have tried to create automatic series of a b c..z in excel by dragging cells.
But not coming properly.. Please help in this matter.. |
| Sponsored Links |
|
|||
|
Re: Create automatic series of a b c..z in excel
Kevin,
The reason why excel does not autofill an automatic Series of alpahbets is because there are few autofill Series created in Excel by default. These include Numbers, Dates, Months etc but alphabet series are not present. You can create a Custom list to accomplish your purpose. Go to Tools - Options and select Custom List. Select New List. Enter the alphabet series (Remember to hit the Enter key after every entry) and click on Add. This creates a Alphabetical series. Now you can use the fill handle to create an automatic Series of alphabets further on for all times. Cheers.....
__________________
V.Umesh Krishnan QA Consultant |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Create a table in excel | demo676 | WinRunner | 1 | 02-13-2008 09:08 AM |
| Read excel values into script without opening excel | nemishdmehta | QTP | 1 | 02-11-2008 07:19 AM |
| Automatic Data Replication | Lokesh M | Data Warehousing | 0 | 01-08-2008 06:20 AM |
| Automatic Data Partitioning | Lokesh M | Data Warehousing | 0 | 01-08-2008 06:18 AM |
| Default and Automatic account assignment | Lokesh M | SAP R/3 | 0 | 12-08-2006 05:37 AM |