1) On the Home tab, select the Find and Select dropdown menu which is located on the Editing Group of icons
2) Select Go to Specials ... and select the Blanks radio button and then click OK. All the cells with no data are selected and showed with a fill color. Do not click on any part of the open Excel workbook.
3) Type any character that you want to replace the blanks with. You can include the format for the cell, for example, aligment. Do not press any key yet.
4) Press Ctrl+Enter. This will copy the character you enter in step 3 to all selected cells including the format you selected on step 2.
No comments:
Post a Comment