SITEMAP ABOUT
MiC Quality

FREE COURSE Excel Primer

  PROCESS IMPROVEMENT AND SIX SIGMA
ONLINE COURSES FREE TRIAL SIX SIGMA FAQ BROCHURES LICENSES ENROLL
FREE TRIAL
:: Online Courses
:: Free Trial
>> Statistics Module
>> Excel Primer
:: Six Sigma
:: FAQ
:: Brochures
:: Licenses
:: Discounts
 
Welcome to MiC Quality
Online Course Instructor
Glen Netherwood
MiC Quality
Online Learning
:: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: Copying Syllabus    PreviousNext


In most software, such as Word, the only difference between 'copying' and 'moving' is that when you move something the original is deleted. When copying the original remains. In Excel there is a significant difference.

The mechanics of copying are similar to those for moving, except that if you use the drag and drop method you must hold the ‘Ctrl’ key down throughout the copy operation

The difference is that when you 'move' the addresses in the formula change so that they are at the same relative position. The example below illustrates this:

METHOD 1

Run the flash animation to compare it to the 'Move'.

It is identical until the very end when the formula in the cell 'D9' is '=C7 + D7' rather than '=C3 + D3'.

The original formula, in Cell D5, has not changed.

If this is not clear now, then the next couple of pages should help.


Click the Button to Play >

 

METHOD 2

Alternatively you can use the 'right click option'':

  • Select the range you want to copy.

  • Right click to get the submenu and select ‘Copy’

  • Select the destination cell (left click)

  • Right click to get the submenu again. You now have a number of Paste Options that weren't available with the 'Cut':


For a simple copy select the icon on the left (the clipboard). I'll discuss some of the others shortly.

 

Roll your mouse over the image to see the 'Paste Options".


 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy