Top 3 reasons for your Excel formula showing in a cell and not the result
So, hello Excellers, welcome back to another #Excel blog post in my #FormulaFriday series for 2020. Today I want to share a question that came up (again) this week. A regular enough question. ...
Formula Friday – Insert The Current Filename And Path In A Cell Using the CELL Formula
So, hello Excellers, welcome my first #FormulaFriday #Excel blog post in my 2020 series. Welcome if you are new to my blog and welcome back if you are a regular reader. Today let's look at a...
Formula Friday – Calculate Only Some Of Your Workbook’s Formulas
Hello Excellers and welcome to another #Excel #formulafriday blog in my 2020 series. Today I want to address an issue that happens a lot with Excel workbooks that have become too large and...
Macro Mondays – Create A Shortcut To Your Personal Excel Macro Workbook
Hello Excellers, welcome back to another #MacroMonday #Excel blog post. Today I will show you how to create a shortcut to your Personal Macro Workbook in Excel. Creating a shortcut to the personal...
Macro Mondays – Create A Simple Excel Macro To Delete All Named Ranges.
Hello Excellers and welcome to another #MacroMonday blog post in my 2019 series. I think that today's Excel VBA macro is a really useful one. I hope you find it cool too. If you have a lot of...
Hello Excellers and welcome back to another blog post of #ExcelTips in my 2019 #FormulaFriday series. Today let's look at 4 ways to convert cells with formulas to values. So you are probably thinking...