Excel Paste Special Options and Keyboard Shortcuts

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.

The keyboard shortcut to copy and paste is as simple as Ctrl+C and Ctrl+V. But if you don’t want to paste the whole cell, paste special comes to help you. With this, you can choose only certain attributes to be copied and this video will guide you with the process. You will also learn the shortcut keys of selected paste special elements.

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 Keyboard Shortcuts

#pastespecial
#pastespecialexcelfunction
#pastespecialkeyboardshortcuts
#commonlyusedpastespecialelements
#pastevalue
#pasteformat
#pastesubtract
#transposedatainexcel
#pastespecialcommands