Introduction To MS Excel tutorial
Chapter 1: MS Excel Basics

Chapter 2: Editing Worksheet In Excel

Chapter 3: Formatting Cells

Chapter 4: Formatting Worksheets

Chapter 5: Working With Formulas

Chapter 6: Advanced Operations

How To Copy And Paste In MS Excel 2010

MS Excel allows user to copy paste in various different ways.

Copy Paste

• First, select the cell you want to copy. Then, choose copy option after giving a right click by simply pressing Control + C.
• Now select the cell where you want to past the copies content. Simply give a right click and select paste option or press keys Control + V.

MS Excel Tutorial

Copy Paste Using Office Clipboard

Whenever you copy data in the worksheet, the copied content is placed in Windows and Office Cupboard. Clipboard content can be viewed by going to the Home and selecting Clipboard. Now, it will view the clipboard content and select the cell the where you want to paste it by giving a click on paste.

MS Excel Tutorial

Copy Paste in Special Way

Sometimes users require to copy only values or only the formatting of the cells, then select the paste special option.

MS Excel Tutorial

Here are various options found in Paste Special.

All – It pastes the cell’s contents, data validation and formats from the Windows Clipboard.
Formulas – It pastes the formulas not formatting.
Values – It pastes the values not formulas.
Formats – It pastes only the formatting of the source range.
Comments – It pastes the comments with their respective cell.
All using source theme – It pastes formulas along with all formatting.
Validation – It pastes the validation applied in the cells.
Column width – It pastes the formulas and even duplicated the column width of the copied cells.
Values & Number Formats – It pastes the results of formulas along with numbers.
All except borders – It pastes everything in the source range except for the borders.
Formulas & Number Formats – It pastes formulas and number formatting only.
Merge Conditional Formatting – It merges the conditional formatting with any conditional formatting found in the destination range.
Transpose – It changes the orientation of the copies range. In this option, the rows become columns and vice versa.

MS Excel Tutorial

Tags

You may also like...

Sorry - Comments are closed

Australia

Unknown
Humidity: 65
Wind: 9 km/h
71 F
65 93
25 Mar 2016
63 87
26 Mar 2016

Slideshow