Microsoft Excel allows you to control the program display in various ways, including complete personalisation of the top ribbon. If you're finding the large top ribbon to be troublesome, we'll show ...

Please note: This item is from our archives and was published in 2006. It is provided for historical reference. The content may be out of date and links may no longer function. Is there a way to ...

Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel ...

You worked hard to put that Excel sheet together, now protect it from unintended damage.

Microsoft has brought new features to Excel to enhance the user experience. The new Excel features come for web users, Windows users as well as Mac users.

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

To edit an existing formula, you probably make changes in the Formula bar. Recently, I noticed several Excel students reaching for the mouse and clicking the Formula bar to edit formulas.

But why not show progress with status bars, like this: This technique was recently discussed in How-To Geek, and it's easy to do in Excel.

To transform the display from data to formulas (see screenshot below) press Ctrl+~ (tilde). Toggle back to the data view by pressing those keys again. If you wish, you can print the worksheet, with or ...