In this article, will learn how to resize rows and columns in google sheets. When we work with data in google sheets, you must have seen that we need to have different widths of the column due to the content of the cell, and similarly the height of rows to adjust the content of the cell, in today’s article we will learn how to properly resize rows and columns using various methods in google sheets.
We can resize rows in a column in many ways in different scenarios, unlike excel we have 100px columns in google sheets by default, and a drawback is we don’t see the size of the column width or row height at the time of adjusting their size. But, don’t worry we can have similar width columns, and similar height rows by resizing all of them. Today we will cover some methods to understand every how to resize rows and columns in google sheets.
Why Resize Rows and Columns is Important in Google Sheets
As you know, we work with so many data types on google sheets. We may have small content inside cells, or we may have extensive content even like a paragraph. So, to achieve good readability and enhance user experience, we need to know some useful things about rows and column resizing, normally we resize by simple dragging.
But, we have even more better and precise ways to do this and keep the content clean and consistent with the same width columns and exact rows height. Therefore, we need to learn how to resize columns in google sheets.
How to Resize Rows and Columns in Google Sheets
As I have told you above, we will see various methods. From now let’s start with some basics about rows and columns size adjustment. Firstly, let’s see some simple ways to resize rows and columns.
Resize rows and Columns in Google Sheets – using Select and Drag
The simplest and most frequently used method to resize rows and columns in google sheets is select and drag, you can columns and rows divided into cells, you have a line after each row or column, you simply need to select it and drag left or right for column resizing, and up and down for row resizing.
This is a very easy method you can learn from the simple steps below,
Place your cursor between the column or row line until your cursor changes into a two-sided arrow.
Click on it, and a thin blue line will generate that will show you from where you are dragging or resizing this row or column
Keep the left click on and start dragging
You can see rows or columns are resized.
Resize rows and Columns in Google Sheets – Multiple Row or Columns
In this section, we will learn how to resize rows and columns in google sheets for multiple rows or columns. We use this method to keep the rows and columns’ sizes consistent and precise. We will see how to have the exactly same height for all your rows, and the same width for all the columns.
Select the columns or rows from headers to resize
Note: Headers will turn black after proper selection
Now from the selection hold any of the rows or columns and drag
Doing this for a single row or column will affect the entire selection.
This is how you can do this for multiple rows or columns.
Note: The selection of rows and columns must be contiguous. You cannot select distant rows or columns.
Resize rows and Columns in Google Sheets – using Wrap Text
Wrap text is a method to wrap down the content of the cell and move to next time, this is useful when you don’t want to increase the entire column size so you turn on wrap text for longer texts only. This is a good option to consider when you don’t want to enhance the row height or column width.
It is very easy to wrap your text in a cell or multiple cells.
Select the cell or cells you want to wrap text
Go to Toolbar and click on Text wrapping > then select Wrap
You can go to Format menu > Wrapping > Wrap
This way you can implicate your text into the same column and it will auto-fit when the width increases the text will spread and when the width is decreased the text will wrap and will not overflow into the next column either it will clip.
Resize rows and Columns in Google Sheets – using AutoFit
Sometimes, we need to have absolute sizes of the column as our content size we may have small and larger headings or text in the same data and to match the content size with the cell padding we can use autofit feature. This feature will automatically detect your content extension and will increase the size exactly as the content is, you don’t need to drag the column width to match the content size, it will do it automatically.
Note: Autofit is a built-in method in google sheets, and it does not work with the wrap text feature.
Wrap text shifts the text into a new line, so the autofit will not entertain the wrapped content because it’s now in the next line so autofit will only adjust the column width or row height based on the span of the first line of the content, if you want to rely on the autofit feature then do not use wrap text.
To autofit your rows and columns you can follow the simple steps below.
Mouse over on the column or row border and note that a two-sided arrow will appear
You don’t need to do anything, simply double click
You can see your column with or row height is automatically adjusted and fit your text’s span.
This is how autofit works.
Resize rows and Columns in Google Sheets – Resize Rows or Columns
In this section, we will learn how to resize rows and columns in google sheets using the resize button in for rows or columns, this method is similar to autofit, but you have some more options to consider. Here we can select any row and column and can define their width or height in pixels, or we can also use a radio button to autofit the data as per the content’s span.
Sample data are written in a cell
See in edit mood, the data is overflowing horizontally and vertically
Select the column header
Right-click to explore options
Click on Resize column (as you have selected a column)
Now you can pass here a number in pixels to define the width of the column
Or you can click on the below button which is Fit to data
I am using Fit to data, click on Ok to save changes
You can see your column width is autofitted and extended as per the text
Note: The data is also overflowing vertically, so lets the same for the row as well
Select the row header
Right click and then select Resize row (as now you have selected a row)
Check on Fit to data and click on Ok
The width and height of column and row are adjusted and now fit data this is how you can use Resize column method to resize rows and columns in google sheets
Resize rows and Columns in Google Sheets – Resize Multiple Rows or Columns
To Resize multiple contiguous columns or rows you need to simply select them from the headers (rows or columns), once you selected you can go to options and click on Resize, now you can give width in pixels or you can use Fit to data for columns to have them unique height according to their data, you can do similar for rows as well.
I am using here the pixels method to resize rows and columns
Select some columns
Right click and go to Resize column A-F
Pass a width in pixels
Click on the Ok button
Select some rows > right click and go to Resize rows 1-5
Pass the height for rows in pixels and click on the OK button.
This is how to resize rows and columns in google sheets. I hope you have got an understanding of all the methods and that now you easily resize your rows and columns individually or together using any of the above methods.
- When you pass height in pixels for a row or width for a column, to give you some idea about the normal dimensions the default values in already written above.
- Autofit method, either by clicking the cell border or from the Resize button does not work on the wrapped content as I have discussed for the reasons above
- All the methods can be applied on a single row and column, or on multiple rows and columns
Concluding how to resize rows and columns in google sheets. We have discussed various methods to resize rows and columns, and we saw some useful features like wrap text and autofit that help you while adjusting your rows and columns. All the screenshots are attached above with an explanation and I hope you have got a great learning outcome from this tutorial.
I hope you find this article helpful. I will see you soon with another helping tutorial, till then take care. Don’t forget to subscribe to our blog, keep in touch and keep learning with Office Demy.