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”.»
Forwarded from M.S. Office, Excel, PowerPoint, Word
Question: - What is Paste in Excel?
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Shortcut key to do following functions in Excel.
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Forwarded from M.S. Office, Excel, PowerPoint, Word
Question: - What is “Paste Special in Excel?
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
➡️Question: -
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
M.S. Office, Excel, PowerPoint, Word pinned «Question: - What is Paste in Excel? Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.»
Dear Friends,
Please share your valuable suggestions and share this channel with your friends.
Thank you
Please share your valuable suggestions and share this channel with your friends.
Thank you
Dear Friends,
Please like and subscribe my youtube channel so that I can come up with more videos.
Thank you
https://youtu.be/ajXVo6MM258
Please like and subscribe my youtube channel so that I can come up with more videos.
Thank you
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:…
⭕️⭕️⭕️In continuation of topics going on, now we are coming with a new topic which is called “Lookup”.
This will help you in a situation where you want to find the data based on some lookup value. let us go through the syntax of ‘Lookup’: -
➡️➡️Syntax
=LOOKUP (lookup value, Array)
This will help you in a situation where you want to find the data based on some lookup value. let us go through the syntax of ‘Lookup’: -
➡️➡️Syntax
=LOOKUP (lookup value, Array)
☝️🟢Step 1: -
Click on Cell ‘H7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
Click on Cell ‘H7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.