Paste Options in Ms Excel



You are here : Home / MS Excel tutorials for beginner to experts

By Shivani Garg


MS Excel Paste and Paste Special commands gives a lot of useful options. You can use them to paste anything be it is to paste values, paste data, paste formatting, transposing data and many more.
The following examples illustrates the various paste options in MS Excel. 

How to Paste values

>> Select the range, Right click, click Copy (or press CTRL + c). CTRL + c is shortcut key for copy
>> Select the cell where you want the first cell of the range to appear, Right click
>> Click Paste under 'Paste Options:' (or press CTRL + v).**CTRL + v is shortcut key for paste

How to Paste Sum Formula

>> Select cell B7, right click, click Copy.
>> Now, select cell D7, right click, click paste special and select formula.
You can check the Result by filling in range from D2 to D6.

How to paste Formatting

>> Select the cell or range from where you want to copy the formatting, right click, and then click Copy.
>> Select the cell or range where you want to paste the formatting.
>> Right click the range or cell, and then click Formatting under 'Paste Special'
Result will be

How to paste comments

>> Select the cell from where you want to copy the comments, right click, and then click Copy.
>> Select the cell where you want to paste the comments.
>> Right click cell, and then click comments under 'Paste Special'
Result will be
You can use any of the paste special options.
Like 
  • All using source theme
  • All except borders
  • Column widths
  • Formulas and number formula 
And so on..

Related >>

  1. Range in MS Excel
  2. Fibonacci Sequence in MS Excel
  3. Transpose in MS Excel
  4. Hide Columns or Rows in MS Excel
  5. Skip Blanks in MS Excel
  6. Comments in MS Excel
  7. Formulas and Functions in MS Excel
  8. Percent Change in MS Excel
  9. Paste Options in Ms Excel
  10. Status Bar in MS Excel
  11. Ribbon in MS Excel
  12. Templates in MS Excel
  13. Find & Select in MS Excel
  14. Data validation in MS Excel
  15. Print in MS Excel
  16. Share MS Excel Data in Word Documents
  17. Share MS Excel Workbook with Multiple Users
  18. Magical keyboard shortcuts in MS Excel with examples
  19. Very Important  Keyboard Shortcuts in MS Excel
  20. Freeze Panes in MS Excel
  21. Split Workbook in MS Excel
  22. Spell Check in MS Excel
  23. Protect Worksheet in MS Excel
  24. Protect Workbook in MS Excel
  25. Lock Cells in MS Excel
  26. Read Only Workbook in MS Excel
  27. Mark Workbook as Final in MS Excel
  28. Drop Down List in MS Excel
  29. Setting Budget Limit in MS Excel
  30. Prevent Duplication in MS Excel
  31. Count Function in MS Excel     
  32. Sum Function in MS Excel
  33. COUNTIF Function In MS Excel
  34. Count Characters in MS Excel
  35. Running Total (Cumulative Sum) in MS Excel
  36. SUMIF Function In MS Excel
  37. Logical Functions in MS Excel
  38. IF Function in MS Excel
  39. Cell References in MS Excel
  40. Create Hourly Pay Sheet using Absolute Reference in MS Excel
  41. Copy Exact Formula in MS Excel

eEdit
Must read for you :