Hello Excellers welcome to another #MacroMonday #Excel blog post in my 2020 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 areas and has many uses as well as debugging code. If you cannot see the Immediate Window, you just need to enable it. It really simple. Open the Visual Basic Editor View Immediate Window Or if you are mad for shortcuts, then you can do the … [Read more...]
Formula Friday – Count How Many Numbers In A List Are Greater Than The Average Using The COUNTIF Function.
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 are greater than the average. This is a useful formula solution using the COUNTIF Function. It can be used to answer a number of questions such as HOW MANY? students scored higher than average employees are paid higher than the average sales reps made sales higher than the average The … [Read more...]
Formula Friday – Quickly Switch From Cell Values To View Formulas – An Excel Shortcut
Happy Friday Excellers!. Welcome to another #FormulaFriday #Excel blog post in my 2020 Excel series. I have a great tip for you. It is really short, but it allows you to quickly toggle between looking at your Excel cell values and view formulas in those cells. I use this on a regular basis, just to check the continuity of my formulas. Switch From Cell Values To View Formulas. It's super easy all you need to do is hit CTRL+' (The 'Grave accent key is is below … [Read more...]
A Super Quick Way To Unprotect Multiple Excel Worksheets
Hello Excellers, welcome back to another #Excel tip in my 2020 series. Today I will show you how to unprotect multiple Excel worksheets really quickly. Have you created an Excel workbook with multiple Excel worksheets that are protected and then at a later date have to unprotect each worksheet individually?. Maybe you need to update your formulas?. For example, I have a number of reports that have 15+ worksheets. All of those worksheets are protected. Do I need to manually go into each of … [Read more...]
How To Start Excel in SAFE MODE.
Have you had or are having issues with Excel? If indeed you are having issues it may be due to some files or Add Ins that are loaded as Excel starts. In order to troubleshoot or test this theory then the best way forward is to start Excel in SAFE MODE. It is a really simple process. How To Open Excel In Safe Mode. Ensure that no sessions of Excel are already running on your machine. If there are sessions, close out of them. Display the search box on your machine. I am using Windows … [Read more...]
- 1
- 2
- 3
- …
- 46
- Next Page »
Recommended Excel Resources
