Academy ↓
Hey there stranger!
Sign up to get access.
Basics - 5 Ways to Change Row Height
About this Tutorial
Video Transcript
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.
Courses
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