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
:: Paste Special Syllabus    PreviousNext


You can already use the right click menu to copy a range of cells.

I'd like to point out a couple of other important ‘Copy' and 'Paste' options'.

Right click on the top left cell of the range you want to copy.

Right click on the top left cell of where you want to paste it.

You then see a context sensitive row of 'Paste Options'.

You only see the options that are available:

Select the one you want and left click.

 

 

paste: includes both the cell contents and any cell format (color, alignment etc.)
value: converts a formula to its numerical value 
formula: copies the cell contents (formula) only, not the cell formats
transpose: the rows will become columns and vice versa
format: copies the cell formats only, not the contents
link: pastes a link from another worksheet

Notice that a drop down box remains after the paste, so you have the opportunity to change to a different option.


 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy