Question Locked

Excel 2007 -

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi everybody - your are my last hope!
In recent versions of Excel you could use ctrl + or - (minus) to add or remove rows and columns.
It doesn't work in v2007.
Is it really true that you need to use ALT + varous menu letters to do the trick.
Thank you in advance to the hero that helps me out.
Vivi Mathiesen

4 replies

by thumbsup2

... especially if you're not using the English version of Office 2007 but use it on Windows Vista.

http://forums.microsoft.com/technet/showpost.aspx?postid=2977643&siteid=17&sb=0&d=1&at=7&ft=11&tf=0&pageid=0

In that forum thread, the workaround seems to be to set Excel to run in WinXP compatibility mode.

You might try CTRL+SHIFT+Plus (+) which displays the Insert dialog box to insert blank cells and you will have a choice to select insert whole row. I don't have Excel 2007 to test it with, but I found that shortcut listed on one of the MS tutorial sites. This key combination does not work in my version (2003).

by vivsdotdk

Thank you for taking your time to find that thread. I had already spent hours and hours on the net (incl. MS Site) with no luck.
As I'm new in this forum I don't know if or how to give you credit (points) for this, but you definately deserve a lot!
Brgds
Vivs

by thumbsup2

... look underneath where it says the person's nickname. There is a link that says "Mark as helpful" next to "View Profile" and "Add to Contacts". At least, that's what I think it says. I can't remember myself because it only appears for the person who started the question.

This discussion is closed to new replies.