How To: Fill in the blanks with custom number format in Excel

This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be there. Now type what you want to show up in the cells and press 'OK' to finish.