Excel Mouse Shortcuts and QAT

Videos show how to paste values with mouse shortcut, create a hyperlink with mouse shortcut, customize 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 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

More Excel Videos

Excel Videos - Index

Fill Blank Cells - Video

Data Entry Tips

Names, Macros, Numbers

Conditional Formatting

Pivot Table Tips