I use Alt key shortcuts a lot when I am working and I have found a couple more useful ones.
This Excel keyboard shortcut is powerful, but it has a few quirks you need to be aware of. Its quick to use because the A and Ctrl keys are so close together.
There are times in Excel when you want to see as much of the Excel grid as possible. You may be reviewing or presenting a dashboard or looking at a large PivotTable. Excel has a Full Screen mode that shows just the grid and the sheet tabs.
It is common to use Q1 for quarter one. Excel will even cycle through Q1,Q2,Q3 and Q4 when you drag a cell contain Q1. What if you want to use the sequence M1 to M12 for months? Custom Lists to the rescue!
Let’s say you have a file that has numerous input cells, in numerous sheets. Each month you must clear the input cells and start the new month. There is a technique that allows you to clear the input cells if you have used a dedicated colour for those cells.
Excel’s Fill Handle has a lot of cool tricks. This short video demonstrates a couple of them.
Sometimes when Excel imports email addresses they are not recognised as emails and are not hyperlinks. They are two ways to fix this.
Comments are like post it notes for cells. They are a great documentation feature because you can add cell-specific notes to help you and other users understand the spreadsheet better. There are also a few “outside the box” uses for cell comments.
If you need to limit where a user can scroll to in a sheet you can change a setting in the VBA screen to restrict access to a specific range.
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.
There are numerous keyboard and mouse shortcuts to navigate around your spreadsheet and file.
There are number of shortcuts you can use to speed up your data and formula entry in Excel.
Use the number keypad on the right of the keyboard. This has all the numbers, as well as most of the formula operators (+ * – /), you need to create formulas. It also has a large Enter key. The numbers are laid out like a calculator and so are easy to use.
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.
Macros can really improve your productivity in Excel. When you record a macro you have the option to define a shortcut key. Did you know you can also define a shortcut key for non-recorded macros?
The Format As Table feature has many useful features that are worth taking advantage of. The previous post listed them. The video of this blog is shown at the bottom of the post.