Friday, April 15, 2011

Copy/Move/Insert without cut and paste


How to do Copy/Move/Insert without Ctrl+C and Ctrl+V?

  • Select the range of cells to be copied, or moved, or inserted. 
  • Place the cursor on the heavy outline of this selected range, and the cursor changes into a 4-way arrow. 
  • Press and hold the left mouse button as you move the cursor to the location where you want to place the selected range. A gray outline around shows you the area to which the selected cells will be moved. 
  • Holding the Shift-key will move (i.e. cut and insert) the selected range without over-writing any cells in the paste location. 
  • Holding the Ctrl-key will create a copy of the selected range, leaving the original in place. 
  • Holding both Shift-key and Ctrl-key will insert a copy. 
This works on cells, rows, and columns (and sheets?) 
Try it... I think you'll like it. 

No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.