Formula Friday – Using Keyboard Shortcuts To See Precedent or Dependent Cells In Excel
Today let's look at how to use Excel keyboard shortcuts to see Precedent or Dependent Excel cells in an Excel workbook. I use these two commands to easily audit my Excel formulas. Cells that are...
Macro Mondays – Print All Sheets In An Excel Workbook – With Specified Exceptions
It's that time of week for some Macro fun, I love starting off the week with some code!. In Macro Monday last week we looked at printing specified worksheets in an Excel workbook, which in itself...
Macro Mondays – Select And Format All Cell That Contain A Formula In Your Excel Workbook
Hello Excellers, I want to share with you a handy Macro that I use regularly. Do you ever have a worksheet where you need to format every cell that contains a formula? It can be a tedious task if...
Formula Friday – Whats The Difference Between An Excel Formula and A Excel Function?
Let's get back to basics today in #formulafriday and discuss something I am asked quite frequently about...... What is the difference between a Formula and a Function in Excel? If you use Excel as...
Hello Excellers, Friday again and I have a really quick, easy and really useful way to use named ranges you have already created into your formulas. If you need more details on creating named...
Macro Mondays – Moving And Undocking The Immediate Window In The Visual Basic Editor
Hello Excellers! Welcome back to another installment of Macro Monday. In this post, I'll be teaching you how to make the VBA Immediate Window in Microsoft Excel a bit more user-friendly and...