Evil Halloween Excel Trick-A Spreadsheet That Scrolls Backwards
Hello, Excellers. Want a Halloween trick Let's have a bit of fun and be a bit evil?. It is Halloween after all. How about a worksheet prank?. A spreadsheet that scrolls backwards with...
Hello Excellers and welcome back another #FormulaFriday #Excel blog post in my 2020 Excel series. I will share a solution to a question asked recently. How to find how many numbers in your list...
Use The EXACT Function To Force Upper Case Data Entry Into Excel
Hello Excellers, a warm welcome back to another #formulafriday blog post. in my 2019 series. The Excel formula tip today is a recent favorite of mine at the moment, trying to get users to enter...
MS Excel Tutorial- How To Show Formulas In Excel With A User Defined Function – Formula Friday
It sometimes it is really useful to show your Excel formulas on your worksheets. This gives an insight into the logic of the worksheet. It also is a great way to check your formulas to ensure...
I really do not like the way when you create a Pivot Table and add multiple fields to the Row or Column Label areas, subtotals are shown at the the top for outer fields. This just does not sit well...
Excel Tip -Escape The Dancing Ants Around A Cell With One Tap
This is a small tip but a good one......Yes I called them dancing ants in the title of this tip but I am actually talking about the marquee that is around copied cells. If you want to quickly get...