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

Android One vs Android Silver vs Google Nexus: What is the difference?

IDG UK Sites

Apple updates MacBook Pro line-up: Price cuts & spec boosts for 6 MacBook Pro models

IDG UK Sites

Long live the internet fridge: the Internet of Things is coming

IDG UK Sites

How Prometheus' colourist Juan Ignacio Cabrera gave a tense, edgy feel to Chosen