Hey there stranger!

Sign up to get access.

Basics - 5 Ways to Change Row Height

About this Tutorial

You can change the row height in 5 different ways in a google sheet. Consider adding padding around your text with more row height. and column width.

Video Transcript

 Hi. This video is to go over five different ways to change the row height. Why are we gonna change the row height? One of the reasons is just aesthetics. We might want to give some more white space, but also you might want to prepare your sheet, like if you know some sort of numbers and some mathematical styles you want I'll share with you one of these ways where you can very quickly and easily change it to your very saved expectations and specifications, what you want.

Two reasons why. But you're gonna run into a lot of way I'm gonna give you five ways to change it. And every single way has different use cases that you might want to use. So like for instance, you could just change the Font side. So if I just change the font size here, let me do this. I've already showed you all the ways, but if you, this is the default.

If you have a row here and you change the font size, I default, the row will get wider. This is probably the most inherent way or less clicking way. You're changing the role, the font Anyways. But what's gonna happen is you might want to change it more as you change your height. And the other second way you can change it is literally going over to the row.

The little space between the row. Make sure your arrow actually changes from an arrow to an up arrow. And now you can click and drag the row height. And this is a great way to give white space to your headers maybe, or even to, to your data. So give more white space. Then you might even want to change over here, go to the middle.

And let your data go into the middle there. So that's two ways. Change the font size or click and drag. Next way is you can right click or control, click on a row and click on resize row. And here we can actually choose the pixels. As you see, it says default is 21, or you can fit to data, which is the, so the default is 21.

And then default is we fit. But if you know mathematically I want 30 pixels, you go, okay, and now you know what 30 pixels is. You can do the same thing over and over again, and you can say, for all these rows, I want it 30 pixels for these rows. I know I want to set it to 60 pixels. I want these rows to be exactly double these for some reason, right?

For different use cases. Maybe you want to put data here and put different headers up here, or information than headers and categories. The next one is something you might already know, but you might have just figured it out by accident. If you go to the bar between a row between two rows and double click, it will automatically fit to the data.

So even if it's too much it'll shrink if it's too little. It'll expand. So if it's too much and it'll go to the default and you can do that. I like doing that a lot because it saves me a lot of clicking, dragging, figuring out what is the right way. I can also click multiple, and it won't do all of them exactly the same.

It'll do them each to their own data. If it's blank, if there's a blank one, it'll be set back to the default. So we can see here should be. 21. There you go. That's default. So that's what it two, when it has no data in it. And the last way to change the row height is once, if you have say two or three rows that you don't want to change the entire row, you only wanna change a little bit.

So for instance, if you have some data in a table that you want to go, Bigger, but you don't want the entire table to get larger. What you can do is merge your cells. And so something as simple as this can merge cells. And now this row is essentially four times higher than this, and that will get you a, this cell block here is four times higher than any of these.

Let me see if I can show you better this way. So you can see that. And so this row, this columns, rows are higher than the other ones. That's a really cute way to do it if you have some different types of data you wanna share. That was five ways to change the row height. Hope you got something cool outta.


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!