Formula Excel

This feature is very useful for you who want to quickly fills the empty cells referring the previous cell's value. See figure below:

If you select range A1:A18 and select Fill Cells In Columns button, the empty cells in column A will be filled as the following figure:


Here's the explanation:

• Fill Cells in Rows: fill the empty cells in rows
• Fill Cells in Columns: fill the empty cells in column
• Unfill Cells in Rows: delete the contents of the cell in rows
• Unfill Cells in Columns: delete the contents of the cell in column