When you open a new Google Sheets spreadsheet, the columns, rows, and individual cells you see are all a certain size. If you want to see more data in each cell, you must resize it. Here’s how.
Manually resize a column or row in Google Sheets
One of the fastest ways to resize a column or row in Google Sheets is to use your mouse or trackpad to manually resize it. This involves dragging the column or row border to a new position, resizing it in the process.
To do this, open a Google Sheets spreadsheet with your data. Below the formula bar you will see your column headings, initially ranging from A to Z. Likewise, row headings are displayed on the left, initially from 1
RELATED: The beginner’s guide to Google Sheets
To resize a row or column, hover the mouse pointer over the column header (A, B, etc.) or row (1, 2, etc.) and move your mouse to the edge. Your cursor should turn into an arrowhead and point in both directions.
Drag the border with your mouse or trackpad to a new position and release it once the border is in place. A blue line appears as the border moves, giving you a visual indication of the size of the new column or row.
You can also complete this step for multiple columns or rows at once by selecting them first and then using your mouse or trackpad to resize the border of one of the columns or rows.
Google Sheets treats the selected cells together and reduces them all to the same size.
Automatically resize rows or columns in Google Sheets
If the cells in your chosen row or column contain too much data, some of the information may be hidden from review (unless you wrap the text first).
To quickly resize these columns or rows to display this data without wrapping the cell text, you can use your mouse to resize it. This will show all hidden text, resizing the column or row to the size of the largest cell with the most data.
To do this, open your spreadsheet and hover over the column header labels (starting with A, B, etc.) or row (starting with 1, 2, etc.). Move your cursor to move over the edge until the cursor turns into an arrowhead.
Once the arrowhead cursor is visible, double-click the border. This forces Google Sheets to automatically resize to fit the contents of the largest cell.
As with the manual method above, you can select multiple rows or columns to increase or decrease them at once. This automatically resizes each row or column to the data of the largest cell.
Use the Column Format or Resize Row tool in Google Sheets
With the steps above, you can resize columns and rows with your mouse or trackpad, but these methods do not provide a way to resize them to a set size. To do this, you need to use the Google Sheets column and row resizing tool.
To start, open your spreadsheet and select your row header (starting with 1, 2, etc.) or column (starting with A, B, etc.) to select it. You can also do this for multiple rows and columns at once by selecting them first.
With the row or column that you want to resize, right-click on the header label itself (e.g. 1 or A). From the pop-up menu, click the “Resize Column” or “Resize Row” option.
In the “Resize” box, enter a new size (in pixels) for your row or column in the box to resize. You can also select the “Restore to data” option to automatically resize the column or row to fit the data of the largest cell.
Press “OK” to make the change when you are satisfied with the new dimensions.
Once confirmed, the column or row will be resized to the format you selected. You can repeat this step for additional rows or columns.