Convert Positive Numbers To Negative Numbers Using Paste Special Trick
Hello Excellers, welcome back to another #Exceltips blog post in my 2021 series. I wanted to share this Excel tip with you as it really is a fast way of converting a list of positive Excel numbers...
Formula Friday – How To Delete Values From Cells But Keep Your Formulas In Excel
Hello, Excellers. Welcome back to another #ExcelTip blog post in my Excel 2021 series. It is time for a neat Excel trick today in today's #formulafriday blog post. I will demonstrate how to...
Macro Mondays – Convert A Range Of Cells To Upper Case With An Excel Macro
Hello, Excellers. Welcome back to another #MacroMonday blog post in my #ExcelTips series for 2021. You may or may not already know how to convert all text to upper case in Excel by using the UPPER...
Hello, Excellers. It is Friday and that means some more #FormulaFriday Excel fun right?. If you need to number your table rows sequentially then this is the Excel tip for you. So, if you sort...
Formula Friday – How To Highlight All Cells Containing A Formula In Excel
Hello, it is time for some more #formulafridayfun. Today I want to share with you how to highlight all cells containing a formula. It is a question a colleague asked me this week. It was a great...
Hello, Excellers. Welcome back to another #MacroMonday #Excel blog post in my 2021 Excel series. I love this macro. I really do. It is great to have it to hand when needed. This small bit of code...