Shortcut Key or Macro for (Insert -> Entire Row)

A

akumaxyz

Is there a shortcut key or macro I could do that would automatically
insert a new row? I'm getting tired of Right Click -> Insert -> Entire
Row...
 
R

Ron Coderre

Press these keys in succession:
[alt] I R

That's the [alt] key (which activates the menu)
then the letter I (which is the underlined letter in Insert)
then the letter R (which is the underlined letter in Row_

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
R

Ron de Bruin

You can also use

Ctrl +

+ on the numeric keyboard
If you select the row or row headers you not see the insert dialog
--
Regards Ron de Bruin
http://www.rondebruin.nl



Ron Coderre said:
Press these keys in succession:
[alt] I R

That's the [alt] key (which activates the menu)
then the letter I (which is the underlined letter in Insert)
then the letter R (which is the underlined letter in Row_

Does that help?
***********
Regards,
Ron

XL2002, WinXP


[email protected] said:
Is there a shortcut key or macro I could do that would automatically
insert a new row? I'm getting tired of Right Click -> Insert -> Entire
Row...
Click to expand...
Click to expand...
 
G

Gord Dibben

You can also drag the Insert Rows Icon up to your toolbar.

Tools>Customize>Commands>Insert

Note also the Insert Columns and the delete rows and columns icons.


Gord Dibben MS Excel MVP
 
N

Niek Otten

<Note also the Insert Columns and the delete rows and columns icons>

As for many icons, the functions are reversed when you press and hold them and then press SHIFT; Insert becomes Delete, Increase
Decimals becomes Decrease Decimals, Zoom In Zoom Out, Group Ungroup, etc
This can save a lot of space on your toolbars

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gord Dibben" <gorddibbATshawDOTca> wrote in message | You can also drag the Insert Rows Icon up to your toolbar.
|
| Tools>Customize>Commands>Insert
|
| Note also the Insert Columns and the delete rows and columns icons.
|
|
| Gord Dibben MS Excel MVP
|
| On Thu, 21 Sep 2006 21:57:11 +0200, "Ron de Bruin" <[email protected]>
| wrote:
|
| >You can also use
| >
| >Ctrl +
| >
| >+ on the numeric keyboard
| >If you select the row or row headers you not see the insert dialog
|
 
G

Gord Dibben

Good point Niek

Something I often forget.

Thanks, Gord

<Note also the Insert Columns and the delete rows and columns icons>

As for many icons, the functions are reversed when you press and hold them and then press SHIFT; Insert becomes Delete, Increase
Decimals becomes Decrease Decimals, Zoom In Zoom Out, Group Ungroup, etc
This can save a lot of space on your toolbars
Click to expand...

Gord Dibben MS Excel MVP
 
Top