How To Adjust Cell Size In Google Sheets

Google Sheets

When you open a new Google Sheets spreadsheet, the columns, rows, and private cells you see will all exist a certain size. If you lot want to see more data in each cell, y'all'll need to resize them. Here's how.

Manually Resizing a Column or Row in Google Sheets

1 of the quickest ways to resize a column or row in Google Sheets is to apply your mouse or trackpad to resize it manually. This involves dragging the cavalcade or row edge to a new position, resizing it in the process.

To do this, open a Google Sheets spreadsheet containing your data. Beneath the formula bar, yous'll see your column headers, initially ranging from A to Z. As well, row headers are seen on the left-hand side, initially ranging from i to 100.

RELATED: The Beginner's Guide to Google Sheets

To resize either a row or column, hover over the cavalcade (A, B, etc.) or row (ane, 2, etc.) header and move your mouse to the border. Your cursor should turn to an arrowhead, pointing in either management.

Using your mouse or trackpad, drag the border to a new position, releasing information technology once the border is in place. A blueish line volition announced as the edge is being moved, giving you a visual indication of the size of the new column or row.

To resize a column, hover over a column border. Using your mouse, hold down and move the border to a new position, letting go once the new border is in place.

You tin can as well consummate this pace for multiple columns or rows at one time by first selecting them, so using your mouse or trackpad to resize the edge on ane of the columns or rows.

Google Sheets will treat the selected cells together, resizing them all to the same size.

To resize multiple rows and columns, select the rows or columns, then hover over one of the selected header borders. Using your mouse, drag the border into a new position, letting go once in place.

Resizing Rows or Columns Automatically in Google Sheets

If the cells in your chosen row or column contain also much data, some of the information may exist hidden from review (unless y'all wrap the text first).

To quickly resize these columns or rows to display this data without wrapping the prison cell text, y'all can use your mouse to resize it to fit. This will brandish all subconscious text, resizing the column or row to friction match the size of the largest cell containing the near data.

To do this, open your spreadsheet and hover over the cavalcade (starting with A, B, etc.) or row (starting with ane, 2, etc.) header labels. Motility your cursor to hover over the border until the cursor changes to an arrowhead.

Once the arrowhead cursor is visible, double-click the edge. This volition force Google Sheets to resize information technology automatically to fit the content of the largest jail cell.

To automatically resize a column or row to fit the largest cell's data, double-click the header border.

Equally with the transmission method above, you can select multiple rows or columns to resize them at once. This will automatically resize each row or cavalcade to fit the largest cell'south data.

Using the Resize Cavalcade or Row Tool in Google Sheets

The steps in a higher place allow you to resize columns and rows using your mouse or trackpad, only these methods don't offer a style to resize them to a set size. To do this, yous'll need to use Google Sheets' cavalcade and row resizing tool.

To start, open up your spreadsheet and select the header for your row (starting with 1, 2, etc.) or column (starting with A, B, etc.) to select information technology. You tin too do this for multiple rows and columns at once by selecting them first.

With the row or cavalcade you wish to resize selected, right-click the header label itself (eg. i or A). From the pop-up carte du jour, click the "Resize The Cavalcade" or "Resize The Row" option.

To resize a row or column to a set size, right-click a column or row header label and select "Resize the Row" or "Resize the Column" from the pop-up menu.

In the "Resize" box for your row or cavalcade, enter a new size (in pixels) in the box provided to resize information technology. Alternatively, select the "Fix To Data" option to automatically resize the column or row to fit the largest cell's data.

Press "OK" to make the modify once you're happy with the new sizing.

In the "Resize" box, provide a custom size, or select "Fit To Data" to resize the column or row to fit the largest cell's data. Click "OK" to save the setting.

Once confirmed, the column or row will resize to match the size yous selected. Yous can echo this footstep for additional rows or columns.