Paste Special in Excel - Step by Step Tutorials with Shortcuts

Опубликовано: 15 Октябрь 2024
на канале: WallStreetMojo
388
3

In this tutorial on Paste Special in Excel, here we discuss how to use the different its different options along with examples.

What is Paste Special in Excel?
Paste special in excel means when we want to paste only some aspects of the data rather than the original data we use this option, there are various methods to paste special in excel and they are by right click on the target cell and select paste special or by keyboard shortcut as CTRL + ALT + V or we can press ALT + E + S, to use the aspects we can use the Excel shortcut of paste values we can press ALT + E + S + V for values only.

How to Use 𝐏𝐚𝐬𝐭𝐞 𝐒𝐩𝐞𝐜𝐢𝐚𝐥?

There are different methods to paste special in excel when we want to paste only certain aspects of the data rather than the original data then we use this option.

𝐓𝐨𝐩 𝟏𝟎 𝐏𝐚𝐬𝐭𝐞 𝐒𝐩𝐞𝐜𝐢𝐚𝐥 𝐒𝐡𝐨𝐫𝐭𝐜𝐮𝐭𝐬
---------------------------------------------------------

Below are some of the shortcuts that are going to save your time.

#1 – Paste as Values (ALT + E + S + V)
#2 – Paste as Formulas (ALT + E + S + F)
#3 – Paste as Format (ALT + E + S + T)
#4 – Paste as Comment (ALT + E + S + C)
#5 – Paste as Validation (ALT + E + S + N)
#6 – Second Part of the Validation Tab
#7 – Paste as Add (ALT + E + S + D)
#8 – Paste as Subtract (ALT + E + S + D)
#9 – Paste as Multiply (ALT + E + S + M)
#10 – Paste as Divide (ALT + E + S + I)

To know more about 𝐏𝐚𝐬𝐭𝐞 𝐒𝐩𝐞𝐜𝐢𝐚𝐥 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- https://www.wallstreetmojo.com/paste-...

Connect with us!
LinkedIn ►   / mycompany  
Facebook ►   / wallstreetmojo  
Instagram ► https://www.instagram.com/wallstreetm...
Twitter ►   / wallstreetmojo  
Youtube ►    / @wallstreetmojo