How to resize columns and rows in Google spreadsheets

Subscribe us on Google News
Shares


When you open a new Google Sheets spreadsheet, the columns, rows, and individual cells you see will be a certain size. If you want to see more data in each cell, you will need to resize it. That is 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 that contains your data. Below the formula bar, you’ll see the column headers, initially A through Z. Similarly, the row headers are seen on the left side, initially 1 through 100.

RELATED: The Beginner’s Guide to Google Sheets

To resize a row or column, hover over the column (A, B, etc.) or row (1, 2, etc.) header and move the mouse to the edge. Your cursor should turn into an arrowhead, pointing in any direction.

Using your mouse or trackpad, drag the border to a new position and release it once it’s in place. A blue line will appear as the border is 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 the mouse, hold down and move the border to a new position, releasing once the new border is in place.

You can also complete this step for multiple columns or rows at a time by first selecting them and then using your mouse or trackpad to resize the border in one of the columns or rows.

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

Also, Read   How to use Bluetooth file transfer between OS X and Android 5.0 devices

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

Automatically resize rows or columns in Google Sheets

If the cells in the row or column you chose contain too much data, some of the information may not be reviewable (unless you wrap the text first).

To quickly resize these columns or rows to display this data without wrapping the text in the cell, you can use your mouse to resize it to fit. This will show all hidden text, resizing the column or row to match the size of the largest cell that contains the most data.

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

Once the arrowhead cursor is visible, double-click the border. This will force Google Sheets to automatically resize itself to fit the contents of the largest cell.

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

As with the manual method above, you can select multiple rows or columns to resize at once. This will automatically resize each row or column to fit the data in the largest cell.

Using the Resize Column or Row tool in Google Sheets

The steps above allow you to resize columns and rows with the mouse or touchpad, but these methods don’t offer a way to resize them to a set size. To do this, you’ll need to use Google Sheets’ column and row resizing tool.

To get started, open your spreadsheet and select your row header (starting with 1, 2, etc.) or column header (starting with A, B, etc.) to select it. You can also do this for multiple rows and columns at once by selecting them first.

Also, Read   Understanding time travel on the Apple Watch

With the row or column you want to resize selected, right-click the header label (for example, 1 or A). In the pop-up menu, click the “Resize Column” or “Resize Row” option.

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

In the “Resize” box for your row or column, enter a new size (in pixels) in the box provided to resize it. Alternatively, select the “Fit to Data” option to automatically resize the column or row to fit the data in the largest cell.

Hit “OK” to make the change once you’re happy with the new size.


In it "resize" box, provide custom size or select "Fit to data" to resize the column or row to fit the data in the largest cell.  Click "OKAY" to save the settings.

Once confirmed, the column or row will resize to match the size you selected. You can repeat this step for additional rows or columns.



What’s your Reaction?
+1
+1
+1
+1
+1
+1
+1
Shares

Leave a Reply

Your email address will not be published.

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
CHP Adblock Detector Plugin | Codehelppro