Contextures

Excel Data Entry Videos

These Excel data entry videos show how to make a quick list of dates. Also, see an easy way to fill blank cells, by copying the values from above

fill the blank cells manually

AutoFill Dates in Series or Same Date

Watch this short video, to see how AutoFill creates a date series. There are written steps, and more examples, on the AutoFill Examples page.

Fill Blank Cells From Above

In this video, watch the steps to manually select and fill blank cells, with the value from the cell above. Then, use a mouse shortcut to change the formulas to values, so you can safely sort and filter the data.

For written steps, and the sample file, go to the Fill Blank Cells page.

 

More Video Training

Drop Down List (Basic) Videos

Dependent Drop Down Videos

VLOOKUP Videos

Pivot Table Videos

Last updated: July 5, 2022 3:12 PM