Hello, Excellers. Today's blog post is a coffee break quick Excel tip for you. So, I was recently asked how to make Excel worksheet tabs stand out by changing their tab colour. In particular,...
Category: Excel Tips& Tricks
Defer Data Updates In Your Excel Pivot Table. – Pivot Table Tip
Hello, Excellers. Today I want to show you a really quick Excel Pivot Table tip that might be very useful for you if you are updating or making changes to a large Pivot Table. You may already...
Formula Friday – How To Count Formula Errors On An Excel Worksheet
Happy Friday and time for some more #formulafun on a Friday!. I recently was asked to find a way of knowing how many errors ( if any) were in an Excel worksheet. I came across this quick and easy...
How To Apply Conditional Formatting To An Excel Pivot Table – Correctly – Excel Tip
This next tip I know causes a bit of frustration with Excel users, based on the number of times I have been asked about it. It is applying conditional formatting to a Pivot Table. The method of...
Excel Tip – How To Print Your Excel Worksheets Without Colour
Hi Excellers. I want to share a great Excel tip with you that I use all of the time. Especially as I receive a lot of workbooks and worksheets that need to be printed. Some of which contain a...
How To Control When Excel Warns You About Large Scale Cell Changes. Excel Tip
Picture this. You are about to make changes to a lot of cells on your Excel worksheet. Maybe you have updated a lot of formulas, or pasted a lot of new cell contents?. Excel sometimes warns...