Office Scripts – Sort sheets alphabetically

Office Scripts - Worksheets

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 – Reverse number signs

Office Scripts - Worksheets

We often need to reverse number signs in Excel.  For me, this regularly occurs because the accounting signage for debits and credits is opposite to the signage of income and costs.  I am sure in your chosen field there are plenty of scenarios also.  Using native Excel functionality, there are plenty of ways to change … Read more

Office Scripts – Workbook & worksheet protection

Office Scripts - Worksheets

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

Office Scripts - 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

Excel VBA for Pivot Tables

VBA Code Snippets

Pivot Tables are a key tool for many Excel users to analyze data.  They are flexible and easy to use.  Combine the power of Pivot Tables with the automation of VBA, and we can analyze data even faster.  This post includes the essential code to control Pivot Tables with VBA. Table of Contents Refreshing Pivot … Read more

INFO function in Excel

INFO Function in Excel - Featured ImageINFO Function in Excel - Featured Image

The INFO function in Excel returns information about the current operating environment.  In total, there are seven pieces of information available: Table of Contents The arguments of the INFO function Argument options Basic usage Examples of using the INFO function Display system information Display warning messages Insert line breaks with CHAR function Conclusion Download the … Read more

CHAR function in Excel

CHAR Function Featured Image

The CHAR function in Excel returns a specific character based on a code number from the operating system’s character set. Each operating system has it’s own character set: The character set contains the primary printed and non-printed characters available on a computer.  Those characters can be letters, numbers, punctuation, symbols, and even characters that are … Read more