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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies