About this tutorial:
Video duration: 2:26
Visit this page to download the sample file, and for written instructions and a macro to fill blank cells.
Some sheets have blank cells, so headings are easier to read. If you want to sort or filter the list, you need to fill in the blanks, by copying the value from above.
This video shows a quick way to select and fill all the blanks, and use a mouse shortcut to change the formulas to values.