Macro Mondays – Convert A Range OF Cells To ‘Proper’ Case With An Excel Macro
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 macro series. It is time to sit up. We will be using the Proper Function today!. You may (or may not) know...
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...
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...
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...
Macro Mondays – A Simple Macro To Refresh All Data Connections When Opening An Excel Workbook
Happy Monday!, and it is Macro Time. Welcome to another #MacroMonday #Excel blog posts in my 2020 series. Today we will write a simple macro to refresh all data connections when your 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...