We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel 2003 drag down cell to fill rest in column


johnincrete

Likes # 0

One of my columns is class e.g. A1, A2, A3 etc i.e a letter plus a number with no space between them. If I enter A1 and then click on the little + in the corner and drag it down, Excel increments the number A2, A3. A6 etc. which I don't want. I tried to copy the cell amd paste it into selected cells but it did not work.

Like this post
Woolwell

Likes # 0

Er - what do you want? If you want A1, A3, A5 then type that list in and then drag as before and it should become 7,etc.

If you want A1 all the way down then drag with the ctrl key held down.

Like this post
mobing

Likes # 0

i don't quite what he really want to do ?you can set a template you like to do then you can use ni your familiar way !

Like this post
johnincrete

Likes # 0

Thanks Woolwell. Same value in each cell is what I wanted. It will save me lots of time when the entries are much longer

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Samsung Galaxy S5 mini vs HTC One mini 2 comparison review: Design and price beats additional...

IDG UK Sites

Why local multiplayer gaming is rapidly vanishing: we look at the demise of split-screen and LAN...

IDG UK Sites

Colour-depth not resolution is what will make 4K a success or failure

IDG UK Sites

iPhone 6 vs iPhone 6 Plus: Which new iPhone 6 model should I buy?