Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
32,738
Uploaded by contextures on Apr 30, 2008
http://www.contextures.com/xlDataEntry02.html
Some sheets have blank cells, so headings are easier to read. If you want to sort or filter the list, you need to fill in the blanks, by copying the value from above.
Category:
Tags:
License:
Standard YouTube License
-
17 likes, 0 dislikes
Link to this comment:
Share to:
Uploader Comments (contextures)
see all
All Comments (8)
-
Thanks a lot :)
YoureMyBest 5 months ago
-
Right on target. It might help to go just a bit slower as I was trying to perform the steps along with you.
kcpurplepower1 1 year ago
Loading...
Advertisement
9:28
Excel Spread Sheet Basics - Using a Formulaby vhyndman557,403 views
5:18
Create a Named Range in Excel That Grows Automaticallyby contextures13,581 views
4:58
Different Drop Down Lists in Same Excel Cellby contextures30,636 views
6:41
Excel Lookup Series #2: VLOOKUP Function 2nd Exampleby ExcelIsFun126,848 views
3:06
Quickly Fill in Blank Cells in an Excel Reportby DannyRocksExcels2,350 views
2:15
Creating a Drop Down List in Excel 2010by aqueity11,897 views
2:13
Create Drop Down List in Excel Worksheet Cellby contextures23,140 views
3:21
Excel Tip: Deleting Blank Rows, Hiding Blank Rows and Excluding Them From Being Copiedby everydayexcelstuff1,923 views
1:43
Excel Magic Trick #20: Lightening Fast Copy Trick!by ExcelIsFun22,048 views
3:17
Excel Tip: Fill in Blank Cells from aboveby LaunchExcel2,384 views
4:46
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookupby ExcelIsFun70,645 views
3:10
Excel Magic Trick 343: Delete Blanks Rows & Keyboard Magicby ExcelIsFun9,128 views
6:34
Excel Magic Trick 486: Avoid #DIV/0! Error in Formula 4 Examples (Divide By Zero Error)by ExcelIsFun7,112 views
9:44
VBA Lesson 3 - Deleting blank rows - ExcelVBASql.com 25+ hours of FREE training!by ExcelVBAHelp32,170 views
1:45
Fill in Blank Cells in Excel Pivot Tableby XLXBERT1,020 views
2:24
Filling Blank Cells in Excel Worksheetsby ClintEJr2,522 views
1:43
Add a Picture to an Excel Commentby contextures20,607 views
2:24
Filter Excel Data to a Different Sheetby contextures38,844 views
4:08
Select Multiple Items from Excel Data Validation Listby contextures25,041 views
0:32
How to fill blank cells in excel data range with cell above itby ygblogs3,828 views
- Loading more suggestions...
don't get the step after selecting blanks then ok....
kaiotes 7 months ago
@kaiotes Click the link in the video description, to go to the page with the written instructions. That will show you all the steps.
contextures 7 months ago
All these years I have been manually filling these blank cells!!! And I didn't know what key word to search for shortcut. After working on a sheet with hundred thousands of data, I've had enough! And here you go the video.
Thank you so much!!!
jimmywooo100 8 months ago
@jimmywooo100 You're welcome, and I'm glad you finally found a solution!
contextures 8 months ago
You explained the solution in very short and clear manner.
Much appreciate.
vijay2345 1 year ago
@vijay2345 You're welcome. I'm glad the video helped you.
contextures 1 year ago