Search Contextures Sites
Custom Search

Excel Video Tutorials -- Data Entry

Short videos with Excel data entry tips.

AutoFill Dates in Series or Same Date
Convert Text Numbers to Real Numbers 
Excel Data Entry in Specific Cells 
Fill Blank Cells From Above
Paste Values Mouse Shortcut
Hyperlink - Create with Mouse Shortcut
Paste Special to Increase Amounts (Excel 2003)
Paste Special to Increase Amounts (Excel 2007)

AutoFill Dates in Series or Same Date

Use the AutoFill handle to quickly enter a series of dates, or a list will all dates the same.

For written instructions for this Excel data entry tutorial, see the Contextures Blog article: AutoFill Excel Dates in Series or Same Date

Convert Text Numbers to Real Numbers

If numbers don't add up correctly, they may be entered as Text, instead of real numbers. Use this technique to fix them. For written instructions for this Excel data entry tutorial see: Convert Numbers

Excel Data Entry in Specific Cells

Make it quick and easy to move through cells in a specific order, by using a named range. For written instructions for this Excel data entry tutorial, see the Contextures Blog article: Jump to the Next Data Entry Cell in Excel

Fill Blank Cells From Above

If a worksheet contains cells that have been left blank, you can fill in the blanks, by copying the value from the first filled cell above the blank. By filling in the blanks, you'll be able to sort or filter the list. The following technique makes it easy to fill in the blanks.

For written instructions for this Excel data entry tutorial see: Fill Blank Cells From Above

Paste Values Mouse Shortcut

In this Excel video tutorial, you can see how to use a mouse shortcut to copy cells that contain formulas, and then paste those cells as values. This will lock in the values, so you can sort or move the cells, without any problems.

This technique is the quickest way that I've found to copy and paste the values.

For written instructions for this Excel video tutorial, see the Contextures Excel Blog article: Paste Values Shortcut For Excel

If you prefer to use keyboard shortcuts in Excel, instead of mouse shortcuts, you can find a long list of them on the Excel Keyboard Shortcuts page.

Hyperlink - Create With an Excel Mouse Shortcut

This video shows how you can use a quick and easy mouse shortcut in Excel, to create a hyperlink to another cell in the workbook. When the user click on the hyperlink, they'll be automatically taken to the linked cell, without using any macros in your workbook.

You can use this Excel hyperlink technique to create a table of contents in an Excel workbook, or to provide a quick link from one worksheet to another worksheet. That will make it easier for users to navigate through the workbooks that you create for them.

For written instructions for this Excel video tutorial, see the Contextures Excel Blog article: Creating Excel Hyperlinks is a Drag

Paste Special to Increase Numbers by Set Amount (Excel 2003)

In Excel 2003, you can increase or decrease all the numbers in a range by a specific amount. For example, in a price list, all the prices could be increased by $1.50, or the prices could be decreased by 5%.

The technique shown in the following video makes it easy to increase the prices on the worksheet, all at once, by using the Paste Special command on the Excel menu bar. You'll type a value into a cell, then copy that cell, and apply its value to other cells.

For written instructions for this Excel tutorial, see: Increase Numbers

Paste Special to Increase Numbers by Set Amount (Excel 2007)

In Excel 2007, you can increase or decrease all the numbers in a range by a specific amount. For example, in a price list, all the prices could be increased by $1.50, or the prices could be decreased by 5%.

The technique shown in the following video makes it easy to increase the prices on the worksheet, all at once, by using the Paste Special command on the Excel Ribbon. The technique is similar to the steps in the previous video, for Excel 2003, but the command is in a different location. You'll type a value into a cell, then copy that cell, and apply its value to other cells.

For written instructions for this Excel tutorial, see: Increase Numbers

More Tutorials

Excel Videos - Index

Macros

Mouse Shortcuts

Pivot Table Tips

Names

Paste Special

Create UserForms

Copy VBA

 

 

 

More Tutorials

Excel Videos - Index

Macros

Mouse Shortcuts

Pivot Table Tips

Names

Paste Special

Create UserForms

Copy VBA

 

 

 

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 31, 2016 7:25 PM