Hello, it is time for some more #formulafridayfun. Today I want to share with you how to highlight all cells containing a formula. It is a question a colleague asked me this week. It was a great question!. How can I see at a glance by changing the colours of the cells, my cells that contain formulas?. That would be a handy Excel tip, especially if you have a large worksheet and need to know at a glance. I found a really easy way to achieve this with a few clicks. Follow the instructions … [Read more...]
A Paste Special Trick To Convert A Number To A Percentage.
Hello, Excellers welcome back to another #Exceltips blog post in my 2021 series. Today let's look at using the Paste Special Function in Excel. Have you a worksheet with the % (percentage) formatting missing?. If you ever have tried to correct this then you know you could try to adjust the formatting of the cell. But, that just ends up looking like the screenshot below right?. Who wants to edit each cell with %?. Well, by using Paste Special we can … [Read more...]
Find Your Cells that Contain Formulas- Quickly
Hello, Excellers. Welcome back to another #FormulaFriday #ExcelTips blog post in my 2021 Excel series. Today let's take a look at how to quickly find your cells that contain formulas. Have you ever inherited a workbook? Have you ever been asked to update an Excel workbook?. Do you need to see which cells contain Excel formulas?. Also, do you need to quickly check the referencing of your formulas to ensure they are correct?. So, I would say that no-one wants to manually check each … [Read more...]
Understand And Debug Excel Formula Errors.
Hello Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2021 Excel series. We all get them from time to time those Excel formula errors that annoy us and drive us nuts. They also indicate to us that something is not working. So, it useful to know. Here is my guide to the main errors we seem to get and what exactly they mean. Once we understand these formula errors we can avoid them or put them right. Excel Formula Errors. The … [Read more...]
Macro Mondays – Running An Excel Macro From The Immediate Window
Hello, Excellers welcome to another #MacroMonday #Excel blog post in my 2021 Excel Macro series. Today let's take a look at using the Immediate Window in the Excel VBA debugging environment. This environment can be used as a type of scratchpad or sandbox area and has many uses as well as debugging code. You will need to first Enable The Developer Tab if it is not already enabled. You can watch my YouTube Video for instructions. https://youtu.be/CYcyoBMTZ44 If you … [Read more...]
- 1
- 2
- 3
- …
- 47
- Next Page »
Recommended Excel Resources
