In some cases you may have to make manual inputs across multiple cells that are spread across a sheet. Before making the entries you need to clear the existing entries. Creating a range name can make that process much quicker. (more…)
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…)
Inserting a Comment (renamed to Notes in newer versions of Excel) in the first row and then using Freeze Panes to keep that first row visible can cause issues displaying the Comment (Note). Here’s how to fix it. (more…)
In May 2019 I examined and demonstrated some guidelines and techniques for creating charts for dashboards. 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 Webinar Materials https://vimeo.com/334821126 In this session I focused on chart and dashboard guidelines plus some techniques used to create small charts for dashboards. I also looked at creating a bullet chart, which…
When a list is filtered you are only seeing the rows that match the filter. The other rows are still there, just hidden. If you want to make the same entry in a group of filtered cells you can’t use the fill handle to drag and copy as you will overwrite the hidden rows. There is an easy way to do it.
(more…)