Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you
Please share your valuable suggestions and share this channel with your friends.
Thank you
Question: - What is Paste in Excel?
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Shortcut key to do following functions in Excel.
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Question: - What is “Paste Special in Excel?
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
➡️Question: -
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you
Please share your valuable suggestions and share this channel with your friends.
Thank you
▶️Step 2: - Use Copy or Cut command on the Cell or range of cells by using below shortcut keys
🟢Ctrl + C: - Copy
🟢Ctrl + X: - Cut
🟢Ctrl + C: - Copy
🟢Ctrl + X: - Cut
Step 3: - Use any of below Shortcut key to show “Paste Special” window on screen: -
🔵Ctrl + Alt + V
🔵Alt + E + S
🔵Ctrl + Alt + V
🔵Alt + E + S
➡️Step 4: - Select “Formulas” option and Press “OK”, other options should not be changed.
For Video trial please click on below link: -
🎥🎥https://youtu.be/OZLgTeTacBk
🎥🎥https://youtu.be/OZLgTeTacBk
Dear Friends,
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
👆In continuation of last topic of “Paste Special”. Let us discuss Second option “Values”.
🤔🤔▶️This will help in a situation where you want to copy or cut the cell in which a formula has used and want to take this to some other cells/ Location without formula so that if you change anything the rest of values should not change. Please use below steps: -
Step 1: - Use Copy or Cut command on the Cell or range of cells by using below shortcut keys: -
Ctrl + C: - Copy
Ctrl + X: - Cut
Step 2: - Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
Step 3: - Select “Values” option and Press “OK”, other options should not be changed.
Ctrl + C: - Copy
Ctrl + X: - Cut
Step 2: - Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
Step 3: - Select “Values” option and Press “OK”, other options should not be changed.