Hey there stranger!
Sign up to get access.
Learn to Love Your Sheets
About this Tutorial
00:12 We're gonna, we're gonna know how to make Google Sheets you love to work in. This is a combination or a conglomeration of a few other videos and I'm gonna give you some quick tips on learning to love your sheets.
00:27 It could also be called Your Sheets. Don't Have to Suck, but I didn't call it that. That's not the title of this video.
00:34 Learn to Love Your Sheets is the title. But first let's talk about form and function. Typically, form is how it looks and function is how it works.
00:45 But in Google Sheets, unfortunately or fortunately, these two things are combined. We have both design and usability. If it looks good, it works good.
00:56 If a Google sheet is well useful, it is designed well. So just a little weird thing about spreadsheets is that our front end and back end middleware is all the same.
01:11 We type in Google Sheets, we use Google Sheets, we use the spreadsheets, we use Rose columns. There is a bit of because this is a good thing actually, that design and usability and form and function are all in the same place.
01:24 Any thing we do to make it look good is going to make it work well. But there is a bit of oppression here.
01:34 A bit of a fascism of spreadsheets you could say. And there's an oppression of spreadsheets. The very first standard spreadsheet you use, if you just go to sheet.new, you can go to sheet.new and create a brand new spreadsheet.
01:49 It is always going to be the same thing. It's going to have a default font of aeriel. It's going to have the whitest white background, the blackest black text.
01:58 It will be thousand rows. It'll be 26 columns, A to Z. It is a spreadsheet and it'll always look like a spreadsheet, but it doesn't have to stay that way.
02:12 His high contrast we almost always do this thing where we have headers here, like status and name and first name, right?
02:23 And we almost always, whenever we say, Hey, we gotta highlight that header, it's always this like top row of, of colors, background colors.
02:33 So our headers are always bright. And I gotta say, I really think that Ariel is bad for your health. I think the more we see Ariel, the more we hate our spreadsheets.
02:42 So there is an pressure to spreadsheets, and this video is really gonna go into getting over this oppression. What can we change?
02:50 What is within our power? What are we empowered to be able to do? How can we change this? How can we take control back over the oppression of spreadsheets?
03:01 How can we fight the oppression, fight the fascism? How can we do that? Alright, here's a few tips. So first, let's fight the contrast.
03:09 That's the, that's the first thing we do. And my favorite way to do this is to change the text literally all over the text.
03:17 Let's get rid of this header. First off, I just wanna get rid of that. We are gonna change the text color to custom color.
03:26 We're just gonna type in 4 44, That's it. 4 44, boom. That's all we have to do. It doesn't look that different, but it is, it is just a little bit lower contrast.
03:38 Same with the background. We're gonna increase the, the hex code from, from the bottom. And what we're gonna do, we're gonna choose a little bit of a beige paper ish.
03:48 It's not really beige, it's more like paper, Facebook, Facebook, fb, fb, F eight, Fate, Facebook, Facebook, Fate 4 44. That's all you have to remember.
03:57 It's a bit yellowy. Now what this doesn't look like a big difference and it's not, In fact, it, you will know it's different.
04:07 Your shapes will look different, they will feel different. And the reason is cuz it's less contrast. So that's the first thing.
04:14 And now we're headers because we have this sort of beige less contrast. We don't have to use the brightest bright.
04:21 We can use a very pastel, very late, the lightest light header. That's what I would recommend. Get over that. High, high contrast.
04:31 All right, next up we can u we can get a better font than Ariel. Here's five fonts that I particularly like.
04:41 Carla is my main go-to girl or font. I love it. I think it's amazing. If we don't have it, you can look in the Ks.
04:53 Carla, there it is. If you don't have it, what you can do is go to more fonts and you might have to search for it.
04:59 Yeah, there is Carla. So you just select it, make sure it has a checkbox check mark, and then you can change your text to Carla.
05:06 And I absolutely adore this font. I like to make it a little bit bigger. If you're looking specifically for, and, and cabin is a different a slightly different one too.
05:18 We can copy and paste this and see what cabin looks like. Let's look at the cabin. I like cabin as well.
05:24 I think cabin looks great, feels different than Ariel. But if you're looking specifically for a header type of font, I would suggest Oswald, o s w Oal Wall.
05:42 Why I say this is why it's good for headers is because it is a thinner font. It's bold. First off, it's a bit bolder than normal and it's a bit thinner.
05:52 So you can actually have bigger words in the header there than you normally would. To go the opposite way. There is Comfor, I don't know how to really pronounce this com, Comforta two a's it is a bigger font.
06:09 So Oswald is sort of a small font or a thin font, and Comfor Comfor is rounder. It's really fun. Speaking of fun, I do actually recommend Comic Sands in this particular way.
06:24 Let's look at it. Let's look at comic sands. Let's see. Comic Sand Ms right there. Ooh, why I recommend Comic Sand or how I recommend it is give it space.
06:34 And this is getting into next section a little bit. Give your column some space. Get your rose, resize your rows.
06:44 We can, we gotta click over here. We gotta click. There we go. Resize rose. Ah, we gotta select it. Come on.
06:57 All right, this loom recording really screw me up. All right, we gotta resize this row. We don't want to fit the data.
07:04 We want it like 35. Nope, we want it way more like 50. But when we give comic sands some room to breathe, it is wonderful.
07:16 Beige backgrounds. It is great. It doesn't really look like comic sands anymore. It doesn't look that bad, especially for headers.
07:26 All right, get out of, get out of the comic sands funk. Don't worry about comic sand. Got four other suggestions that are better than Ariel.
07:34 Next one, ways to fight the frame, the fight, the frame, the fascist frame of oppression. Alright, we can merge cells.
07:43 So instead of just leaving sort of every column and every row there, we can also merge. And it's a quick little thing here.
07:51 We do want to get rid of that. We can merge row, we can merge cells, we can merge rows, we can merge columns, merge all over the place.
08:02 I love merging. And this gets, its out of that funk of every row in every column. Next up, we can resize, as I just showed you here, resizing really, really helps.
08:13 Get rid of this, this fascist, fascist frame. Increase the size of the row. Don't, you don't have to increase the size of the font to go with that.
08:26 You can keep the font smaller. It just gives it breathing room. A lot of design is gonna just give, give these words space.
08:34 Give them space. One way I won't show you here, but I'll just suggest it, is insert round images. If you ever put in a logo or something, actually I have another video about inserting a logo or a icon of a company inside of a Google sheet with just a url.
08:49 It's really fun that the domain name go check out that video. But insert round images when you get a chance, look at the, look at the image around or the, the frame around my face here.
08:59 It's circle. It changes the shape of the entire screen. And, and I really, really like that. All right, next up.
09:06 And the last part is fight the impression of tabs and sheets. Okay, so when, whenever we have a header we usually will freeze that.
09:19 What I recommend is when you freeze a header underneath it, you can put instruction. So some, I have a whole video on this about better headers.
09:31 Go watch that video and it goes into this. If you don't need to sort your sheet, if you have sort of a static sheet, this is great.
09:39 Add some more information underneath so we don't have thick, big headers. We can keep your headers small and put some more information here and then have your data here, Data one all the way down, right?
09:52 And if you have this Merl and you have some like extra information here, there. Once you scroll up, now you have all of the frames.
10:05 So you're not sort of pushing everything down. And that's in the better headers video. Go watch that video. Now if you wanna grab information from say sheet one and put it on sheet two.
10:17 First thing you're gonna think about is just copy and pasting, right? But you don't have to do that. We can use array formula equals array formula and we're gonna do sheet one C C and we can get that data.
10:33 Now why does this cool is because if we copy paste, we might want to copy paste values just to get the values.
10:41 But if we change any of the data, data number to it, it's gonna update here. See, this copy paste values doesn't update.
10:54 It's in the same format. That format doesn't update, but that data doesn't update either. So that data's gonna update. I love it.
11:02 And I love taking one piece or one row or one column of data and moving it to another data in instead tab instead of moving it using it somewhere else.
11:14 Really, really like that gets us out of like having to insert a row here or column and add some extra information here.
11:22 And it gets all outta whack. You can just use array form. You can also use import range. I recommend not doing this within a sheet, a spreadsheet file.
11:32 Do try to use a different one, but you can also just use the same exact file. We're gonna use sheet.
11:43 Same one we did before. Sheet one, exclamation mark. C C. It's a little, we have to allow access. It's a little more steps, but Gives you the exact same information.
11:56 Data number five. And it will update once we see it. It takes a little bit moment. So hopefully this was a fun video for you to fight.
12:06 The oppression of spreadsheets. We fought high contrast, we fought aerial, we fought rows and columns, and we fought the oppression of tabs and sheets.
12:16 Hope you enjoyed it and I hope you learned to love your Google Sheets. Watch more videos here on Better Sheets.
12:22 Enjoy Google Sheets once again. Hopefully you learn to love Google Sheets. Bye.
Better Than Happy | Redesign of The Feelings Wheel
How Starter Story Designs Data
Learn to Love Your Sheets
Best Header Font Ever
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
Create Drop Shadows! This makes your dashboards pretty.
Merge Cells for Dashboards
10 Things I Hate About Your Spreadsheets
Dark Mode / Better Font Color
Better Font Colors
Magical Things You Can do with Checkboxes in Google Sheets
How To Export Your Beautiful Sheets to PDF
Consider Labels as Opposed to Headers
Add Icons To Your Sheets With a Domain Name
How To Color Cell Blocks So Others Enter Data Easily
Great Sheets! Corona Hiring Sheet
Great Sheets! Community Information Board by Seedtable.com
Roast: Hotel PPC Channel Cost Calculator
Better Header Fonts - Best Fonts To Use In Google Sheets
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell
Basic Keyboard Shortcuts To Speed Up Your Productivity
Basics - 5 Ways to Change Row Height
Anders Asks: Can I Highlight Whole Row if Certain Columns have text?
How to Refer to Other Cells - A1 and R1C1 Explained
Change the Default Font
Biggest Flaw In Dashboards with Dark Colors
Basics - 4 Ways to Change Column Width
Basics - Structure of a Sheet: Index() Row() and Column()
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
Use Cmd + Y To Do It Again, and Again, and Again
Create an Auto-Update Sales Chart: Trailing 12 Months
Google Sheet Basics - The Absolute Basics
Secure Your Sheets by BetterSheets.co
How To Create An AutoFill in Google Sheets
Build a Thermometer for Savings Goals
Make Your Lists Spicy Hot in Google Sheets
Restrict Access to a Cell if Another Cell is Blank
How to Use Smarket
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!
Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!