Some Excel sheets have blank cells, to make the headings easier to read. If you need to sort or filter the list, those blank cells need to be filled in. Use this simple technique to quickly fill blank cells in Excel 2003
For newer versions of Excel, see the Fill Blank Cells page
To fill blank cells manually, you will select all the blanks, enter a simple formula in each cell, then convert the formulas to values. Watch the short video to see the steps, and written instructions are below the video
This video shows the quick steps to fill blank cells in Excel 2003. Written steps are below the video.
Follow these steps to fill blank cells in an Excel 2003 worksheet.
In order to sort or filter the data, the formulas must be changed to values.
Note: Do this carefully if there are other cells in the range which contain formulas.
To see the report with blank cells, and test the Fill Blanks technique, download the sample file. The file is zipped, and is in xls format, and does NOT contain macros.
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: August 7, 2019 11:10 AM