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...]
Drill Down Option In Excel Pivot Table.
Hello, Excellers. Welcome back to another #Excel Tip blog post. This Pivot Table blog will take you through the Drill Down feature in Excel Pivot Tables. When you create a Pivot Table in Excel, each of the values represents one line of data or record in that data set. The Pivot Table creates a summary of your data set. Let's use an example in this blog post. You can download the sample data set and Pivot Table, by clicking the download button below. I have a very simple data set and … [Read more...]
- 1
- 2
- 3
- …
- 47
- Next Page »
Recommended Excel Resources
