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.
Revision
Some shortcut keys of MS Excel
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
Some shortcut keys of MS Excel
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
🎥🎥For Video trial please click on below link: -
English: - https://www.youtube.com/watch?v=AxckqwZ4cWY
English: - https://www.youtube.com/watch?v=AxckqwZ4cWY
YouTube
Paste Special option 'Column Widths' English
Use of “Column Widths” option in Paste Special Command.
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:…
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:…
🎥🎥For Video trial please click on below link: -
Hindi : -https://youtu.be/ajXVo6MM258
Hindi : -https://youtu.be/ajXVo6MM258
YouTube
Paste Special option 'Column Widths' Hindi
Use of “Column Widths” option in Paste Special Command.
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:…
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:…
Revision
Some shortcut keys of MS Excel
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional
Some shortcut keys of MS Excel
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional