To highlight a cell or row in Excel, we will be using Conditional Formatting. The Conditional Formatting feature easily spots, trends and patterns in your data using bars, colors, and Icons to ...

Excel’s new “Show Details” checkbox is a fantastic option for interacting with and visualizing your data. By seamlessly integrating this feature with advanced formulas, you can effortlessly display ...

Do you like menus? Menus tend to be overlooked in the desire to show every possible option at once in a toolbar or palette, but the nice thing about a menu is that its there when you need it and out ...

How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are ...

In many cases, you want people to enter a valid date, and no other type of information, when they're putting data into a cell in Microsoft Excel. For example, you might be asking people to record days ...

Are all or some menu options greyed out in Excel for you? Some Office users have reported that certain or many menus are grayed out in their Excel sheets. Whenever they try to click on such menus, the ...

One of the things I don’t like about Excel 2008 is that setting zoom levels is a bit more complex than it need be. If you use Excel’s View -> Zoom menu, this opens a new window, from which you then ...