MS Excel
How can I format my data in the worksheet in Excel? Is there a way to apply the same formatting to all worksheets in the workbook? How do I do this? Is it possible to eliminate certain sheets when I do this?Are there quick styles available in Excel like in MS word?
- 553 views
- 1 answers
- 0 votes
| How do Macros help to make my work easier in Excel? Is it possible to hide the Macro that I am using so that others do not see it? Why do I see a prompt which reads "Enable or Disable a Macro" sometime on my workbook when I am working with macros? |
- 527 views
- 1 answers
- 0 votes
| I am working with a large amount of data on individual worksheets and I understand that the Freeze panes Option will help me to keep a section visible while scrolling through the rest. Is this correct? How do I Freeze panes? How would I revert this functionality later? Is there any risk of losing data? |
- 550 views
- 1 answers
- 0 votes
| How Can I link two sheets so that the value obtained in Sheet 1 is carried over to another sheet. Explain the steps to achieve this linking. What if I need a row of values to be carried over to another sheet? Do I need to use the same process to get this done? |
- 646 views
- 1 answers
- 0 votes
| What is the difference between a function and a formula in MS Excel? Do they help in performing similar tasks?Where do I find the functions available in Office 2007? What is the usage of the COUNT function? How is it different from the COUNT IF function? |
- 627 views
- 1 answers
- 0 votes
| How can I copy a worksheet in Excel into another worksheet in the same workbook? I have a set of data typed in a worksheet and would like to copy the entire content into another worksheet. Copy /Paste would just kill the formatting so, I would rather copy the entire worksheet instead. |
- 639 views
- 2 answers
- 0 votes
| I would like to edit multiple worksheets in MS Excel at the same time. My job requires that I insert values into multiple worksheets or delete a set of values from each one of them. Can I group worksheets together and edit them simultaneously? How is this done? Once I have finished editing, how can I then Ungroup the worksheets? |
- 825 views
- 1 answers
- 0 votes
I am into creating voluminous reports on Excel and hence would need up to 10 worksheets on an average in a workbook. However, Excel by default provides only 3 worksheets. I would like to know if this number can be changed so that I get 10 worksheets by default in a new workbook.How can i I change this?
- 624 views
- 1 answers
- 0 votes
What is conditional formatting in Excel? What is this feature used for? Where in the menu can I find the option to set up Conditional Formatting. I would like to highlight alternate rows in a worksheet. Can I do this with the help of conditional formatting? What is the formula I need to set for this?
- 590 views
- 1 answers
- 0 votes
How can you check whether a Pivot Table is modified or not? How can I prevent a loss in the format of my Pivot tables? How can I turn off the auto Format option? Where can I find the options for this? How can I turn off the automatic sorting feature in Pivot tables?
- 627 views
- 1 answers
- 0 votes
Latest Articles
How To Choose The Right Linux VPS For Your Needs
Benefits Of Storing And Sharing Documents In The Cloud
From Lost To Found: Restore Your Data On Windows 11
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
10 Facts About The Dark Web
Top 10 Latest Steam Cleaner Machines
Latest Tips
Top 10 Internet Monitoring Software
Top 10 Best Partition Manager Software
