Alternatively, you can press Ctrl + Alt + F, or even configure it to open by the familiar Ctrl + F shortcut. Vertical Scorecard (Excel — PDF) Enhanced Vertical Scorecard (PDF) This is an enhanced version of the scorecard above. It contains spaces to mark the count against the batter. How to set up the criteria range for an Excel Advanced Filter. See the following Knowledge Base articles for additional tips: Top of Page Count the number of unique values in a list column by using Advanced Filter Use the Advanced Filter dialog box to find the unique values in a column of data. Here’s a nifty little trick I use every day while working in Excel. It’s a two part trick.
Fill All Blank Cells in an Excel Range With a Desired Value