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
Some shortcut keys of MS Excel
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
⭕️In continuation of last topic of “Paste Special”. Let us discuss Seventh Option “Formulas and number formats”.
♦️♦️This will help in a situation where you want to copy formula and number format from previous data to new data. 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 “Formulas and number formats” 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 “Formulas and number formats” option and Press “OK”, other options should not be changed.
M.S. Office, Excel, PowerPoint, Word pinned «⭕️In continuation of last topic of “Paste Special”. Let us discuss Seventh Option “Formulas and number formats”.»
Revision
Some shortcut keys of MS Excel
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
Some shortcut keys of MS Excel
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
⭕️In continuation of last topic of “Paste Special”. Let us discuss Eight Option “Values and number formats”.
♦️♦️This will help in a situation where you want to copy Values and Number Format from previous data to new data where already background formatting available or you do not need any background formatting. 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 “Values and number formats” 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 “Values and number formats” option and Press “OK”, other options should not be changed.
M.S. Office, Excel, PowerPoint, Word pinned «⭕️In continuation of last topic of “Paste Special”. Let us discuss Eight Option “Values and number formats”.»