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.
MS 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
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.
When 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….
As 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.