+ Reply to Thread
Results 1 to 2 of 2

Thread: Column data shifts down for unknown reason

  1. #1
    Registered User
    Join Date
    01-11-2012
    Location
    Menlo Park, CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Column data shifts down for unknown reason

    I've used Excel for years doing general spreadsheet work--nothing fancy, mainly entering data, formulas, occasionally inserting rows and columns, etc. I've never had the problem I've experienced twice now in the last week, and unfortunately it's on a big database on my work computer in my new job.

    The problem is that I'll get data in a column to shift down 1 or more cell positions (one time it was just 1 position, another time it was 4 before I caught the error). It isn't noticed right away because of the sheer volume of data in the table for which I'm entering data, but there are occasional planned empty rows where it becomes clear the the shift has occurred. In other words, there are data continuing down in the "bad" column when there shouldn't be due to the empty row in the other columns, then there is the empty space in the "bad" column a few rows below the adjacent columns' empty space, and then the data resumes again the same number of rows below the start of the next set of data (in the other columns). There are only 2 columns in which I'm manually entering data (the other columns are filled-down data), and these are the columns where this phenomenon is happening.

    I'm not doing anything so direct as actively doing a "shift down" option on the column(s) in question. And so far it's only been a downward shift in the column data. So my question is: can there be any way this sort of thing can be happening due to an inadvertent key stroke mistake or any other indirect way that I'm not aware of? Obviously none of you is watching me do the data entry, but as I said I'm really not doing anything out of the ordinary (at least intentionally), and I've done this sort of thing for years without any such problem.

    Thanks in advance for any help/advice.

  2. #2
    Forum Guru TMShucks's Avatar
    Join Date
    07-15-2010
    Location
    Manchester, England
    MS-Off Ver
    MSO 2003 & 2007
    Posts
    6,224

    Re: Column data shifts down for unknown reason

    I think you can get strange effects if the scroll lock key has been pressed.

    Regards, TMS

+ 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.2.0