| 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
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| 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 | |||
Hybrid Mode
