Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Dragging & Increasing Numbers in a Column

  1. #1
    Join Date
    25th January 2006
    Posts
    59

    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 ?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    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, ...

    Wigi

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,977

    Re: Dragging & Increasing Numbers in a Column

    Try pressing Ctrl while you drag down.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    Re: Dragging & Increasing Numbers in a Column

    Nice point Stephen.

    EDIT: ... in case to increment with 1. My method handles cases where it is not 1. But I didn't know the Ctrl trick.

    Wigi
    Last edited by Wigi; March 31st, 2006 at 23:15.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    19th August 2011
    Posts
    1

    Re: Dragging & Increasing Numbers in a Column

    click on a cell and enter 1 then move your pointer to a point under the cell then your pointer will become like this + then hold Ctrl key down and drag it to a cell that you want

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    29th September 2012
    Posts
    1

    Re: Dragging & Increasing Numbers in a Column

    Quote Originally Posted by StephenR View Post
    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!

    -Sarah

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    18th August 2011
    Location
    Brisbane, Austalia
    Posts
    3,004

    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!!!

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    29th October 2012
    Posts
    1

    Re: Dragging & Increasing Numbers in a Column

    Quote Originally Posted by StephenR View Post
    Try pressing Ctrl while you drag down.
    Thank you Stephen. I just registered to say Thank you (same as Sarah). Cheers!!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Row Column Reference Display When Dragging
    By mrpincer21 in forum EXCEL HELP
    Replies: 1
    Last Post: December 12th, 2007, 01:45
  2. Inserting column and dragging down formulas
    By Cabbage88 in forum EXCEL HELP
    Replies: 4
    Last Post: July 6th, 2006, 01:38
  3. Increasing numbers by one.
    By ourmick in forum EXCEL HELP
    Replies: 4
    Last Post: April 20th, 2005, 18:31
  4. Replies: 8
    Last Post: December 31st, 2004, 23:28
  5. set increasing invoice numbers [SOLVED]
    By Dakkini in forum EXCEL HELP
    Replies: 20
    Last Post: May 9th, 2003, 03:49

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno