A recent question from a CPA in Canberra allowed me to combine the MOD function and helper cells to offer a solution.
Over the years I have had regular requests for a technique to hide zero rows in reports. You can use macros but you can also use filters. Let’s see how you can implement a filter solution.
In September 2019 I re-ran my very first webinar that was based on an August 2012 INTHEBLACK feature article. I have provided a detailed pdf manual and example files which you can download at the link below.
This session covers
- using controls with charts to make the user experience easier
- tips for using controls on spreadsheets
- flexible formula techniques to make reports more dynamic
- a technique to stop figures plotting on charts
- using range names with controls and reports
- general charting tips
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.
Most spreadsheet controls need to link to a cell to enable interaction with the spreadsheet. There is an easy way to do that.
Some actions clear the clipboard
Some actions in Excel will clear the clipboard after you have copied or cut.
Two common ones are
- inserting a new sheet
- clearing a filter – using Clear in the Data menu (keyboard shortcut Alt a c )
So if you are going to do either of these, do them before copying or cutting.
Copying between sheets or files is a common task. I’d like to share a quick and easy way to do it.