Let’s say you want the active cell to be A1 in all the sheets in a file before you save the file. There is an easy and quick way to do it. It doesn’t matter how many sheets are involved, but it does come with a warning.
When I ran some face to face training sessions recently I was reminded how much people LOVE shortcuts. I did a keyboard shortcut webinar session in October 2018.
In November 2018 I shared lots of mouse shortcuts. Download the materials using the button below and watch the video.
CPD note – if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances.
Some of the topics and techniques you will learn include:
- the various cursor shapes and how to use them correctly
- right clicking options you may not know exist
- copying anything quickly with the mouse, even sheets
- drawing perfect circles and squares
- lining up charts and other shapes perfectly
- cool techniques with the Fill Handle
- something you may never have tried with the right mouse button
- using the the Office clipboard
- a trick to use the Series dialog
This session will demonstrate lots of techniques using the mouse and also using the mouse with the keyboard.
Even if you prefer using the keyboard you might learn a few useful new techniques.
When you become more advanced with macros and VBA programming (Visual Basic for Applications), you realise that you can create re-useable macros.
It is easy to print things from Word. It is not so easy in Excel. Excel has this huge grid and if you don’t tell Excel otherwise, it will print everything on the sheet, whether you want it to or not.
Hyperlinks are a great tool as they allow you to speed up and simplify navigation within a file. Sometimes hyperlinks can be frustrating. See how to remove some of those frustrations below.
There are numerous keyboard and mouse shortcuts to navigate around your spreadsheet and file.
Sometimes in Excel you need to paste just the values from copied cells. You don’t want the formulas. You may have created temporary formulas that you need to replace with their values. You may need to capture the current values, make some changes and then compare the new values with their old values to see the difference.
When you copy a formula in Excel, any relative references (those without dollar signs) may change depending on where you paste the formula. If you would like to copy a formula and not have the relative references change you have two options.
The term grouping in Excel has many different meanings, probably more than any other term in Excel.
Ever tried using your right mouse button to click, hold and drag things around in Excel? You might be pleasantly surprised with the results.
Right clicking in Excel offers many productivity benefits. If you don’t already right click try it, it’s fun to see all the options that are just a click away.