Hey there stranger!

Sign up to get access.

Basics - 4 Ways to Change Column Width

About this Tutorial

you might actually find something new and interesting about it. We're just changing the column width.

Video Transcript

 Hello, welcome. This is another basics video. Just going over something that I think is rather basic, but you might actually find something new and interesting about it. We're just changing the column with, I know this sounds really simple, but there's actually four ways to do it, and I'm gonna show you right now.

So, One is you can click and drag the, any of these borders of these columns. You can click and drag 'em and, and change the width. But you can also double click on the right side. So if I want to change the C column I can double click and it'll automatically go to the longest text. So say you had like a bunch of different, different ones here and you can just double click on them.

But what's interesting too, here, let's undo that. If I click, if I ho select three and I double click on that border, it will automatically make all of them not the same size, but go to the.  widest possible text in each column. That's a really easy way to one. Well, here's two reasons I like this one. By double clicking here, one, I find out like if, if I'm working on like URLs and trying to shorten them or something, I can double click this and it'll automatically go to like this really long thing.

And I know, oh, okay, well I missed a couple or something. Also, . What's really good about it is if I know you, What the width should be. I can, and they all should be just exactly this, the, not the same width, but exactly the width of the text in 'em, then I can do that. But most of the time I really do want to.

select a few of them and just visually give them all the same width. That tends to be just visually the most appealing. If you give all of, like, say you had these three, even though this full name is going to have more text in it , visually appealing way to do this is just to have a similar width to all of them.

It really lines everything up really nicely. And then the other way to do it, oh, this is actually you just right click and you can go to precise column. So if I'm on a row, it won't work. But if I'm on a co, if I'm on a. . See, it doesn't say, it says delete row, clear row, resize row, but on a column I have to select the column and then right click or control.

Click. If you're on a Mac without a right click. And here you go, resize column. But then you get this, you get fit to data, or you can enter the number of pixels. You'll see here it says default is 100, so if you want double the default, you can take 200. This also works on multiple, so. All of these right click, we'll say resize columns, we'll go.

Let's double it. Cool. And then they're all doubled. And the last one is sort of a hidden user experience. I would say this. You can copy and paste the column and you'll also copy and paste the width. So let's do this. Let's make all of these. Shorter if I copy this and paste it on e see the column with changes you can also do something like this

Okay. So if I want to say, say this is like a different type of text and it has a bunch of, of information in it, but I don't want to, I, I want the same width and I want it exactly the same way. I don't want to have to go like right.  size column. Okay. That's 61. Okay, I can do this then I can size column 61.

That's a lot of work, right? Just for a, for, just for a width. So what you can do is copy, I'm doing command C, and then instead of pasting the entire column, you can do right click piece special. And you can do paste format only. And obviously that'll also bring in the tech text information, any like formatting in the cells below it.

But also it, it also just paste the, the, the, the width of the cell so you can actually copy and paste. The actual cell column, or you can copy and then paste only the format. So in a variety of situations, knowing all of these ways to change the column with will help you make more, be a better visually appealing spreadsheets, especially if you want to make them very iconic.

Like you wanna formulaic, like if you wanna say, okay, this column's gonna be 50 pixels wide, this column's gonna be 200 pixels wide, four x, and then 800 pixels wide. And it's like, okay, we have three. We have ID number, title and description, and it's very uniform. That will help you will help someone who's reading the form or reading the spreadsheet understand what's going on.

Here is a, a very slim column. He's a very large column. Even using different column widths will help you when you are asking for data input. So you usually wanna make columns that are wider for inputs that will be longer. Like if you want say a longer title or longer description, make that cell much.


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!