Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  Flatpress         News     Education     Equipment     Family     Bookmarks     Windows     Tutorials     Plausible Lies     Excel     Software     Hardware     Reviews     Bits and Bobs     VBA     Browsers     Odds and Sods     Word     Acrobat     3D Stuff     PHP     Overcoming Disabilities     Utilities  

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

How to create an alphabetical list in Excel

Permalink: http://paul.us2uk.eu/?x=entry:entry170331-151659

There didn’t seem to be a way to create a custom list in Excel which would allow you to put letters of the alphabet down one column (unless you typed one in by hand for however many letters you want to go down to) so here’s a formula I dreamt up to do just that.

=SUBSTITUTE(ADDRESS(ROW(),COLUMN()+ROW()-COLUMN(),4),ROW(),”")

This will work in any column and will keep incrementing the lettering well past “Z” (which is a limitation of some other formulae I found to do the same job).

My formula will only work if you start the sequence in the first row because it works by setting the column number as the current row number - so row 1 will be “A”, row 26 will be “Z”, row 5000 will be “GJH”, and so on.

If you need to start your list in any row other than row 1 then you’ll either need to adapt the formula somehow (good luck with that - but please let me know if you have any success) or simply create a list starting in row 1 on a new blank worksheet then the list and paste it as values (so you just get A, B, C, etc. instead of the formula) in the cell where you want your list to start. The keyboard shortcut I use to paste values is Alt-E,S,V., or you can do it the standard way - see the help section for your version of Excel for instructions if you get stuck.

The beauty of this is that the exact same fomula work in any cell and in any column.

image

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.

Support our caregiving

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.