+ Reply to Thread
Results 1 to 2 of 2

Dragging cell data right, excel starts adding to value

  1. #1
    Registered User
    Join Date
    01-15-2005
    Posts
    10

    Dragging cell data right, excel starts adding to value

    Sorry for so many post today. This will be my last topic. When I drag my data right, excel automatically thinks I want to add 1 to the cell value. IE: if A1 = 1001.45 or 1001x45, if I click the bottom of the cell to drag right, B1 will be 1001.46 or 1001x46. I want to be able to drag the data right, but I want to make it stay the same. These cells has to be numbers.

    Thanks

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451
    Type (or copy/paste) the same number into the adjoining cell.
    Highlight both cells and then drag.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1