Excel Sheet Names and Emojis
Did you know you can use Emojis on the sheet tabs? The font on sheet tabs is small, so some emojis may not be that effective, but simple emojis can be.
(more…)AAA all the way
I started my own weekly cash flow forecast file way back in 2010 and it just ticked over to column AAA!
Excel PivotTable Subtotal Label Trick
I just learned a new trick for labelling subtotal rows in a PivotTable. Hat tip to Ken Puls MVP of Excel Guru for this tip.
(more…)Useful Excel Keyboard Shortcuts for Data Entry
When making entries in Excel there are a few keyboard shortcuts worth knowing. These can save you time and effort.
(more…)A Better SEARCH Function for Excel
The SEARCH function has a couple of issues that make it difficult to use. This makes it a prime candidate for a custom function to fix its limitations.
(more…)Yet Another Post on Hiding Sheets in Excel
If you want to hide sheets and then stop people unhiding them, here is yet another technique.
(more…)