Fill Blank Cells From Above in Excel
106,468 views 2 years ago
✅ Get the sample Excel file to follow along: https://myctx.link/FILL Here's a quick way fill blank cells in Excel, with the value from above. Then you can sort and filter, without problems 🔴 Related Excel Videos 🔴 Fill Blank Cells From Above (long) ► https://youtu.be/iIKqeaFvltQ Cells Look Blank But Not Blank ► https://youtu.be/se-keFdKW4M Repeat Pivot Table Headings ► https://youtu.be/Li_d8lPwuOo Fix Excel Data in a Flash ► https://youtu.be/odnCzVvaoM8 💡 Related Links 💡 Excel Data Entry Tips ► https://myctx.link/FILL Repeat Pivot Table Headings ► https://myctx.link/MissData ✅ Excel resources I recommend ► https://myctx.link/xlpick ⏰ Video Timeline ⏰ 00:00 Introduction 00:19 Select Blank Cells 00:44 Lock the Values Instructor: Debra Dalgleish, Contextures Inc. More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu... #contexturesexceltips Video Transcript Sometimes in Excel, you might get data that looks like this: You've got headings in the first column and then subheadings and lots of blank cells. That makes it easy to read, but we won't be able to sort or filter this data unless we fill in these blank cells. I'm going to show you a quick way to do that. Start by selecting columns A and B, then on the HOME tab, click Find and Select, (then) Go To Special... In here, click Blanks, and OK. Now we're going to put in a very short formula. Start with an equal sign, click the up arrow key, (that selects the cell above). To fill this formula in all the selected cells, press the control key and tap the enter key. Now we're going to change all these formulas into values, so they're locked in. Again, I'll select A and B, point to the border of the selection (you'll see a 4 headed arrow) Now press the right-button on the mouse and drag a little bit to the right, then back to columns A and B and let go of the Right Mouse Button. Then in the pop-up menu, Copy Here as Values Only And now everything is a value, it's all filled in, and we can sort or filter this list.