|
Featured Tutorial
Featured Macro
Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Number
See how to use Go To Special Blanks to highlight all cells with Blanks. Then use Ctrl + Enter to put the same number in all cells. Then with the cells still highlighted apply Custom Number format to show an asterisk before each number.