Entering data into Microsoft Excel can be time-consuming for users. Especially if the cells that require data are spread all over the excel worksheet. The last thing you want is a user to the...
Posts by Barbara
Welcome, Excellers, to another Excel Formula tip in my #FormulaFriday series. Today let's look at rounding numbers down in Excel using the ROUNDDOWN function. I want to give a quick disclaimer here....
Macro Mondays – Unprotect Multiple Excel Worksheets At Once With A Simple Excel Macro
Happy Monday!!. Time for some more Monday Macro fun. I wanted to share this little but powerful Macro with you today, I used this myself just last week so thought you would like to have this in...
Macro Mondays – An Excel Macro To Count How Many Excel Workbooks are Open
Hello Excellers, time for another #macromonday blogpost. In this tutorial we will look at VBA and workbooks in Excel. If you're like me, you have a ton of Excel workbooks open...
Highlight Locked Excel Cells With The CELL Function. Formula Friday
Hello Excellers, and welcome back to another #FormulaFriday #Excel tip in my Excel series. Todays article walks you through highlighting cells on an Excel worksheet that are locked. As an Excel...
Macro Mondays – Change All Pivot Table Filters At Once With A Macro
If you have many pivot table with filters, applying changes to them all can be time-consuming. Fortunately, there is an easier way! Using a macro in Microsoft Excel, you can quickly change all the...