• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » Copy & Paste in Excel 2010
Next →
← Prev

Copy & Paste in Excel 2010

By Dinesh Thakur

MS Excel offers the ability to copy paste in various ways. The best way to copy the paste is as follows.

Copy or Paste

To duplicate a range of cells to another position within the same sheet, without using the clipboard, follow the steps below:      

  • To copy and paste, just select the cells you want to copy. Choose a copy option after right clicking or press Control + C.
  • Select the cell where you need to paste the copied content. Right-click and select the paste option or press Control + V.

Cell Copy PasteMS Excel will copy everything in this situation, including values, formulas, Formats, Comments, and validation. With paste, MS Excel will overwrite the content. To reverse this action, click Control + Z on your keyboard.

We’ll be covering the following topics in this tutorial:

  • Copy Paste using Office Clipboard  
  • Copy Paste in Special way

Copy Paste using Office Clipboard  

The operation of copy duplicates a cell or range of cells to another position. When we use the clipboard, Copy and Paste operations come into play. The operation of Copy it will duplicate the selected cells to the Windows clipboard and Paste copies the information from the clipboard to where we are located.

Clipboard ContentWhen you copy data in MS Excel, the copied material is saved in both the Windows and Office Clipboards. By going to Home >> Clipboard, you can see what’s on your clipboard. To View the clipboard content. Choose the cell where you want to paste the information. To paste the content, click paste.

Copy Paste in Special way

Sometimes we can interesting copy the value of a cell without take us the formula, or copy the formula but not the format or appearance of the cell, that is, choose the elements of the range to copy. This possibility is provided by the Special glue.

To use this possibility:

Copy the cells, and then, instead of pressing the button Paste of the tab start, click on the little arrow below it. A menu with more options to paste will be displayed. You will have to choose paste special….

Paste Special DialogueAs shown below, select the paste special option.

The numerous options available in paste special are listed below.

  • All: Pastes the contents, formats, and data validation of the cell from the Windows Clipboard into the cell.
  • Formulas: This feature pastes formulas but not formatting.
  • Values: Only pastes values, not formulas.
  • Formats: Pastes only the source range’s formatting.
  • Comments: Copies and pastes the comments into the appropriate cells.
  • Validation: Pastes in the validation that has been applied to the cells.
  • All using source theme: Formulas and all formatting are pasted.
  • All except borders: Pastes everything in the source range except the borders.
  • Column Width: Pastes formulas and duplicates the copied cells’ column width.
  • Formulas and Number Formats: This option only pastes formulas and number formatting.
  • Values & Number Formats: Pastes formula results along with the number.
  • Merge Conditional Formatting: This icon appears only when conditional formatting is present in the copied cells. It merges the copied conditional formatting with any conditional formatting in the destination range when you select it.
  • Transpose: Changes the copied range’s orientation. Columns become rows, and rows become columns. All formulas in the copied set are rewritten to function correctly when transposed.

You’ll also like:

  1. Insert, Copy, Hiding, Delete Worksheet in Excel 2010
  2. Working with Excel 2010
  3. Excel 2010 Components
  4. BackStage View in Excel 2010
  5. Managing Data in Excel in 2010
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2025. All Rights Reserved.

APPLY FOR ONLINE JOB IN BIGGEST CRYPTO COMPANIES
APPLY NOW