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

You may not realize it, but clicking around an Excel spreadsheet with your mouse is wasting time—your precious time. There are hundreds of Excel shortcuts that you can use to complete a task without ...

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

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

Have you ever found yourself drowning in a sea of spreadsheets, endlessly clicking through menus and tabs, trying to make sense of your data? You’re not alone. The average Excel user spends nearly 40% ...

If you want to display the formula in cells instead of calculated results in an Excel spreadsheet, here is how you can do that. It is possible to show the used or applied formula and hide the actual ...

Over the years, I've flipped and flopped between various Excel keyboard shortcuts, but one has been my mainstay since I was a college kid: Ctrl+1. This memorable keystroke is my backdoor to tackling ...