Resources

How to count if not equal to x or y in Excel

How to count if not equal to x or y in Excel

The COUNTIFS function can count the values in multiple ranges with multiple criteria. The function counts each given range-criteria pair and combines the result with AND logical operator. Unfortunately, there is no quick and easy way to use an OR logic with the...

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,...

How to hide or unhide Excel scroll bar

How to hide or unhide Excel scroll bar

As you might know, Excel displays horizontal and vertical scroll bars to allow scrolling through the horizontal and vertical areas in worksheets. Although, these are essential tools for working in a workbook; you may want to hide them to give your Excel workbook a...

How to make Excel turn off sounds

How to make Excel turn off sounds

Sound feedback in computer software is intended to increase productivity and warn users when necessary. However, some might find these warnings unnecessary and unhelpful. Excel gives you a "ding" whenever you do something wrong, and inevitably add to your frustration....