Tag Archives for " Excel Shortcuts "

Show Formulas in Excel Instead of the Values

As soon as you type a formula in Excel and hit enter, it would return the calculated result, and the formula would disappear. That’s how it’s supposed to work. But what if you want to show formulas in the cells and not the calculated values. In this Excel tutorial, I will cover the following topics: […]

Continue reading >>

Working with Gridlines in Excel

Gridlines in Excel are those faint gray lines that you see around the cells in the worksheet. These gridlines make it easier to differentiate between the cells and read the data. Now don’t confuse gridlines with borders. Gridlines are visible on the entire worksheet while borders can be applied to the entire worksheet or to a […]

Continue reading >>

How to Quickly Unhide Columns in Excel

There are various ways to hide and unhide columns in Excel. It may happen that one of the methods may not work for you, in that case, it is good to know alternatives that can work. How to Unhide Columns in Excel In this tutorial, you’ll learn the following methods to unhide Columns in Excel: […]

Continue reading >>

How to Type Degree Symbol in Excel

How can you type degree symbol in Excel? It’s not there on the keyboard (at least not on the ones that I have seen). Surely, there must be some wicked convoluted technique to do this. Well – YES and NO. Yes – there is a way to type degree symbol in Excel (actually many techniques […]

Continue reading >>