{"id":203211,"date":"2023-12-26T17:05:28","date_gmt":"2023-12-26T17:05:28","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-fill-blank-cells-in-excel-with-value-above\/"},"modified":"2023-12-26T17:05:28","modified_gmt":"2023-12-26T17:05:28","slug":"how-to-fill-blank-cells-in-excel-with-value-above","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-fill-blank-cells-in-excel-with-value-above\/","title":{"rendered":"How to fill blank cells in Excel with value above?"},"content":{"rendered":"

If you have a spreadsheet in Excel with blank cells that you want to fill with the value above, you can easily do this using a simple formula. Here’s how:<\/p>\n

1. Click on the cell where you want to start filling the blank cells with the value above.
\n2. Type the following formula: =IF(ISBLANK(A2),B1,A2)
\n3. Press Enter.<\/p>\n

This formula checks if the cell above is blank. If it is, it fills the current cell with the value from the cell above; if not, it keeps the current cell’s value. <\/p>\n

Now you have successfully filled the blank cells in Excel with the value above.<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n