Excel 2003 drag down cell to fill rest in column

  johnincrete 29 Sep 11
Locked

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.

  Woolwell 29 Sep 11

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.

  mobing 30 Sep 11

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 !

  johnincrete 30 Sep 11

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

Advertisement

This thread is now locked and can not be replied to.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

Wacom Cintiq 27QHD review

How to use Apple Music in the UK: Complete guide to Apple Music's features

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