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

Here’s a nifty little trick I use every day while working in Excel. It’s a two part trick. Part one will be selecting all the blank cells in a range or ...