Excel Tutorial: How to fill in empty cells using data from above, so you don't have any gaps left
// Recommended Excel Courses //
1. Launch Excel Macros & VBA School: https://go.launchexcel.com/macros-vba...
2. Excel Campus Elevate Program: https://go.launchexcel.com/excel-camp...
3. My Online Training Hub Dashboards: https://go.launchexcel.com/moth-dashb...
4. Coursera Excel Specialisation: https://go.launchexcel.com/coursera-e...
5. Coursera Everyday Excel: https://go.launchexcel.com/coursera-e...
6. Coursera Excel Data Visualisation: https://go.launchexcel.com/coursera-d...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
https://go.launchexcel.com/simple-she...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
// Show Notes //
Fill in blank cells from above, two methods compared (1) manual copy / paste using the fill handle vs (2) using Excel's F5 Go To feature to select only blank cells. Read my blog post on this subject at http://www.launchexcel.com/fill-in-bl...
** Jump to 2:00 minutes, Step by Step Method using Shortcut Menu F5 **
Select all of the values and blanks in column B by clicking on the column B header.
Press F5 to bring up the Go To menu.
Press Alt and S to select Special Cells.
Press Alt and K to select all Blank cells.
Type in the formula "equals cell above".
Press Ctrl and enter to fill the formula into all the blank cells selected.
Select column B by clicking on the column header.
Right click the selection border.
Drag the selection one column to the right.
Then drag the selection one column to the left.
Finally select paste as values to overwrite any formulas as values.
As you watch the video tutorial part you may find it helpful to pause, if you want to follow along in Excel and try out the shortcuts. Remember to visit http://www.launchexcel.com to launch your Excel learning journey!
Stopwatch visuals were obtained from www.online-stopwatch.com