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’.
✌️🔵Step 2: - After Typing ‘Lookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
Dear Friends,
Please share this channel with your friends and family members. Please also like and subscribe my youtube channel so that I can come up with new videos of Excel.
Thank you
Please share this channel with your friends and family members. Please also like and subscribe my youtube channel so that I can come up with new videos of Excel.
Thank you
Please rate the content provided in the group, is it understandable to you.
Final Results
27%
1
18%
2
29%
3
12%
4
45%
5
M.S. Office, Excel, PowerPoint, Word pinned «⭕️⭕️⭕️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…»
⭕️⭕️⭕️After discussion on “Lookup” first condition in which the lookup value is same as mentioned in the Table Array, let us discuss the second condition if the lookup value is different and not in the Table Array, then how lookup function will work.
➡️➡️SSyntax
=LOOKUP (lookup value, Array)
➡️➡️SSyntax
=LOOKUP (lookup value, Array)
☝️🟢Step 1: -
Click on Cell ‘K7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
Click on Cell ‘K7’ and press ‘=’ this will activate to cell to use function, and start typing ‘Lookup’.
✌️🔵Step 2: - After Typing ‘Lookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.