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.