Fab Sheets

Don't stand for ugly spreadsheets. Fab sheets shows you how to design better within sheets. where info goes, how it is displayed, fonts, colors, borders, etc.

Tutorials

Better Than Happy | Redesign of The Feelings Wheel

Turning an infographic into a useful Copy Writing cheat sheet

Beginner

Best Header Font Ever

Learn about "Oswald" the best font for headers. You might fall in love w...

Beginner

Learn to Love Your Sheets

Quick intro to a better experience of using Google Sheets

Beginner

ARRAYFORMULA() IMPORTRANGE()

How Starter Story Designs Data

Learn how Starter Story, and Pat Walls, created a report that is well de...

Beginner

Sheet Review! 150 Active VCs by LemonIO

This lead magnet by the folks at Lemon.io is incredibly useful. 150 acti...

Anika Asks: How To Set Text Overflow All The Time

Learn to set text wrap, overflow, or clip. Great for designing better te...

Intermediate

Introducing: Brutal Calendar

A calendar template designed like early Craigslist. A brutalism minimali...

Beginner

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark ...

Conditional Formatting Beginner

Create Drop Shadows! This makes your dashboards pretty.

Add extra pizzazz. a little more snazz to your sheets. Make dashboards w...

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a ...

Conditional Formatting Data validation Beginner

IF() ISBLANK() ISEMAIL() ISURL()

Merge Cells for Dashboards

to make better Dashboards consider merging cells.

Beginner

Dark Mode / Better Font Color

While the desktop version of Google Sheets does not have a dark mode, do...

Intermediate

Better Font Colors

While this advice and all well and good, try out Sheet Styles, a free Go...

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sh...

Data validation Beginner

How To Export Your Beautiful Sheets to PDF

Want to create sleek, stunning PDFs from your Google Sheets? Look no fur...

Beginner

Consider Labels as Opposed to Headers

A quick video to share with you this theory. Consider repositioning your...

Add Icons To Your Sheets With a Domain Name

Add visual flair to your Google Sheets when sharing company domain infor...

How To Color Cell Blocks So Others Enter Data Easily

Use neon blue to show where someone needs to enter data.

Beginner

Great Sheets! Corona Hiring Sheet

Reviewing a Corona hiring sheet. A great example of using Google Sheets....

Great Sheets! Community Information Board by Seedtable.com

Incredible design and inspiration for us in our sheets.

Roast: Hotel PPC Channel Cost Calculator

I have no idea what to do as a user, so let's make it better.

Intermediate

Better Header Fonts - Best Fonts To Use In Google Sheets

Find out what fonts to use to make your headers better.

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And y...

Conditional Formatting Intermediate

Basic Keyboard Shortcuts To Speed Up Your Productivity

We're gonna talk about some of the most basic keyboard shortcuts that in...

Beginner

Basics - 5 Ways to Change Row Height

You can change the row height in 5 different ways in a google sheet. Con...

Beginner

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.

Beginner

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Yes, using conditional formatting we can do this.

Conditional Formatting Beginner

Change the Default Font

Set a different default font for each sheet you open.

Beginner

Biggest Flaw In Dashboards with Dark Colors

An optical illusion in Google Sheets and how to fix it.

Basics - 4 Ways to Change Column Width

you might actually find something new and interesting about it. We're ju...

Beginner

Basics - Structure of a Sheet: Index() Row() and Column()

Let's figure out how a sheet is structured.

Beginner

COLUMN() INDEX() ROW()

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with...

Beginner

Use Cmd + Y To Do It Again, and Again, and Again

Very quick interesting little keyboard shortcut where you might not even...

Beginner

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12...

Intermediate

COUNTA() IF() INDEX() ISBLANK() SUM()

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Secure Your Sheets by BetterSheets.co

tactics on how to keep your sheets secure.

Beginner

ARRAYFORMULA() FILTER() INDEX() MATCH() MIN()

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

INDEX() MATCH() VLOOKUP()

Build a Thermometer for Savings Goals

Track your goals with a thermometer.

Intermediate

CONCATENATE() IF() REPT() ROUND() SPLIT() +1 more

Make Your Lists Spicy Hot in Google Sheets

Create fun funky bullet points to get your point across better. Put emoj...

Beginner

CONCAT() ROW()

Restrict Access to a Cell if Another Cell is Blank

Having trouble with ppl filling in cells before other cells?

Data validation Beginner

ISBLANK() NOT()

How to Use Smarket

This video covers how a user would use Smarket to list items to be sold ...

Beginner

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

Combine Databases and Backup Your Information Effortlessly - Learn how t...

Intermediate

IMPORTRANGE()

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Turning a drab sheet into a fab sheet. Transform your job search with th...