Write Apps Scripts to save time formatting multiple sheets with column width, alignment, etc.

Google Sheets Tutorials · Intermediate ·🛡️ AI Safety & Ethics ·2y ago

About this lesson

@redtailfanschool In this video I demonstrate some scripts that saved lots of tedious formatting time. We remove merged cells. replace text, set column widths and vertical alignment, remove then set conditional formatting of a range and set background color of a row based on a cell content. Link to Doc with Scripts: https://docs.google.com/document/d/1mrD5WITWhdziXoFEBJamTzmf-Jnj30cbB0x8Cg_bw0w/edit?usp=sharing

Original Description

@redtailfanschool In this video I demonstrate some scripts that saved lots of tedious formatting time. We remove merged cells. replace text, set column widths and vertical alignment, remove then set conditional formatting of a range and set background color of a row based on a cell content. Link to Doc with Scripts: https://docs.google.com/document/d/1mrD5WITWhdziXoFEBJamTzmf-Jnj30cbB0x8Cg_bw0w/edit?usp=sharing

Watch on YouTube ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

Related AI Lessons

Your ChatGPT History Is a Liability. I Fixed That With a $80 Chip and a Pi5.

Protect your ChatGPT history from being used as evidence with a simple hardware solution using a $80 chip and a Pi5

Your Skepticism About AI Is an Asset. Here’s How to Use It.

Learn to leverage skepticism about AI to improve its adoption and implementation in your team and organization, and why it matters for responsible AI development

Medium · Programming

The Dark Side of AI: What We Lose When We Stop Thinking

Discover how AI's benefits come with a cost to human critical thinking skills, and why it matters for professionals to be aware of this trade-off

AI Security Isn't a Product. It's an Engineering Discipline.

Learn why AI security requires a continuous engineering discipline rather than a one-time product implementation, and how to apply this mindset to your AI development workflow

How Finance Professionals Can Use AI Safely

The Cutting Edge School