Forwarded from M.S. Office, Excel, PowerPoint, Word
➡️➡️In continuation of last topic of “Paste Special”. Let us discuss first option “Formulas”.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤔🤔This will help in a situation where you want to copy or cut the cell in which a formula has used and want to take this to some other cells. Please use below steps: - 🤫🤫
Forwarded from M.S. Office, Excel, PowerPoint, Word
▶️Step 1: - First freeze all references in your cell by using $ or simply click F4 and want to paste the Column E and Column F to Column H and Column I.
▶️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 the Second option “Values”.
🤔🤔▶️This will help in a situation where you want to copy or cut the cell in which a formula has used and want to take this to some other cells/ Location without formula so that if you change anything the rest of values should not change. Please use below steps: -
Step 1: - Use Copy or Cut command on the Cell or range of cells by using below shortcut keys: -
Ctrl + C: - Copy
Ctrl + X: - Cut
Step 2: - Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
Step 3: - Select “Values” option and Press “OK”, other options should not be changed.
Ctrl + C: - Copy
Ctrl + X: - Cut
Step 2: - Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
Step 3: - Select “Values” option and Press “OK”, other options should not be changed.
🎥🎥For Video trial please click on below link: -
https://youtu.be/evO57MP8pBc
https://youtu.be/evO57MP8pBc
YouTube
Use of “Values” option in Paste Special Command
Use of “Values” option in Paste Special Command
Free Excel Videos, Power point, MS Word, Excel, Microsoft Excel Videos Free.
"Values" option in "Paste Special" Excel Free leaning online, Paste special commands one by one free,
Excel Free Videos, Basic Excel…
Free Excel Videos, Power point, MS Word, Excel, Microsoft Excel Videos Free.
"Values" option in "Paste Special" Excel Free leaning online, Paste special commands one by one free,
Excel Free Videos, Basic Excel…
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
Hi Friends,
Please try to answer this question.
Question:-
How do you freeze panes in Excel and what do you mean by this?
Please try to answer this question.
Question:-
How do you freeze panes in Excel and what do you mean by this?
Hi Friends
Thanks for sharing your reply.
Waiting for others to share their answer.
Thanks
Thanks for sharing your reply.
Waiting for others to share their answer.
Thanks
M.S. Office, Excel, PowerPoint, Word
Hi Friends, Please try to answer this question. Question:- How do you freeze panes in Excel and what do you mean by this?
Answer:-
A feature in excel that allows you to fix rows or columns in place while moving through the rest of the data in the sheet.
1. Available in View Rab
2. Shortcut :- Alt+W+F+F
A feature in excel that allows you to fix rows or columns in place while moving through the rest of the data in the sheet.
1. Available in View Rab
2. Shortcut :- Alt+W+F+F
Hi Friends
Please try to answer this question:-
Question-
What is the difference between count, counta, and countblank?
Please try to answer this question:-
Question-
What is the difference between count, counta, and countblank?