School Data Tutorials
Tutorials
  • Home
  • New to Excel? Start here!  
    • Basic navigation and hot keys
    • Select rows and columns
    • Freeze panes
  • Formatting  
    • Page setup and set print area
    • Format cells
    • AutoFormat
    • Format rows and columns
    • Conditional formatting
  • Working with data  
    • Sort
    • Paste special
    • Filter
  • Entering data  
    • AutoFill
    • Custom fill
    • Data validation
  • Charts, formulas, pivot tables  
    • Charts and graphs
    • Formulas and functions
    • Trace cell references
    • Protection
    • Pivot tables and charts
  • Linking, importing data  
    • Link Excel to other programs
    • Import data into Excel
  • Data collection templates
Other Stuff
  • Help!
  • About this site
  • About CASTLE
  • Acknowledgments
  • Contact us
  • Login (for CASTLE staff only)
Powered by Squarespace

Paste special

[6 minutes total]

These three tutorials show how to use special copying and pasting techniques in Excel. The Paste Special function in Excel can be used to quickly link areas in your worksheets together, or to do other useful things like transpose (i.e., switch) the column-row orientation of data.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

  • Copying with Paste Link (3:51)
  • Copying and transposing data (1:47)
  • Adding (subtracting, multiplying, dividing) numbers and pasting numbers (values, formats, comments) with Paste Special (1:25)

You may need to turn off your browser's pop-up blocker or install the latest Flash plug-in to view these tutorials.

Creative Commons License
This work is licensed under a Creative Commons License.