Unwanted added rows in Excel 2010

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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

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.
 

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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top