Hey Excellers. Today I will show you how to use the Find and Replace in Excel. Specifically to replace exactly only the values you need to. This blog post is in response to a question a...
Category: Quickie Tips
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,...
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...
Excel Tip – Identify All Cells In A Worksheet With Conditional Formatting
Don't forget to sign up to the Excel at Excel Newsletter for 3 FREE Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below. You will also...
Formula Friday – Highlight Overdue Tasks With Conditional Formatting And A Logical Formula
Have you started the New Year with some new good habits, maybe you are tracking your To Do or Task List in Excel (why wouldn't you?). Here is a great way to highlight overdue tasks, using...