Office Scripts – Sort sheets alphabetically

In this post, we are covering how to sort sheets alphabetically using Office Scripts. Actually, the final code will be flexible enough to sort sheets in many different ways. I’ll share the basic script, along with the steps to create a more dynamic and robust solution. By the end, we will have a script that Read More

Office Scripts – Hide all sheets except one

In this post, we’ll cover the Office Script you can use to hide all sheets except one. I’ll share the basic script, along with the options to change the code to your requirements. Since Power Automate can use Office Scripts, I will also share the reusable code block to use with dynamic flows. Example Office Read More

Why does Excel’s calculation mode keep changing?

You’re probably already aware that Excel has two main calculation modes: automatic and manual. Automatic calculation – calculates when a value changes or based on specific actions (inserting, deleting, hiding rows/columns, or renaming a worksheet, etc.). Manual calculation – only calculates when explicitly requested by the user: From the ribbon, click Formulas > Calculate Now Read More

Office Scripts – Workbook & worksheet protection

As Excel users, we often find ourselves protecting and unprotecting worksheets and workbooks.  While Excel’s protection is not perfect, it does prevent others or even us from accidentally making changes.  It can be as simple as one keystroke that turns our worksheet perfection into an error-filled disaster. Unfortunately, protecting and unprotecting is an enormous time Read More