Select the cell you want, then go ahead and select cells moving downward or across before activating the insert function. Note also that you can use Control+Plus and Control+Minus to hit the insert and delete functions too.
> -----Original Message----- > From: Jfw [mailto:[email protected]] On Behalf Of Greg > Nickel via Jfw > Sent: Friday, November 07, 2014 12:52 PM > To: [email protected] > Subject: Inserting in Excel. > > Hi all. > > > > I'm working in Excel 2010 and wonder if any of you can advise on how to > insert columns and rows more efficiently. > > > > I want to insert multiple rowes at once rather than one at a time as > I'm doing it now. In a worksheet I shiftF10 then arrow down to insert > then to entire row or entire column. This inserts an entire row or > column but only one at a time. > > > > Any advice on how to select the number of rows or columns you want to > insert and do it with one action? > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the- > jdh.com/attachments/20141107/79f5b54c/attachment.html> > _______________________________________________ > Jfw mailing list > [email protected] > http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
