🎥🎥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”.
⏯⏯⏯⭕️This will help in a situation where you want to copy the complete data with formulas and formatting and paste to other location in same manner only without borders. 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
🔻 Alt + H + V + S
🟣Step 3: - Select “All except borders” 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
🔻 Alt + H + V + S
🟣Step 3: - Select “All except borders” option and Press “OK”, other options should not be changed.
🎥🎥For Video trial please click on below link: -
English: - https://youtu.be/uc2vimwyd0M
English: - https://youtu.be/uc2vimwyd0M
YouTube
Paste Special option 'All except borders' English
Use of “All except borders” option in Paste Special Command.
In continuation of last topic of “Paste Special”. Let us discuss Fifth Option “All except borders”.
This will help in a situation where you want to copy the complete data with formulas and formatting…
In continuation of last topic of “Paste Special”. Let us discuss Fifth Option “All except borders”.
This will help in a situation where you want to copy the complete data with formulas and formatting…
🎥🎥For Video trial please click on below link: -
Hindi: - https://youtu.be/rHBPaTgmlog
Hindi: - https://youtu.be/rHBPaTgmlog
YouTube
Paste Special option 'All except borders' Hindi
Use of “All except borders” option in Paste Special Command.
In continuation of last topic of “Paste Special”. Let us discuss Fifth Option “All except borders”.
This will help in a situation where you want to copy the complete data with formulas and formatting…
In continuation of last topic of “Paste Special”. Let us discuss Fifth Option “All except borders”.
This will help in a situation where you want to copy the complete data with formulas and formatting…
M.S. Office, Excel, PowerPoint, Word pinned «🎥🎥For Video trial please click on below link: - Hindi: - https://youtu.be/rHBPaTgmlog»
⭕️In continuation of last topic of “Paste Special”. Let us discuss Sixth Option “Column Widths”.
♦️♦️This will help in a situation where you want to make similar width of every column. Please use below steps: -
🔵Step 1: - Use Copy command at Column D by using below shortcut keys: -
🔹Ctrl + C: - Copy
🟣Step 2: - Come to range from Column E to Column I and Use any of below Shortcut key to show “Paste Special” window on screen: -
🔺 Ctrl + Alt + V
🔻 Alt + E + S
🔻 Alt + H + V + S
🟢Step 3: - Select “Column Widths” option and Press “OK”, other options should not be changed.
🔹Ctrl + C: - Copy
🟣Step 2: - Come to range from Column E to Column I and Use any of below Shortcut key to show “Paste Special” window on screen: -
🔺 Ctrl + Alt + V
🔻 Alt + E + S
🔻 Alt + H + V + S
🟢Step 3: - Select “Column Widths” option and Press “OK”, other options should not be changed.