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...]
How Find and Replace Exactly In Excel
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 colleague asked last week. They needed to find all cells that contained zero and replace them with a blank without affecting the zeros appearing in other cells. For example 100, or 1000. Only the cells that contained ONLY 0 needed to be replaced. The solution is really simple, as long as you know which … [Read more...]
- 1
- 2
- 3
- …
- 46
- Next Page »
Recommended Excel Resources
