HDTutorial
EN
Excel Tutorial: How to fill in empty cells using data from above, so you don't have any gaps left

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Excel Tutorial: How to fill in empty cells using data from above, so you don't have any gaps left

162,031 views October 25, 2011 3:17

Watch on YouTube
ChannelLaunch Excel

Description from the creator

// Recommended Excel Courses //

1. Launch Excel Macros & VBA School: go.launchexcel.com/macros-vba-school-youtube
2. Excel Campus Elevate Program: go.launchexcel.com/excel-campus-elevate-youtube
3. My Online Training Hub Dashboards: go.launchexcel.com/moth-dashboard-course-youtube
4. Coursera Excel Specialisation: go.launchexcel.com/coursera-excel-specializatio…
5. Coursera Everyday Excel: go.launchexcel.com/coursera-everyday-excel-yout…
6. Coursera Excel Data Visualisation: go.launchexcel.com/coursera-data-vizualization-…

// Recommended Excel Templates //

If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
go.launchexcel.com/simple-sheets-templates-yout…

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 launchexcel.com/fill-in-blank-cells-from-above/

*** 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 launchexcel.com to launch your Excel learning journey!

Stopwatch visuals were obtained from www.online-stopwatch.com

About this tutorial

Launch Excel published this 3:17 video tutorial on October 25, 2011. It has been watched 162,031 times on YouTube.

Category
Education
Duration
3:17
Published
October 25, 2011
Views
162,031
Likes
785

Tags

Share

Further reading

  • How to Fill Blank Cells with Value above in Excel - Free ... excelhow.net

    Fill Blank Cells with Value above. Suppose that you have a list of data in excel worksheet, you may be leave an empty cell if the value of that cell is the same as with the above value of cell. And if you want to sort o…

  • How to fill blank cells with value above / below / left ... extendoffice.com

    Using a formula to fill blank cells with value above. With this method, please do as the following steps: 1. Select the range that contains blank cells you need to fill. 2. Click Home > Find & Select > Go To Special…, a…

  • Fill Blank Cells in Excel With Value from Above skyneel.com

    Sometime we have an worksheet in which more than one cells left blanks and you need to fill blank cells in Excel with value from above. After filling all the blank cells you can easily sort, filter apply formatting as p…

This tutorial in other languages