Contextures

Excel Data Entry Videos

Excel data entry videos show how to use a named range, convert text to numbers, and more tips

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

Search Contextures Sites

 

Excel Data Entry Popup List

 

 

 

 

Excel Tools Add-in

 

 

 

Excel Data Entry Popup List

 

Excel UserForms for Data Entry

 

Last updated: December 25, 2016 2:49 PM
Contextures RSS Feed