Hide the Gridlines in Excel: 5 Easy Methods

How to hide the gridlines in Excel

The light grey gridlines are quite useful. They provide a quick impression of the rows and columns of your Excel worksheet. But once you want to create your final layout, they look annoying. Your worksheet looks more professional with hidden gridlines.

INDIRECT: How to Use Text as a Cell Reference in Excel

The INDIRECT formula in Excel

You want to get data from different sheets but always on the same cell? INDIRECT returns the value of a cell which you specify by a string. For example, if you write =INDIRECT(“B2”) it’ll give you the value of B2. Instead of just B2, you can also refer to other sheets, for example =INDIRECT(“Sheet1!B2”) or even other workbooks.

Goal-Seek in Excel: Easily Achieve Your Desired Result!

You’ve done some calculations in Excel but you aren’t satisfied with the result? So you ask yourself, how you could achieve the desired result. A good starting point for such analysis is the built-in Goal Seek function in Excel. It’s simple to use but yet powerful. On the other side, it does some reverse calculation and therefore has a reputation for cheating in order to achieve the target results.