Videos show how to paste values with mouse shortcut, create a hyperlink with mouse shortcut, customize Excel Quick Access Toolbar, to save time
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.
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
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
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: August 24, 2020 4:19 PM