Remember when using the insert commands that behavior in Excel can change if you have a cell or cells on the clipboard. Instead of inserting a column you won't get the dialog box and it will just insert the data on the clipboard. This is extremely useful but can cause some interesting problems if you don't take things like the length of column you're inserting into consideration.
> -----Original Message----- > From: Jfw [mailto:[email protected]] On Behalf Of Greg > Nickel via Jfw > Sent: Friday, November 07, 2014 1:51 PM > To: 'Lisle, Ted (CHFS DMS)'; 'The Jaws for Windows support list.'; > 'Dave 'Farfar' Carlson' > Subject: RE: Inserting in Excel. > > For my purpose, I'm inserting entire columns and pushing the existing > data over. I put the focus in the block where I want the new column to > go and then control + to insert then arrow down to the entire column > selection. > -----Original Message----- > From: Jfw [mailto:[email protected]] On Behalf Of Lisle, > Ted (CHFS DMS) via Jfw > Sent: Friday, November 07, 2014 11:43 AM > To: Dave 'Farfar' Carlson; The Jaws for Windows support list. > Subject: RE: Inserting in Excel. > > At the risk of asking a dumb question, could you specify a range; are > the desired cells contiguous? > > -----Original Message----- > From: Jfw [mailto:[email protected]] On Behalf Of Dave > 'Farfar' > Carlson via Jfw > Sent: Friday, November 07, 2014 2:03 PM > To: Nicole Massey; The Jaws for Windows support list. > Subject: Re: Inserting in Excel. > > Also, don't I recall that Ctrl+Y will repeat the last action? > > Dave Carlson > Oregonian, pioneer, landlord, Farfar, musician, and woodworker > > ----- Original Message ----- > From: "Nicole Massey via Jfw" <[email protected]> > To: "'Greg Nickel'" <[email protected]>; "'The Jaws for > Windows support list.'" <[email protected]> > Sent: Friday, November 07, 2014 10:59 AM > Subject: RE: Inserting in Excel. > > > 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 > > > _______________________________________________ > 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 > > > _______________________________________________ > 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
