Fab Sheets · Lesson 39 of 43

Make Your Lists Spicy Hot in Google Sheets

Members-only tutorial

Watch the video and get the practice sheet with membership.

Unlock tutorials
Practice sheet Copy sheet Preview Open Sheet resources unlock with membership.
Create fun funky bullet points to get your point across better. Put emojis in your sheets to bring them to life.
16 formulas linked inline Click any highlighted terms to learn more.

<div> Hey, sheet shakers. It's big sheeter here, Andrew. And I just wanna sort of show you something that's really cool. Is these using emojis as bullet points. How I do it is literally just copy paste from emoji pd. Pd. That's weird. And then a couple things to make 'em look way nicer. I. Format them so that they are to the right and format the text or line the text to the left so that they all match up and then oops, did something weird there.<br><br>And then this is like a really cool implementation that I saw in another sheet where instead of doing a header , like usually it. Sheet Makeover - Google Ad Writer Gmail Declutter Engine MESSIEST SPREADSHEET MISTAKE

Up here, right? We can create this really big block and I, I merge all of those rows vertically. And so now we have this really nice, like left to right align not alignment, but like hmm, what you call it sort of just aligns the eye to say, Ooh, sparkle over here.<br><br>Like it. It takes in both. We, we read up and down, but we also read left to right. I think it makes a really cool way to break up a list and then adding some white space in between these groups. And then the second part is that I. Do a little bit higher row height over here. 150 VCs Actively Investing by Lemon.io Think about MIDDLE vs CENTER Alignment!

Let me move my face over here.<br><br>I c I add a little row height and that gives it a little white space around each of these items. Obviously I do view. And then click on the grid lines, so it's actually hiding the grid lines and they look really, really nice. Hopefully this helps you make some cool lists in Google Sheets.&nbsp;</div> Hide Gridlines Gmail Declutter Engine How To Change Gridlines For Entire Google Sheet

Better Than Happy | Redesign of The Feelings Wheel Best Header Font Ever Learn to Love Your Sheets How Starter Story Designs Data Sheet Review! 150 Active VCs by LemonIO Anika Asks: How To Set Text Overflow All The Time Introducing: Brutal Calendar Add a Checkbox to Turn on Dark Mode 00:05:10 Create Drop Shadows! This makes your dashboards pretty. 00:12:04 10 Things I Hate About Your Spreadsheets Merge Cells for Dashboards 00:05:29 Dark Mode / Better Font Color 00:09:35 Better Font Colors 00:02:45 Magical Things You Can do with Checkboxes in Google Sheets 00:12:31 How To Export Your Beautiful Sheets to PDF 00:04:06 Consider Labels as Opposed to Headers 00:04:02 Add Icons To Your Sheets With a Domain Name 00:04:21 How To Color Cell Blocks So Others Enter Data Easily 00:10:30 Great Sheets! Corona Hiring Sheet 00:10:43 Great Sheets! Community Information Board by Seedtable.com 00:07:35 Roast: Hotel PPC Channel Cost Calculator 00:11:25 Better Header Fonts - Best Fonts To Use In Google Sheets Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell 00:09:49 Basic Keyboard Shortcuts To Speed Up Your Productivity 00:13:44 Basics - 5 Ways to Change Row Height 00:05:08 How to Refer to Other Cells - A1 and R1C1 Explained 00:13:22 Anders Asks: Can I Highlight Whole Row if Certain Columns have text? 00:09:31 Change the Default Font 00:03:33 Biggest Flaw In Dashboards with Dark Colors 00:07:45 Basics - 4 Ways to Change Column Width 00:05:48 Basics - Structure of a Sheet: Index() Row() and Column() 00:06:49 Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets 00:08:55 Use Cmd + Y To Do It Again, and Again, and Again 00:03:03 Create an Auto-Update Sales Chart: Trailing 12 Months 00:09:57 Google Sheet Basics - The Absolute Basics 00:09:48 Secure Your Sheets by BetterSheets.co 00:11:07 How To Create An AutoFill in Google Sheets 00:06:07 Build a Thermometer for Savings Goals Make Your Lists Spicy Hot in Google Sheets 00:01:47 Restrict Access to a Cell if Another Cell is Blank How to Use Smarket 00:03:28 Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets! 00:06:23 Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement! 00:53:31