Please note: This item is from our archives and was published in 2021. It is provided for historical reference. The content may be out of date and links may no longer function. You can also use a ...

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

There's a certain kind of dread when seeing a massive block of text fill the formula bar in Microsoft Excel. When everything is crammed onto one line, your eyes skip over the mistakes that end up ...

Something wrong with some numbers in that spreadsheet? Here's a shortcut that displays all the formulas in the sheet at once: Ctrl + ` (the acute accent key, found next to the number 1 on your ...

If you want to show or hide the list of formulas while typing in an Excel spreadsheet, here is how you can do that. You can enable or disable the autocomplete of ...

Imagine being able to navigate through the complex web of data in Excel with the agility of a seasoned pro, manipulating numbers and formulas with a few simple keystrokes. Excel, a robust tool for ...

Please note, there is a new version of this article, with more up-to-date information: 13 quick time-saving Excel tips and shortcuts. The one thing marketers agree on ...

Back in 2013 John Gagnon wrote a very popular post detailing some of his favourite Excel tips and tricks. We thought we’d update the list of classic shortcuts with a few that reflect some new ...

Typing entire expressions from the keyboard is tedious. Instead, use these 9 shortcuts to enter and work with expressions more efficiently. Most of us spend a lot of time entering expressions–they’re ...

In Microsoft Excel, the Formula Bar is the toolbar at the top of the spreadsheet that lets you enter or view the information in a cell; instead of calculating a long formula in your cell, it can be ...