Change in Ctrl Key Selections
Do you use the Ctrl key and the mouse to select multiple ranges? Well you may want to watch this short video. (more…)
Excel VBA to Remove Filters
When creating macros that work with filters it is a good idea to remove filters at the beginning of the macro code. Here is how you do that.
(more…)Missing Sheet Gridlines in Excel
Ever seen a sheet with what looks like missing gridlines? Wondered what happened? The issue is a format. (more…)
Free Excel Webinar Recording – Keyboard Shortcuts
When I ran some face to face training sessions recently I was reminded how much people LOVE keyboard shortcuts. So I decided to update my keyboard shortcut webinar. In October 2018 I shared lots of keyboard 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. Download…
Delete a cell comment
From a question in a recent webinar I found a keyboard shortcut to delete a cell comment. Alt r d pressed in sequence, not held down.
Updates to Pivot Tables
If you have the latest Excel version or the subscription version, you may have noticed some refreshing improvements to PivotTables. (more…)
Adding current date to a cell comment
You may know that Ctrl + ; (semi-colon) will insert the current date in a cell. Did you know it also works in a cell comment?
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…)Running Total in a Formatted Table
Formatted Tables allow you to create formulas that automatically copy down as the table expands. To create a running total in a column you have a couple of options. (more…)
Advanced Filter Keyboard Shortcut
To open the Advanced Filter dialog use Alt A Q pressed in sequence, not held down.