Search Contextures Sites
Custom Search

Excel Videos - Mouse Shortcuts

Quickly paste values with a mouse shortcut, create a hyperlink with a mouse shortcut, and customize the Excel Quick Access Toolbar, to save time.

Paste Values Shortcut For Excel

Create a Hyperlink With an Excel Mouse Shortcut

Customize the Excel Quick Access Toolbar (QAT)

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

Customize the Excel Quick Access Toolbar (QAT)

To run macros that you create, or commands that you use frequently, and commands that aren't on the Excel Ribbon by default, you can add icons to the Excel Quick Access Toolbar. This video shows you the easy steps to follow, using the example of adding a macro icon to the QAT.

For written instructions for this Excel video tutorial, see the Contextures article: Customize the Excel Quick Access Toolbar

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search

Search Contextures Sites

More Excel Videos

Excel Videos - Index

Data Entry Tips

Names, Macros, Numbers

Conditional Formatting

Pivot Table Tips

 

 

 

 

More Excel Videos

Excel Videos - Index

Data Entry Tips

Names, Macros, Numbers

Conditional Formatting

Pivot Table Tips

 

 

 

 

 

   

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 31, 2016 7:49 PM