![]() In column B which you want to get the value from column A, A1 is the cell you refer to, drag fill handle over cells to apply this formula. If there are two columns, column B is refer to column A,how can you fill a default value while cell in column A is blank? In this article, I introduce some methods on filling a default value if the relative cells or cells in the range are blank in Excel.įill a default value if the reference cell is blank with formulaįill a default value if the cell is blank with Find and Replaceįill a default value if the cell is blank with Go To Specialįill value above/below or default value if the cell is blank with Kutools for Excel How to fill a default value if cell is blank in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |