Here we can see that depending on how it is measured â that is, students missing 21, 20 days or 18 days, respectively -- that between one-fifth and one-third of students are not attending school regularly. Table 3 also begins to highlight the sheer magnitude of the challenge some school districts face.
Display nothing if cell is not blank. If you only want to display a value if a cell is not blank, you can replace the value if false argument in the IF function with an empty string (). Alternative with ISBLANK. Excel contains a function dedicated to testing for empty cells called ISBLANK. Excel Formula Training.
5. Press Enter. Voila! Excel automatically fills all blank cells down your column with the same formula. If you want to switch back from a table to a simple range for some reason (I don't know any :)), select any cell in your table, then press the  Convert to range  button on the Design tab.. Select all the blank cells in a column. 2. Press F2 to edit the last selected cell and type some data: it can be text, a number, or a formula (e.g.  _unknown_ ). 3. Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.