Fill alphabets

  • Thread starter Thread starter shibu
  • Start date Start date
Shibu

You can set it up as a custom list. Enter A, B, C, etc in cells A1:A26 and
then go to Tools>Options...>Custom List and in the import from cells enter
A1:A26 and import, click add and close the dialog.

Now when you type A, B in two concurrent cells, select both and drag the
fill handle it will create as per your new list

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk


in message news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unchecking "Extend data range formats" is not workingfor row shading 1
Analysis ToolPak - exactly the same problem 1
Excel Survey 2
For Datagrid 2
i want to select a date in calander 1
/? 2
hkey_classes_root\pst\ does not exist 1
Ia deleting Vista's defender an option? 1

Back
Top