O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Highlighting the blanks in a list of data

When working with large amounts of data, it can become difficult to locate blank spaces within the spreadsheet. Blank spaces can cause numerous issues including errors and breaks in formatting.

In this recipe, you will learn to locate and highlight all blanks within your data.

How to do it...

Smaller spreadsheets may allow you to quickly locate missed or blank information; however, Excel provides an automated method for performing this task that becomes increasingly more helpful with larger data-sets.

How to do it...
  1. Under the Home tab click on the option Find & Select, and then choose Go To Special.
  2. In the Go To Special.. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required