Excel Unplugged

Tag Archives: F5

Pragmatism vs. purity in Excel

One of the greatest things about Excel is that with its endless array of tools and commands it almost always offers multiple ways of achieving a certain goal. ...

Boost your Excel efficiency with one key – F5 (Go To and Go To Special)

Very often you will find yourself in a position where you wish to either move efficiently through the workbook or you wish to select only cells containing certain ...

Fill All Blank Cells in an Excel Range With a Desired Value

How to fill blank cells in Excel with a desired value? In this tutorial we’ll be selecting all the blank cells and fill them in. Part one will be selecting all ...