Forwarded from M.S. Office, Excel, PowerPoint, Word
⭕️⭕️Let us discuss 'Formats' option of paste special command.
Forwarded from M.S. Office, Excel, PowerPoint, Word
⭕️⭕️This will help in a situation where you want to copy the formatting of one cell to other cells. Please use below steps: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
⏯Step 1: - Use Copy command on the range (Column H 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
⏯Step 3: - Select “Formats” 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
⏯Step 3: - Select “Formats” option and Press “OK”, other options should not be changed.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
🎥🎥For Video trial please click on below link: -
https://youtu.be/BXyGREk6ICk
https://youtu.be/BXyGREk6ICk
Forwarded from M.S. Office, Excel, PowerPoint, Word
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
Good News!!!!
In the coming days I will try to share content on Vlookup and then Hlookup.
Please do practice as much as you can and ask your doubts.
Thank You
In the coming days I will try to share content on Vlookup and then Hlookup.
Please do practice as much as you can and ask your doubts.
Thank You
☝️🟢Step 1: - Click on Cell ‘J8’ and press ‘=’ this will activate the cell to use function, and start typing ‘Vlookup’.
🤟✌️🟣Step 5: - After selecting Table array please put koma (,) and the third field will reflect ‘Col_Index_Num’ which means from which column you want to find the results, Type number 2 here.
(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Price based on Product and Price is lying in second column that is why we typed 2 here)
(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Price based on Product and Price is lying in second column that is why we typed 2 here)
Dear Friends,
Please like and subscribe my youtube channel so that I can come up with Lookup and Vlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Please like and subscribe my youtube channel so that I can come up with Lookup and Vlookup videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Dear Friends,
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you