✦Template Printable Ideas Insights

AutoFit Columns & Rows in Google Sheets: A Quick Guide

By

Ever found yourself staring at a Google Sheets document with text or data spilling over into columns or rows, making your spreadsheet feel cluttered and disorganized? Wish there was a way to automatically adjust column widths and row heights to fit their contents perfectly? You're in luck! Today, we're going to guide you through the process of autofitting columns and rows in Google Sheets, a critical skill to keep your spreadsheets clean and readable.

Before we dive in, ensure your Google Sheets is up-to-date. Autofit features have evolved over time, and you'll want to benefit from the latest functionality. Now, let's get started!

Autofitting Columns

Autofitting columns in Google Sheets ensures that your text or data is neatly displayed without spilling over into other columns. This feature comes in handy when you have varying lengths of text or non-standard data.

How to Autofill Rows and Columns in Google Sheets
How to Autofill Rows and Columns in Google Sheets
How to AutoFit Rows and Columns in Excel (2 methods)
How to AutoFit Rows and Columns in Excel (2 methods)
Autofit Rows and Columns in Excel with VBA
Autofit Rows and Columns in Excel with VBA

To autofit columns, follow these steps:

Autofit Width based on Content

Google Sheets automatically adjusts column widths to fit the content when you create a new spreadsheet. However, if you've manually widened or narrowed columns, or if new data has been added, you can quickly autofit them to their content:

Resize Rows and Columns
Resize Rows and Columns
How to Resize Rows & Columns in Google Sheets: Quick and Easy Guide"
How to Resize Rows & Columns in Google Sheets: Quick and Easy Guide"
How To Autofit Rows And Columns In Microsoft Excel
How To Autofit Rows And Columns In Microsoft Excel
  1. Select the columns you want to autofit.
  2. Right-click (or press Ctrl + click on Mac) on any of the column headers and select "Auto fit columns" from the dropdown menu.

Poof! Your columns should now be perfectly fitted to their content.

Autofit Width based on Wrapped Text

In case you have enabled text wrapping (View > Wrap text to contents), follow these steps to autofit columns to accommodate wrapped text:

  1. Select the range of cells with wrapped text.
  2. Right-click on any of the selected cells and choose "Format > Auto Fit columns" from the dropdown menu.

Google Sheets will automatically adjust the column widths to accommodate the wrapped text.

Spreadsheet Formatting Guide | Excel & Sheets Beginner PDF | Table Styling, Colors, Columns, Rows | Instant Download
Spreadsheet Formatting Guide | Excel & Sheets Beginner PDF | Table Styling, Colors, Columns, Rows | Instant Download
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
Auto Fit Row & Column | Excel Tricks
Auto Fit Row & Column | Excel Tricks
the columns rows in google's new sheet, with arrows pointing up to them
the columns rows in google's new sheet, with arrows pointing up to them
Split Text to Columns in Google Sheets (separate first and last name)
Split Text to Columns in Google Sheets (separate first and last name)
How To Apply Formulas to Entire Columns in Google Sheets
How To Apply Formulas to Entire Columns in Google Sheets

Autofitting Rows

Autofitting rows in Google Sheets helps you display tall cells like merged cells or text with line breaks neatly. The autoheight feature in Google Sheets adjusts the row height based on the tallest content in a row.

To autofit rows, follow these steps:

Autofit Height based on Content

By default, Google Sheets uses the smallest possible row height. However, if you've manually adjusted row heights, or if you have tall content, you can quickly autofit them with:

How To Move Multiple Rows and Columns In Excel - The Easy Way!
How To Move Multiple Rows and Columns In Excel - The Easy Way!
How to Calculate Running Total in Google Sheets
How to Calculate Running Total in Google Sheets
Excel Trick To AutoFit All Columns And Rows In Excel #excelworld #exceltips #excellife
Excel Trick To AutoFit All Columns And Rows In Excel #excelworld #exceltips #excellife
  1. Select the rows you want to autofit.
  2. Right-click (or press Ctrl + click on Mac) on any of the row numbers and select "Auto fit rows" from the dropdown menu.

Your selected rows should now be fitted to their tallest content.

Autofit Height for Merged Cells

When you merge cells, the row height adjusts automatically to accommodate the merged area. However, if you need to autofit rows containing merged cells, you can do so by:

  1. Select the rows containing merged cells.
  2. Right-click (or press Ctrl + click on Mac) on any of the row numbers and select "Auto fit rows" from the dropdown menu.

Google Sheets will adjust the row heights to fit the merged cells.

And there you have it! With these simple steps, you can now autofit columns and rows in Google Sheets, keeping your spreadsheets clean, well-organized, and professional. Happy formatting!