Formula Friday – How To See Values And Formulas On The Same Spreadsheet At The Same Time
HDo you ever need to view formulas and values in Excel an spreadsheet at the same time?. For example, maybe you're trying to troubleshoot a formula or curious about how Excel calculates a particular...
Hello Excellers, welcome to another blog post in my #Excel tips series. If you're an Excel user, you probably know that you that as you create a workbook, information is stored within it. This...
Formula Friday – Need To Test Your Formulas? It’s Easy Just Hit F9!
Hello Excellers, time for some more formula fun. If you're an Excel user, you know that formulas are the key working smart with Excel. But what happens when you're not sure if your formula is...
Welcome back, Excellers. Welcome to another #MacroMonday in my Excel series. As an Excel user, you may be wondering how to prevent other users from printing your workbook. This can be a helpful...
Hello, welcome back for another #Excel tip. Today, let's look at how to use Custom Sorting in a pivot table. Custom Excel pivot table sorting is one tip I use regularly. So I wanted...
Macro Mondays – Print Only Specified Worksheets In My Excel Workbook
Welcome to another #MacroMonday in my series. Have you ever needed to print only selected worksheets from within your Excel workbook? Maybe you want to keep some of your data hidden from view, or...