Home > Skills > Data Entry > Videos Excel Data Entry VideosThese 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 |
AutoFill Dates in Series or Same DateWatch this short video, to see how AutoFill creates a date series. There are written steps, and more examples, on the AutoFill Examples page. |
Mouse Shortcut Paste As ValuesTo 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 AboveIn 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. |
Last updated: May 24, 2023 12:03 PM