If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

Dragging & Increasing Numbers in a Column

Usually when I use Excel if I type a number into a cell then select the cell and drag it down to copy, it will drag and copy the numbers, increasing each cell by 1. However today when I am using Excel it won't increase. It just drags and copies the same number. So for example I type the number 1, and when I select the cell and drag down, it just copies 1 all the way down the column. I also tried going into Edit>Fill>Series and selecting *Columns & *Growth and it still doesn't work. What could be going wrong ?

Re: Dragging & Increasing Numbers in a Column

Hi

It should work with Edit > Fill > Series > Growth. But you need to select multiple cells as well as type in not only a 1. Because the growth is calculated (correctly) whereby you specify to Excel only a 1, so you say the growth is 1 to 1. Not surprisingly, Excel fills down the cells only with ones, each time 1 * 1. Try it with 1 and right below 3.

Same applies to just the normal filling down. Specify the change to Excel. That is, put 1 and below -2 for example to have the series 1, -2, -5, -8, ...

Re: Dragging & Increasing Numbers in a Column

Originally Posted by StephenR

Try pressing Ctrl while you drag down.

Hey there Stephen. I know you replied to this thread years ago but I wanted to sign in (register, actually) to thank you. I've been SO annoyed with this issue for a long time and because I don't use Excel much, I never took time to figure it out.

Your suggestion was SIMPLE and CORRECT. Hours and hours over the past years trying to figure this silly thing out and all I had to do was press "CTRL". Thank you so much!

Re: Dragging & Increasing Numbers in a Column

You are not alone Sarah. If Wigi didn't know about it back then it must be pretty obscure. I only found it because you posted. I have always wondered about this. Stephen's post was a very good one and I learned something today too. GOLD!!!