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
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies