EXCEL PASTE SPECIAL OPTIONS AND SHORTCUT KEYS

The video shows the useful functions of Paste Special in Excel and how to make the process faster by using keyboard shortcuts to paste the commonly used paste special elements like values, formats, subtract and transpose. There are more options to choose like paste comments, validation, all using source theme, all except borders, column widths, formulas and number formats as well as values and number formats. There are also other operations that Excel can do with the copied data like add, multiply and divide. And you have the option to skip blanks when you paste the copied cells.

All of the Paste Special commands work within the same worksheet as well as across different sheets and workbooks.

Title: Excel Paste Special Options and Shortcut Keys

#pastespecial #shortcutkeys #keyboardshortcut #exceltips