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
:: Moving Syllabus    PreviousNext


If you want to move a cell or a range, you can use various methods:

METHOD 1


Select the range you want to move, I’ve chosen a range consisting of just one cell ‘D5’. Move the cursor to the cell and when it changes from a cross to an arrow you can drag the range to the desired location:

Note that after the move the formula is still the same:

=C3 + D3

Click the Button to Play >

 

METHOD 2

Alternatively you can 'cut and paste':

  • Select the range you want to move

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

  • Select the destination cell (left click)

  • Right click to get the submenu again and left clck on the 'Paste Option' icon

 

Roll your mouse over the image to see the paste operation.

 

 

 

Notice that whenever you move something the formulae, and hence the values, do not change. You can always move things around freely to get your spreadsheet looking the way you want it.

 


 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy