Contextures

Home > Skills > Data Entry > Videos

Excel Data Entry Videos

These Excel data entry videos show how to make a quick list of dates, clear data entry cells, and change formulas to values with a mouse shortcut. 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.

Video: Clear Data Entry Cells

In Excel, you can use a built-in command to quickly select all the cells with data typed into them, and ignore the cells with formulas. Then, after you select the data cells, use the keyboard or a Ribbon command to clear the cells.

Watch this short video to see the steps.

Mouse Shortcut Paste As Values

To quickly change formulas into values, you can use this mouse shortcut, shown in the video below. The written instructions are on the Excel Data Entry Tips 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: May 24, 2023 12:03 PM