🤔🤔▶️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
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?
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
Dear Friends,
I hope you all are doing well!
As I am getting lots of requirements from all group members on different topics of MS Excel which I will try to fulfill one by one.
Further I would need your support on the channel, so please subscribe, like and comment. Which helps me to get motivated and help the group members.
Thank You
I hope you all are doing well!
As I am getting lots of requirements from all group members on different topics of MS Excel which I will try to fulfill one by one.
Further I would need your support on the channel, so please subscribe, like and comment. Which helps me to get motivated and help the group members.
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
*IMPORTANCE OF MS EXCEL IN OUR DAILY AND BUSINESS LIFE:*
1. Easy Arithmetic Solutions.
2. Formatting Options.
3. Charts for Analysis.
4. Bring all the data in one place.
5. Human Resource Planning.
6. Multiple formulas.
7. Multiple functions.
1. Easy Arithmetic Solutions.
2. Formatting Options.
3. Charts for Analysis.
4. Bring all the data in one place.
5. Human Resource Planning.
6. Multiple formulas.
7. Multiple functions.
Forwarded from M.S. Office, Excel, PowerPoint, Word
What is Status Bar
The status bar in Excel can be quite useful. By default, the status bar at the bottom of the window displays the average, count and sum of selected cells.
The status bar in Excel can be quite useful. By default, the status bar at the bottom of the window displays the average, count and sum of selected cells.