Selecting the Cell in the First Row in a Column in Excel
There is a keyboard shortcut to select the first column in a row, but as far as I know there is no shortcut for the first row in a column.
(more…)Excel Alt key Shortcuts
The Alt key offers a way to use icons without using the mouse. In some cases, these Alt key shortcuts can be quicker than using the mouse.
(more…)Entering today’s date in Excel
You can use a keyboard shortcut to enter today’s date in a cell, but you can also use it in lots of other places in Excel.
(more…)Mouse Based Formulas in Excel
Do you hate using the keyboard for formulas? Does having to peck the = or + key to create a formula annoy you? Well there is an answer. (more…)
Selecting a single word in Excel
If you are editing a sentence or a heading and you need to replace a single word there is a quick and easy way to do it. (more…)
Data Validation Shortcut
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. (more…)
Free Excel Webinar Recording – Mouse Shortcuts
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. [button…
Filling a large range in Excel with a series [Video]
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.
(more…)Selecting All with Ctrl + A
Many people know that you can select the whole sheet with Ctrl + A but there are lots of other selections it can perform. (more…)
Following Links in Excel
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. (more…)
Alt Key Shortcuts
I use Alt key shortcuts a lot when I am working and I have found a couple more useful ones. (more…)
Excel and Ctrl + A
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. (more…)
Creating a Hyperlink in Excel Based on a Search
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.
(more…)Excel Full Screen
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.
Disabling Sheet Unhide in Excel
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?
(more…)VBA macros that run other macros
When you become more advanced with macros and VBA programming (Visual Basic for Applications), you realise that you can create re-useable macros. (more…)