M.S. Office, Excel, PowerPoint, Word
36K subscribers
143 photos
44 links
Knowledge Sharing
Download Telegram
Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you
➡️➡️In continuation of last topic of “Paste Special”. Let us discuss first option “Formulas”.
🤔🤔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. Please use below steps: - 🤫🤫
▶️Step 1: - First freeze all references in your cell by using $ or simply click F4 and want to paste the Column E and Column F to Column H and Column I.
▶️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
Step 3: - Use any of below Shortcut key to show “Paste Special” window on screen: -
🔵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
Dear Friends,
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.
Dear Friends,
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
Dear Friends,

In this group will try to learn the basics of MS Excel, MS Word, and PowerPoint one by one. Right now we are working on MS Excel, once this done will discuss MS word and PowerPoint also.

I am requesting you all to please share this channel with your friends and family members.

Please also share your feedback and suggestions for further improvement. This will help me to get motivated.

Thank you
⭕️⭕️In continuation of last topic of “Paste Special”. Let us discuss Third option “Formats”.
⭕️⭕️This will help in a situation where you want to copy the formatting of one cell to other cells. Please use below steps: -