Copy, Paste, Paste Special

1. Keyboard shortcut to copy is Ctrl+C. Else you can right click on a particular cell and select copy. Or you could select the cell and then click on the copy button.

2. The normal paste option pastes the copied data as it is. You could copy data from a single cell and paste it on a large range of cells including rows, columns etc. Keyboard shortcut for paste is Ctrl+V. Else you can right click on a cell range and select paste. Or you can select the paste button

3. The unique option in excel is the paste special option. I have created a simple table to demonstrate how paste special works. Please see the below snapshot.

4. So we have created a calculator which is working just fine. Now  you want to create another such table, But going over the entire formatting thing is a problem.Also you wouldn't want the same text as that of the previous table.
5. Now select the entire table you had created. Select Copy.

6. Select any other cell on the worksheet and right click and choose paste special. The Paste special dialog box opens, the default options in it will be 'All' in Paste and 'None' in operation. The following actions takeplace when each of the option is clicked.

a) Formulas: The colour and number formatting will not be copied, But the formula contained in cell C6 will be copied and updated to the corresponding cell index where the data is pasted.

b) Values: This option pastes only values from the range that has been copied. It will not paste any other formatting from the copied range.
c) Formats: Pastes all types of formatting from one range to another except for column and row widths.

d) Comments: Pastes only comments from one cell to another.
e) Data Validation: Copies data validation types such as drop down lists and restricted cell 
     entries. How to create a drop down list using data validation?
 f) Transpose: How to rearrange data across rows to columns?

You could try the other options in the paste special dialog box for yourself! Excel is all about exploring!