 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Shortcut Key or Macro for (Insert -> Entire Row)
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... 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 > 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... You can also use Ctrl + + on the numeric keyboard If you select the row or row headers you not see the insert dialog  SignatureRegards Ron de Bruin http://www.rondebruin.nl > Press these keys in succession: > [alt] I R [quoted text clipped - 13 lines] >> insert a new row? I'm getting tired of Right Click -> Insert -> Entire >> Row... 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 >You can also use > >Ctrl + > >+ on the numeric keyboard >If you select the row or row headers you not see the insert dialog <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 SignatureKind regards, Niek Otten Microsoft MVP - Excel | You can also drag the Insert Rows Icon up to your toolbar. | [quoted text clipped - 10 lines] | >+ on the numeric keyboard | >If you select the row or row headers you not see the insert dialog 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 Gord Dibben MS Excel MVP 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@.... 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... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.