{"id":200488,"date":"2023-11-01T06:02:04","date_gmt":"2023-11-01T06:02:04","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-fill-blank-rows-in-excel-with-value-above\/"},"modified":"2023-11-01T06:02:04","modified_gmt":"2023-11-01T06:02:04","slug":"how-to-fill-blank-rows-in-excel-with-value-above","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-fill-blank-rows-in-excel-with-value-above\/","title":{"rendered":"How to fill blank rows in Excel with value above?"},"content":{"rendered":"

If you have a dataset in Excel with blank rows and you want to fill those blank rows with the value from the row above, you can easily do so using a simple formula. <\/p>\n

Here’s a step-by-step guide on how to fill blank rows in Excel with the value above:<\/p>\n

1. Select the column where you want to fill in the blank rows.
\n2. Press `Ctrl+G` to open the ‘Go To’ dialog box.
\n3. Click on the ‘Special’ button in the ‘Go To’ dialog box.
\n4. Select ‘Blanks’ and click ‘OK’. This will select all the blank cells in the column.
\n5. In the formula bar, type `=IF(ISBLANK(A2),A1,A2)` and press `Ctrl+Enter`. Replace `A2` and `A1` with the appropriate cell references for your dataset.
\n6. This formula checks if the cell above is blank. If it is, it will fill in the value from the cell above; if not, it will keep the existing value.
\n7. Now all the blank rows in your selected column should be filled with the value from the row above.<\/p>\n

**Voila! Your blank rows in Excel have been filled with the value above.**<\/p>\n

\n
\n

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