15 Must Known Excel Tips for Every Excel User

Home/Excel/15 Must Known Excel Tips for Every Excel User

When we are working with some application, we use same method to finish some task. After sometimes we think for an alternative method to perform our task more faster and easy way. However, it will come with experience and take sometime to know the smarter way of doing the things.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


Excel Tips - Top 10Now, its not required years of experience in Excel to work smarter! Spending sometime on reading this chapter will make you to execute the tasks smarter way and it will improve the productive.

Excel Tips – How Tos:

1. How to Display Formulas Instead of Results in Excel Cells?

You Can Toggle The Formulas And Results By Pressing ” Ctrl-~ ” (The Second Key Stroke Is Tilda(~)).

2. How to Display the Cell Value Instead of Formulas in the Formula Bar?

You Can Highlight The Address And Press “F9” To Display The Values.

3. How to Highlight All Cells Referenced by a Formula?

You can select a Cell with Formula and Press “Ctrl-

[“, It Will Highlight All Cell Referring In That Particular Formula.

4. How to Highlight the Formulas that Reference a Cell?

You Can Select All Cells With Formulas Reference The Current Cell By Pressing “Ctrl-]”

5. How To Add Content Or Formatting To Multiple Sheets At Once?

You Can Select The Multiple Sheets Together And Add The Content Or Format The Cells
Note: Do Not Forget To Un-group The Sheets, Once You Are Done With The Grouped Activities.

6. How to See Toggle the Relative and Absolute References?

You Can Activate A Cell (By Double Clicking the Cell or Pressing F2) And Press “F4” To Toggle The Relative And Absolute References

7. How to Auto Fill the Cells?

To fill a list or series across columns or down rows type Jan in any cell and place your mouse pointer over the bottom-right corner of the cell (until the mouser pointer changes to a small black cross). Then Left click and drag down or across.
This can also be done with Numbers, Weekdays, Quarters, user-defined lists or any text that ends in a number e.g. Department 1.

8. How to Add Hidden Text to Formulas?

You can use N() formula. For example instead of “=5000+2000”, you can use “=5000+2000+2500 +N(“Oranges from Store A+Apples from Store B+ Banana From Store A”)”.
The N() function will convert any text to zero, so it helps you to put notes kind of text in your formula for future reference

9. How to Repeat the Same or Previous Operation?

You Can Press F4 To Repeat An Operation.

10. How to View All Named Ranges in Sheet?

Set zoom level of less than 40%, You can view all the named ranges.

11. How to fill the same content in a whole range?

Select the range, Enter the value and Press Ctrl+Plus+ Enter

12. How to attach active workbook to a new email?

Press Alt+F+D+E

13. How to Freeze or UnFreeze in the Sheet?

Press Alt+W+F+F

14. How to add Filter and remove Filter in the Sheet?

Press Alt+D+F+F
Note: If you want to filter for particular row, Select the particular row and then press Alt+D+F+F

15. How to Paste the Values (Paste Special Values)?

Press Alt+E+S+V

16. How to Transpose the Data (Paste Special Transpose)?

Press Alt+E+S+E

17. How to Auto Fit Rows and Columns ?

Press Alt+H+O+I

» Click Here For More Excel Shortcut Keys

LIMITED TIME OFFER
By |March 8th, 2013|Excel|4 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

4 Comments

  1. July 25, 2014 at 12:18 PM - Reply

    Would like to know how to use excel to create classroom schedule by months, interactively.
    Have tried to put in all the resources, teachers and course schedules. Did not work well.
    Please advise

    • PNRao July 25, 2014 at 11:29 PM - Reply

      Hi Linda,

      Thanks for visiting us. We are happy to help you. I understand that you need a Excel template where you will provide all your data in a worksheet and you want another worksheet where you can just change the month and the Shedule shoudl change automatically.

      Can you please provide me some sample data and course schedules design. So that I can prepare a template or tool and send it to you.
      Also, please provide me the complete requirement.

      Thanks-PNRao!

  2. Shashidhar October 26, 2015 at 9:09 PM - Reply

    Fantastic one

  3. Naomi December 7, 2015 at 1:59 PM - Reply

    Very nice – Love the N(“”) for comments in formulas! Thank you for taking time to add some great info on your site. I hope to go through as many VBA examples as you have on here as well as this is why I primarily came to your website but have stayed for the clear, concise examples and the little bits of additional information other sites don’t have. Cheers!

Leave A Comment