SOLVED
Home

Help with copying and adding a numerical value

%3CLINGO-SUB%20id%3D%22lingo-sub-401408%22%20slang%3D%22en-US%22%3EHelp%20with%20copying%20and%20adding%20a%20numerical%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401408%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20help%20with%20what%20I'm%20assuming%20is%20something%20fairly%20basic......%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20often%20need%20to%20write%20columns%20with%20say%2C%20W1%2C%20W2%2C%20W3%2C%20W4%20etc%20etc%2C%20and%20I%20don't%20know%20how%20to%20retain%20the%20%22W%22%20bit%20and%20then%20add%20a%20number%20as%20I%20copy%20it%20down%20through%20however%20many%20rows%20I%20need%20it%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%2C%20and%20if%20so%2C%20how%20do%20I%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-401408%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401414%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20copying%20and%20adding%20a%20numerical%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315502%22%20target%3D%22_blank%22%3E%40Schmule%3C%2FA%3E%20%2C%20you%20are%20welcome%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401410%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20copying%20and%20adding%20a%20numerical%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401410%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20really%20simple%20but%20I%20couldn't%20work%20it%20out%20for%20the%20life%20of%20me!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20again.%20Enjoy%20the%20rest%20of%20your%20weekend%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401409%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20copying%20and%20adding%20a%20numerical%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401409%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315502%22%20target%3D%22_blank%22%3E%40Schmule%3C%2FA%3E%20%2C%20you%20may%20use%20autofill%2C%26nbsp%3B%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fautofill.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fautofill.html%3C%2FA%3E%3C%2FFONT%3E%2C%20other%20words%20type%20W1%20and%20drag%20it%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E
Schmule
New Contributor

Hi there,

 

I hope someone can help with what I'm assuming is something fairly basic......

 

I often need to write columns with say, W1, W2, W3, W4 etc etc, and I don't know how to retain the "W" bit and then add a number as I copy it down through however many rows I need it to.

 

Is this possible, and if so, how do I do it?

 

Thank you in advance.

3 Replies
Solution

@Schmule , you may use autofill, https://www.excel-easy.com/examples/autofill.html, other words type W1 and drag it down

Highlighted

Thank you so much@Sergei Baklan 

 

That is really simple but I couldn't work it out for the life of me!

 

Thank you again. Enjoy the rest of your weekend :)

@Schmule , you are welcome, glad to help

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