I am trying to insert blank cells into my rows. In the Office XP I would just highlight the cells and ctrl+ and it would insert my cells. When I do that now, it is inserting a whole row! I don't want a row I want 2 cells .



I have tried using the insert cells in the tool bar at the top, and it also inserts a row rather than cells.

Is there a fix for this????

Select the cells, right-click on them and choose Insert.

Ctrl + still works for me though.

Unfortunately when I right click it gives me the option to insert a row but not cells. I'm figuring I must have accidentally turned on an option somewhere, but I cannot find it.

Hi there,

It is possible to just insert the number or cells you want. For step by step directions, check out this link on the Office help page and scroll to the section that says "Insert Blank Cells on a Worksheet" : http://office.microsoft.com/en-us/ex...CH100648141033.

I hope this helps!

Isabella
MSFT Office Outreach Team

Hello, Thanks for the link. Unfortunately, I followed all of the directions and I still have inserted a row instead of the few cells that I want.

I finally created a new document and pasted the data into it. Now I can insert cells. Excell 2007 must not play well with 2003 files.