Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I fill in a column with the alphabet
I know there is a way that I can type in a in cell a1,b cell a2, b , cell a3,
c and then drag to the bottom of the column and it will continue with d, e,f, etc but have forgotten.Can somebody please remind me again. Thanks |
#2
|
|||
|
|||
Tools - Options - Custom Lists. Should be easy from there... -- barrfly Excel User - Energy markets ------------------------------------------------------------------------ barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141 View this thread: http://www.excelforum.com/showthread...hreadid=471751 |
#3
|
|||
|
|||
Hi Vincent,
Use of the fill handle http://www.mvps.org/dmcritchie/excel/fillhand.htm I think you will also have to make up a custom list also described on the page. A, B, C, ...., X, Y, Z, a, b, c, d, ... , x, y, z . try filling down if it doesn't work you will need th custom list. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Vincent" wrote in message ... I know there is a way that I can type in a in cell a1,b cell a2, b , cell a3, c and then drag to the bottom of the column and it will continue with d, e,f, etc but have forgotten.Can somebody please remind me again. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill the entire column with a function | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |