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
*Question of the day*
Question: - Which function we can use to find out the 2nd position from the bottom?
Question: - Which function we can use to find out the 2nd position from the bottom?
Anonymous Quiz
17%
Max
29%
Min
44%
Small
10%
Large
*Question of the day*
Question: - VLOOKUP help to extracts the data from which side of table?
Question: - VLOOKUP help to extracts the data from which side of table?
Anonymous Quiz
39%
Left side
36%
Right side
18%
Top side
8%
Bottom side
Some shortcut keys of MS Excel
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
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
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.
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
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: -
➡️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.
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
▶️Step 2: - Use Copy or Cut command on the Cell or range of cells by using below shortcut keys
🟢Ctrl + C: - Copy
🟢Ctrl + X: - Cut
🟢Ctrl + C: - Copy
🟢Ctrl + X: - Cut
Step 3: - Use any of below Shortcut key to show “Paste Special” window on screen: -
🔵Ctrl + Alt + V
🔵Alt + E + S
🔵Ctrl + Alt + V
🔵Alt + E + S
➡️Step 4: - Select “Formulas” option and Press “OK”, other options should not be changed.
For Video trial please click on below link: -
🎥🎥https://youtu.be/OZLgTeTacBk
🎥🎥https://youtu.be/OZLgTeTacBk
Dear Friends,
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
👆In continuation of last topic of “Paste Special”. Let us discuss Second option “Values”.