|
|
Search
Contextures Sites
|
||
|
|
|
|||
Contextures Inc., Copyright © 2009.
All rights reserved.
Search Contextures Sites
Excel Tutorial Videos 09
Paste Values Shortcut For Excel
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.
Create a Hyperlink 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
Contextures Inc., Copyright © 2009.
All rights reserved.
Last updated: February 25, 2010 1:26 PM
