It is very annoying when a table has blank cells.  You can not filter, sort or even produce accurate pivot table or graphs.  The solution is to manually fill in the cells.  Here is a way to eliminate this tedious process.

Fill in empty cells


Notice that the cells are blank under each state. You need to fill in these cells in order to work with tables.

  1. Highlight the cells from the bottom up by using the Control and Mouse (this is the sparatic selection).
  2. The last cell that is chosen and active should be B4.
  3. OR click on Find & Select, Go To Special, BlanksFill in empty cells highlightedpng
  4. Type = and click on B3
  5. Control EnterFill in empty cells highlighted and completed

There You Have it!