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

Office Scripts – Working with worksheets

Some of the most common Excel automation actions involve managing worksheets.  Now that we have Office Scripts as an automation tool within Excel Online, it’s time to learn how to use worksheets within this new environment. If you have written VBA Macros before, many of the principles will transfer directly to Office Scripts.  There is Read More

How to split cells in Excel

There are many circumstances where we receive information with multiple data points inside a single cell.  This often occurs when the data’s original intention is slightly different from how we intend to use it.  In these circumstances, we often need to split the cell into its constituent parts.  This post will look at solving this Read More