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.

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

Premium Project Management Templates

120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

PREMIUM TEMPLATES
LIMITED TIME OFFER
ON SALE80% OFF
BROWSE ALL TEMPLATES

Advanced Project Planning Templates

Excel Templates

VIEW DETAILS

120+ Project Management Templates Pack

Excel | PowerPoint | Word

VIEW DETAILS

ULTIMATE RESOURCE MANAGEMENT TEMPLATE

Excel Template

VIEW DETAILS

50+ Essential Project Management Templates

Excel | PowerPoint | Word

VIEW DETAILS

Project Portfolio Management Templates

Excel | PowerPoint Templates

VIEW DETAILS

50+ Excel Project Management Templates

Excel Templates

VIEW DETAILS

By Published On: March 8th, 2013Categories: ExcelTags:

Share This Story, Choose Your Platform!

About the Author: Valli

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.