This wikiHow teaches you how to resize columns and rows in Google Sheets in order to make a cell larger in width and height, using a desktop internet browser.

Steps

  1. 1
    Open Google Sheets in your internet browser. Type sheets.google.com into the address bar, and hit Enter or Return on your keyboard.
  2. 2
    Click the spreadsheet file you want to edit. Find the spreadsheet you want to edit on the list of your saved files, and click on its name or icon to open the file.
    • Alternatively, you can click the Blank option at the top to create a new, empty spreadsheet.
    Advertisement
  3. 3
    Find the column heading of the column you want to resize. Every column is labeled with a heading letter at the top.
    • This will allow you to resize all the cells in the selected column at once.
    • If you want to resize multiple columns at once, hold Control on Windows or Command on Mac, and select all the columns by clicking on the header letter.
  4. 4
    Hover over the right-hand side border of a column heading. This will add a blue highlight on the right-hand side border, and your mouse cursor will turn into a rightward arrow.
  5. 5
    Click and drag the border of the column header to the right. You can make all the cells in the selected column wider by dragging the right-border to the right.
    • If you want to make a column smaller, just click and drag the right-border to the left.
  6. 6
    Find the row number of the cell you want to resize. All the rows are numbered on the left-hand side of your spreadsheet.
    • This will allow you to resize all the cells in this row.
    • If you want to resize multiple rows, hold Control on Windows or Command on Mac, and select all the rows by clicking on the row number.
  7. 7
    Hover over the bottom border of a row number. This will highlight the border with blue, and turn your cursor into an upward arrow.
  8. 8
    Click and drag the row border downwards. This will make all the cells in this row larger.
    • You can also make a row smaller by dragging the border upwards.
    Advertisement

About This Article

wikiHow Staff
Co-authored by:
wikiHow Staff Writer
This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 18,700 times.
How helpful is this?
Co-authors: 1
Updated: May 15, 2018
Views: 18,700
Categories: Google Applications
Article SummaryX

1. Open Google Sheets in a browser.
2. Click a spreadsheet.
3. Hover over the right-hand side of a column heading.
4. Click and drag the column heading to the right.
5. Hover over the bottom border of a row number.
6. Click and drag the row number downwards.

Did this summary help you?
Advertisement