1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Unwanted added rows in Excel 2010

Discussion in 'Business Applications' started by inthecloset, Dec 16, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. inthecloset

    inthecloset Thread Starter

    Joined:
    Jan 8, 2009
    Messages:
    95
    I have a user who is accidentally adding multiple rows to her spreadsheet, and doesn't know how she's doing it. She will find 8 to 20 extra cells, most with exaggerated height, and she won't know how she did it. She uses a trackball instead of a mouse, and I don't know if that's related. The only information I can get from her is "I was just typing". Does anyone know of a likely way she might be accidentally adding these rows while working? The shortcuts I've seen don't seem like strong candidates, because they all involve multiple steps in which the user is presented with a confirmation dialog before the cells appear. I'm ready to install a keystroke monitor to figure it out.

    Thanks.

    edit: this is Excel 2010 in Windows 7.
     
  2. Yorkshire Guy

    Yorkshire Guy

    Joined:
    Dec 9, 2003
    Messages:
    563
    hi inthecloset,

    I don't use a trackerball, but does it have 'mouse' keys that are configured for actions such as the ctrl or shift keys.

    A bit confluted, but highlighting a number of rows and pressing ctrl and + together will insert that number of rows above the selection.

    To get the + key though requires shift, so it has to be 'ctrl and shift and +' all at the same time!

    lol
    Hew
     
  3. DoubleHelix

    DoubleHelix Banned

    Joined:
    Dec 9, 2004
    Messages:
    24,388
    If you're in physical proximity of the user, sit next to her and watch her. I used to do tech support, and I've heard the "but I'm not doing anything" story more than once. Then when you actually watch them, you see them clicking on 20 different buttons and custom macros, toolbars, etc.
     
  4. inthecloset

    inthecloset Thread Starter

    Joined:
    Jan 8, 2009
    Messages:
    95
    Thanks. I've been avoiding it, but I think I'll have to sit beside her. I suspect it's some sort of accidental select & copy thing, as you guys have suggested, I just haven't found a good key combination candidate that might do it. The extra cells commonly have a repeating pattern, such as 8 large, 2 thin, 8 large, etc. That also makes me think it's some key combination.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1031501

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice