Keyboard shortcuts for Paste Special options
If you want to paste only a specific aspect of the copied data like its formatting or value, you would use one of the Paste Special options. After you've copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog.
Tip: You can also click Home > Paste > Paste Special.
To pick an option, press the underlined letter for that option. For example, press the letter C to pick the Comments option.
| Pick this option | To | Keyboard shortcut |
| All | Paste all cell contents and formatting. | Press A |
| Formulas | Paste only the formulas as entered in the formula bar. | Press F |
| Values | Paste only the values (not the formulas). | Press V |
| Formats | Paste only the copied formatting. | Press T |
| Comments | Paste only comments attached to the cell. | Press C |
| Validation | Paste only the data validation settings from copied cells. | Press N |
| All using Source theme | Paste all cell contents and formatting from copied cells. | Press H |
| All except borders | Paste all cell contents without borders. | Press X |
| Column widths | Paste only column widths from copied cells. | Press W |
| Formulas and number formats | Paste only formulas and number formats from copied cells. | Press R |
| Values and number formats | Paste only the values (not formulas) and number formats from copied cells. | Press U |
No comments:
Post a Comment