This article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn'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.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 28,313 times.
This How.com.vn 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
Open Google Sheets in your internet browser. Type sheets.google.com into the address bar, and hit ↵ Enter or ⏎ Return on your keyboard.
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
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.
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.
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.
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.
Hover over the bottom border of a row number. This will highlight the border with blue, and turn your cursor into an upward arrow.
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
Expert Q&A
About this article
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.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
