How to Replace Text with the SUBSTITUTE Formula in Excel

SUBSTITUTE in Excel

Sometimes, you need to change text in a systematic way: If you want to replace some text with new text, there are two options. If you only want to do it once, using the Find-and-Replace dialogue is probably the fastest choice. If you want to do it repeatedly or don’t want to mess with your input data, you should try the SUBSTITUTE formula.

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.