excel

%3CLINGO-SUB%20id%3D%22lingo-sub-497319%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-497319%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%3C%2FP%3E%3CP%3Ei%20want%20to%20add%20some%20alphabets%20at%20starting%20in%20a%20cell%20and%20copy%20them%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-497319%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
jack_1981mentions
Occasional Visitor

hi

i want to add some alphabets at starting in a cell and copy them down

1 Reply

Hi @jack_1981mentions 

 

Adding a custom list is probably the way to go. Try this:

 

1. Go to File > Options > Advanced. Scroll down until you see Edit Custom Lists... in the General section and click to open.

 

capture20190429155233763.png

 

2. Under List entries, click into the field and type A, then press Enter, type B, and repeat the process. Click Add and OK when done.

 

capture20190429155443058.png

 

3. Go back to your spreadsheet and type A into cell A1, and B into cell B1.

 

capture20190429155733489.png

 

4. Highlight both cells and left click onto the bottom right of the cell to Autofill. Drag down until happy.

 

capture20190429155819105.pngDo this second

5. You should see the letters come out correctly.

 

capture20190429160052699.png

 

Best wishes

Damien