⭕️⭕️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: -
⏯Step 1: - Use Copy command on the range (Column H and Column I) of cells by using below shortcut keys: -
Ctrl + C: - Copy
⏯Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
⏯Step 3: - Select “Formats” option and Press “OK”, other options should not be changed.
Ctrl + C: - Copy
⏯Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
⏯Step 3: - Select “Formats” option and Press “OK”, other options should not be changed.
🎥🎥For Video trial please click on below link: -
https://youtu.be/BXyGREk6ICk
https://youtu.be/BXyGREk6ICk
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
M.S. Office, Excel, PowerPoint, Word pinned «🎥🎥For Video trial please click on below link: - https://youtu.be/BXyGREk6ICk»
⭕️⭕️⏯In continuation of last topic of “Paste Special”. Let us discuss Fourth option “All using Source theme”.
⏯⏯⏯This will help in a situation where you want to copy the table with data, formulas and formatting and paste to other location in same manner as it was available in earlier location. Please use below steps: -
▶️Step 1: - Use Copy command on the range (Column B and Column I) of cells by using below shortcut keys: -
Ctrl + C: - Copy
▶️Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
▶️Step 3: - Select “All using Source theme” option and Press “OK”, other options should not be changed.
Ctrl + C: - Copy
▶️Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
▶️Step 3: - Select “All using Source theme” option and Press “OK”, other options should not be changed.
🎥🎥For Video trial please click on below link: -
English: - https://youtu.be/3cjNPK68R7A
English: - https://youtu.be/3cjNPK68R7A
🎥🎥For Video trial please click on below link: -
Hindi: - https://youtu.be/jHTrhX3vJ4o
Hindi: - https://youtu.be/jHTrhX3vJ4o
M.S. Office, Excel, PowerPoint, Word pinned «🎥🎥For Video trial please click on below link: - Hindi: - https://youtu.be/jHTrhX3vJ4o»
M.S. Office, Excel, PowerPoint, Word
🎥🎥For Video trial please click on below link: - Hindi: - https://youtu.be/jHTrhX3vJ4o
Dear Friends,
Please share your valuable suggestions and share this channel with your friends and please subscribe to my YouTube channel for upcoming videos.
This will help me to get motivated to share the this free content with you.
Thank you
Please share your valuable suggestions and share this channel with your friends and please subscribe to my YouTube channel for upcoming videos.
This will help me to get motivated to share the this free content with you.
Thank you
In continuation of last topic of “Paste Special”. Let us discuss Fifth Option “All except borders”.