Microsoft Excel Tutorial: Fast way to fill blank cells with value from above in Excel.
In Podcast 2367, Bill Jelen demonstrates a quick method to fill down blank cells in Excel with the value from the cell above in just 11 keystrokes. Deepak's data consists of 50 rows and four columns with numerous blank cells that need to be populated with values from the cells above.
Here are the 11 keystrokes to accomplish this:
1. Select the data.
2. Press Ctrl+G or F5 to open the Go To dialog.
3. In the Go To dialog, press Alt+S to select "Special."
4. Inside "Go To Special," press Alt+K to select "Blanks."
5. Press Enter to confirm the selection. This will highlight all the blank cells in the selected range.
6. Type an equals sign (=) to indicate the start of a formula.
7. Use the Up Arrow key to reference the cell above.
8. Press Ctrl+Enter to fill all the selected blank cells with the value from the cell above.
At this point, the blank cells are filled with formulas that reference the cells above. To convert these formulas to values, follow these additional steps:
9. Press Ctrl+* to select the entire data range.
10. Press the right-click key (if available on your keyboard) followed by the V key. If you don't have the right-click key, use Shift+F10 and then V.
This will replace the formulas with their calculated values, effectively filling the blank cells with the values from above.
Bill concludes the video by emphasizing the simplicity and efficiency of this method, making it the shortest podcast ever, and encourages viewers to like, subscribe, and ring the bell for more Excel tips.
Deepak has 4 columns by 50 rows with a lot of blank cells. How to fill each blank cell with the value from above? This can be done in 11 keystrokes.
Select the 50 rows by 4 columns
Ctrl+G or F5 for Go To
Alt+S for Special
Alt+K for Blanks
Enter for OK
Equals Sign to start a formula
Up Arrow to point to the cell above
Ctrl+Enter
Ctrl+* to select all cells
Ctrl+C to Copy
Shift+F10, v
Buy Bill Jelen's latest Excel book: MrExcel 2022 Boosting Excel
You can help my channel by clicking Like or commenting below: Why clicking Like on a YouTube video helps my channel
#excel
#microsoft
#exceltricks
#excelhacks
This video answers these common search terms:
how to fill in blank cells in excel from data above
how to fill blanks will value above cell excel
how to fill blanks in excel with cell above
how to fill in blanks excel from data above
how to fill in blanks in excel with row above
how to fill blank cells in excell withdata above
how to fill empty cells in excel with value above
how to fill up the empty cells with the data above in excel
how to fill in a blank in excel with the cell above
excel how to fill down without dragging
is there a formula in excel to fill in blank cells
how to get a formula to fill down excel
how to fill down formula in excel?
how to fill blanks excel formula
how to fill down in excel formula
how to fill empty cells in excel using if formula
how to down fill in excel
how to fill down multiple cells in excel
how to fill down a column in excel
how to fill down blank cells in excel
how to fill down cells in excel
how to fill down excel
how to fill down in excel
how to fill down on excel
excel how to downfill
where is fill down in excel
how to autofill down cells in excel
how to autofill down in excel
how to use fill down in excel
excel how to fill down column
excel how to fill down keyboard
how to fill cells down in excel
how to fill excel downward
how to use a fill down in excel
excel how to autofill down
how to use excel fill down
how to fill an excel cell down until next cell is filled
how to make excel fill a cell down
how to fill blank cells in a column in excel
how to fill blank cell in excel
how to fill blank cells in excel
how to fill blank in excel
how to fill blanks in excel
how o fill the blanks on excel
how to fill in blank cells excel
how to fill in blank in excel
how to fill in blanks in excel
how to fill all blank cells in excel
how to fill all blank cells with n in excel
how to fill the blank cells in excel
how to fill the blanks in excel
how to fill down blank cells in excel
excel how to fill blanks
how to select all blank cells excel and fill with text
how do you fill in blank cells in excel
how to fill in all blanks excel
how to fill excel cell with a value when blank
how to fill empty cells in excel function]
how to fill empty cells with value in excel
how to fill up empty cell in excel
how to autofill empty cells in excel
how to fill only empty cells with data in excel
how to copy and fill empty cells in excel
how to autofill with data in empty cells in excel
Table of Contents
(0:00) Problem Statement: Fill Blank Cells with Value from Above in Excel
(0:10) Fill blank cells from the last value above in 11 keystrokes
(0:20) The 9 keystrokes to fill down in Excel
(0:54) Convert Excel formulas to Values
(1:06) Clicking Like really helps with the algorithm
In Podcast 2367, Bill Jelen demonstrates a quick method to fill down blank cells in Excel with the value from the cell above in just 11 keystrokes. Deepak's data consists of 50 rows and four columns with numerous blank cells that need to be populated with values from the cells above.
Here are the 11 keystrokes to accomplish this:
1. Select the data.
2. Press Ctrl+G or F5 to open the Go To dialog.
3. In the Go To dialog, press Alt+S to select "Special."
4. Inside "Go To Special," press Alt+K to select "Blanks."
5. Press Enter to confirm the selection. This will highlight all the blank cells in the selected range.
6. Type an equals sign (=) to indicate the start of a formula.
7. Use the Up Arrow key to reference the cell above.
8. Press Ctrl+Enter to fill all the selected blank cells with the value from the cell above.
At this point, the blank cells are filled with formulas that reference the cells above. To convert these formulas to values, follow these additional steps:
9. Press Ctrl+* to select the entire data range.
10. Press the right-click key (if available on your keyboard) followed by the V key. If you don't have the right-click key, use Shift+F10 and then V.
This will replace the formulas with their calculated values, effectively filling the blank cells with the values from above.
Bill concludes the video by emphasizing the simplicity and efficiency of this method, making it the shortest podcast ever, and encourages viewers to like, subscribe, and ring the bell for more Excel tips.
Deepak has 4 columns by 50 rows with a lot of blank cells. How to fill each blank cell with the value from above? This can be done in 11 keystrokes.
Select the 50 rows by 4 columns
Ctrl+G or F5 for Go To
Alt+S for Special
Alt+K for Blanks
Enter for OK
Equals Sign to start a formula
Up Arrow to point to the cell above
Ctrl+Enter
Ctrl+* to select all cells
Ctrl+C to Copy
Shift+F10, v
Buy Bill Jelen's latest Excel book: MrExcel 2022 Boosting Excel
You can help my channel by clicking Like or commenting below: Why clicking Like on a YouTube video helps my channel
#excel
#microsoft
#exceltricks
#excelhacks
This video answers these common search terms:
how to fill in blank cells in excel from data above
how to fill blanks will value above cell excel
how to fill blanks in excel with cell above
how to fill in blanks excel from data above
how to fill in blanks in excel with row above
how to fill blank cells in excell withdata above
how to fill empty cells in excel with value above
how to fill up the empty cells with the data above in excel
how to fill in a blank in excel with the cell above
excel how to fill down without dragging
is there a formula in excel to fill in blank cells
how to get a formula to fill down excel
how to fill down formula in excel?
how to fill blanks excel formula
how to fill down in excel formula
how to fill empty cells in excel using if formula
how to down fill in excel
how to fill down multiple cells in excel
how to fill down a column in excel
how to fill down blank cells in excel
how to fill down cells in excel
how to fill down excel
how to fill down in excel
how to fill down on excel
excel how to downfill
where is fill down in excel
how to autofill down cells in excel
how to autofill down in excel
how to use fill down in excel
excel how to fill down column
excel how to fill down keyboard
how to fill cells down in excel
how to fill excel downward
how to use a fill down in excel
excel how to autofill down
how to use excel fill down
how to fill an excel cell down until next cell is filled
how to make excel fill a cell down
how to fill blank cells in a column in excel
how to fill blank cell in excel
how to fill blank cells in excel
how to fill blank in excel
how to fill blanks in excel
how o fill the blanks on excel
how to fill in blank cells excel
how to fill in blank in excel
how to fill in blanks in excel
how to fill all blank cells in excel
how to fill all blank cells with n in excel
how to fill the blank cells in excel
how to fill the blanks in excel
how to fill down blank cells in excel
excel how to fill blanks
how to select all blank cells excel and fill with text
how do you fill in blank cells in excel
how to fill in all blanks excel
how to fill excel cell with a value when blank
how to fill empty cells in excel function]
how to fill empty cells with value in excel
how to fill up empty cell in excel
how to autofill empty cells in excel
how to fill only empty cells with data in excel
how to copy and fill empty cells in excel
how to autofill with data in empty cells in excel
Table of Contents
(0:00) Problem Statement: Fill Blank Cells with Value from Above in Excel
(0:10) Fill blank cells from the last value above in 11 keystrokes
(0:20) The 9 keystrokes to fill down in Excel
(0:54) Convert Excel formulas to Values
(1:06) Clicking Like really helps with the algorithm
Transcript of the video:
Podcast 2367. Fill down in 11 Keystrokes.
Hey this is Bill Jelen from MrExcel.
Deepak has 50 rows, four columns with a lot of blank cells.
He wants the blank cells to have the value from above.
Deepak, I had to do this video because you would not believe it is only 11 keystrokes.
First select the data.
Then Ctrl+G or F5 for Go To. I press F5.
In Go To dialog, Alt+S to select Special.
Inside of Go To Special, Alt+K for Blanks.
Enter for OK.
That selects all of the blank cells. That is great.
Equals sign. That says to Excel that we are starting a formula.
Up Arrow says the formula is the cell above me.
Ctrl+Enter and all of those blank cells are filled with the value from above.
Dallas Dallas Dallas.
Here there is a big run of blank cells that all say carrot.
You think we are done, but you want to convert those formulas to values.
Ctrl+* selects everything.
Ctrl+C to Copy.
On my keyboard, I have a right-click key.
I press that key and the V.
If you don't have the right-click key, then Shift+F10 and V.
So, right-click, V.
We are done.
Shortest podcast ever.
Like. Subscribe. Ring the Bell.
Thanks for stopping by. We will see you next time for another podcast from MrExcel.
Hey this is Bill Jelen from MrExcel.
Deepak has 50 rows, four columns with a lot of blank cells.
He wants the blank cells to have the value from above.
Deepak, I had to do this video because you would not believe it is only 11 keystrokes.
First select the data.
Then Ctrl+G or F5 for Go To. I press F5.
In Go To dialog, Alt+S to select Special.
Inside of Go To Special, Alt+K for Blanks.
Enter for OK.
That selects all of the blank cells. That is great.
Equals sign. That says to Excel that we are starting a formula.
Up Arrow says the formula is the cell above me.
Ctrl+Enter and all of those blank cells are filled with the value from above.
Dallas Dallas Dallas.
Here there is a big run of blank cells that all say carrot.
You think we are done, but you want to convert those formulas to values.
Ctrl+* selects everything.
Ctrl+C to Copy.
On my keyboard, I have a right-click key.
I press that key and the V.
If you don't have the right-click key, then Shift+F10 and V.
So, right-click, V.
We are done.
Shortest podcast ever.
Like. Subscribe. Ring the Bell.
Thanks for stopping by. We will see you next time for another podcast from MrExcel.
