Shortcut Key or Macro for (Insert -> Entire Row) akumaxyz[ at ]gmail.com 21.09.2006 19:23:13 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...

RE: Shortcut Key or Macro for (Insert -> Entire Row) Ron Coderre 21.09.2006 19:46:57 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 "akumaxyz[ at ]gmail.com" wrote: [Quoted Text] > 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... > >

Re: Shortcut Key or Macro for (Insert -> Entire Row) "Ron de Bruin" <rondebruin[ at ]kabelfoon.nl> 21.09.2006 19:57:11 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" <ronREMOVETHIScoderre[ at ]bigfoot.com> wrote in message news:45A81C56-9C6A-4DF5-9870-D94A4F26B870[ at ]microsoft.com... [Quoted Text] > 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 > > > "akumaxyz[ at ]gmail.com" wrote: > >> 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... >> >>

Re: Shortcut Key or Macro for (Insert -> Entire Row) Gord Dibben <gorddibbATshawDOTca> 21.09.2006 20:16:01 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" <rondebruin[ at ]kabelfoon.nl> wrote: [Quoted Text] >You can also use > >Ctrl + > >+ on the numeric keyboard >If you select the row or row headers you not see the insert dialog

Re: Shortcut Key or Macro for (Insert -> Entire Row) "Niek Otten" <nicolaus[ at ]xs4all.nl> 21.09.2006 21:23:12 <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 news:ojs5h2pnned6cd8vb28lf3j89ul7vul2jo[ at ]4ax.com... | 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" <rondebruin[ at ]kabelfoon.nl> | wrote: | | >You can also use | > | >Ctrl + | > | >+ on the numeric keyboard | >If you select the row or row headers you not see the insert dialog |

Re: Shortcut Key or Macro for (Insert -> Entire Row) Gord Dibben <gorddibbATshawDOTca> 21.09.2006 23:25:25 Good point Niek Something I often forget. Thanks, Gord On Thu, 21 Sep 2006 23:23:12 +0200, "Niek Otten" <nicolaus[ at ]xs4all.nl> wrote: [Quoted Text] ><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 Gord Dibben MS Excel MVP

Re: Shortcut Key or Macro for (Insert -> Entire Row) "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> 25.09.2006 01:23:48 You might want to use a macro like you asked for, see Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm <akumaxyz[ at ].... wrote .. [Quoted Text] > 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... >