whats the keyboard short cut for inserting a row in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Subin - 10 Mar 2005 09:43 GMT

whats the keyboard short cut for inserting a row in Excel , deleting a row

Reply to this Message

Ron de Bruin - 10 Mar 2005 10:27 GMT

Hi

Ctrl +
CTRL -

If you select the row header you don't see the dialog

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> whats the keyboard short cut for inserting a row in Excel , deleting a row

Reply to this Message

Rajesh HR, BAngalore - 11 Mar 2005 05:49 GMT

Select the location for inserting a New Row

Press <CTRL> and press +,

This would insert a New ROW

> whats the keyboard short cut for inserting a row in Excel , deleting a row

Reply to this Message

psimon@snet.net - 11 Mar 2005 16:24 GMT

For Ctrl + + to automatically insert a row, you have to do the extra
step of highlighting the whole row first. If you don't, you'll get a
dialog box requiring you to make a choice and then either hit Enter or
click OK. To me, that's not really a shortcut.

The speed key sequence Alt+I,R to me is much quicker and simpler -
you don't have to highlight the row first and you don't have to deal
with a dialog box. (By the way, Alt+I,C will automatically insert a
column.)

Reply to this Message