The Data Validation dialog allows you to limit or control what a user enters into a cell. There are two keyboard shortcuts to open it.
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.
Let’s assume you need to fill a vertical range with all the whole numbers from 1 to 100. There are lots of ways to do this, but I think the keyboard could be the quickest.
Many people know that you can select the whole sheet with Ctrl + A but there are lots of other selections it can perform.
Excel has a shortcut that allows you to follow a link to its source but it has a limitation find out how to get around that limitation.
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.
Let’s say you have a table of codes and every month there are a few you want to check out. You could use a VLOOKUP to extract all the details for each code, but let’s say you want to view the codes in the table.
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.
You can right click a sheet tab and select Hide, but it is just as easy to Unhide the sheet. What if you want to make it harder to unhide the sheet?
When you become more advanced with macros and VBA programming (Visual Basic for Applications), you realise that you can create re-useable macros.