Home |
Search |
Today's Posts |
#1
|
|||
|
|||
whats the keyboard short cut for inserting a row in Excel
whats the keyboard short cut for inserting a row in Excel , deleting a row
|
#2
|
|||
|
|||
Hi
Ctrl + CTRL - If you select the row header you don't see the dialog -- Regards Ron de Bruin http://www.rondebruin.nl "Subin" wrote in message ... whats the keyboard short cut for inserting a row in Excel , deleting a row |
#3
|
|||
|
|||
Select the location for inserting a New Row
Press <CTRL and press +, This would insert a New ROW "Subin" wrote: whats the keyboard short cut for inserting a row in Excel , deleting a row |
#4
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut | Excel Worksheet Functions | |||
Why is pointer and keyboard control is lost in certain Excel file. | Excel Discussion (Misc queries) | |||
Using keyboard to select using excel 02 data... | Excel Worksheet Functions | |||
cut & paste with short cut keys (ctrl C V) with absolute cell refe | Excel Discussion (Misc queries) | |||
Status Bar - Key Board Short Cut | Excel Discussion (Misc queries) |