How to switch to Excel full screen mode

How to switch to Excel full screen mode

Excel’s toolbar and Ribbon contain many features and shortcut icons that are aimed for improving productivity. On the other hand, these icons actually take a lot of space in your screen. Thus, your work space becomes a bit more limited. A full screen, or...
How to Make Excel Show Formula Bar or Hide It

How to Make Excel Show Formula Bar or Hide It

By default, the formula bar is visible in Excel to allow you to see and enter formulas in the active cell. However, you may want to hide the formula bar either to limit user interaction with it, or to give your Excel workbook a compact look and feel. Alternatively,...
Color coded parentheses in Excel for easier formula creation

Color coded parentheses in Excel for easier formula creation

It is very easy to lose track when creating complex formulas in Excel. Since functions use parenthesis to wrap their arguments, you may end up in a position that you do not know which parenthesis belongs to which function. In this kind of situations, you need to pay...
How to how to debug an Excel formula using the F9 key

How to how to debug an Excel formula using the F9 key

Debugging formulas in Excel can be intimidating. The process becomes harder if you are trying to calculate and also remember the values of each part of the formula. Fortunately, the F9 key is an easy and quick way to break a formula down into pieces. The F9 key...
Relative Named Range in Excel

Relative Named Range in Excel

Excel uses absolute references for named ranges by default. While absolute references can cover most scenarios, relative references in named ranges work as relative references do in formulas. This behavior can be useful in some scenarios, but can be a bit tricky! In...
How to Make Excel Change Scope of Named Range

How to Make Excel Change Scope of Named Range

Named ranges have a property named “scope”. Usually, you do not need to adjust this property to use named ranges in Excel. On the other hand, it can become very useful if you have a number of sheets that are identical. The scope concept allows you to use...
How to apply named ranges to existing formulas in Excel

How to apply named ranges to existing formulas in Excel

The use of named ranges is a very powerful tool for creating references in Excel. In addition to making formulas easier to read, you don’t have to remember the exact cell and range references when writing formulas. If you have already been using named ranges,...