This article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 46,754 times.
Learn more...
Do you have data in your spreadsheet that doesn't fit into cells nicely? This How.com.vn will teach you how to drag row and column boundaries to adjust cell size in Microsoft Excel.
Steps
- Open your spreadsheet in Excel or create a new file. You can either open the saved spreadsheet within Excel by clicking File > Open, or you can right-click the file in your file explorer or Finder.
- This will work for Windows and Mac computers as well as the web version.[1]
- Move your cursor to the column or row heading that you want to adjust. You won't be able to adjust a single cell inside a row or column, but you can change the size of the entire row's cells.[2]Advertisement
- Drag the boundary below the row heading (rows) or the boundary to the right (columns). As you drag the line down (rows) or right (columns), the cell size will increase. As you drag the line up (rows) or to the left (columns), the cell size will decrease.
- To select multiple rows or columns, press and hold Ctrl (PC) or ⌘ Cmd (macOS) as you click rows or columns.
- If you want the column or row to adjust automatically according to its contents, double-click the right boundary (for columns) or the bottom boundary (for rows).[3]
- If you can't drag the boundary, you need to check that drag-and-drop is enabled. To do that, go to File > Options. If you're using Excel 2007, click the Microsoft Office Button icon (in the top left corner of the program) and then click Excel Options. Go to the "Advanced" category and select Enable fill handle and cell drag-and-drop then click Ok.[4]
- Open Excel. This app icon looks like a green square with a white "x" in front of another green rectangle that you can find on one of your Home screens, in the app drawer, or by searching.
- Open your project or start a new one. When you open the app, you'll see your OneDrive that lists all your current Excel projects, or you can tap the "New Project" icon to start a blank spreadsheet.
- Tap the row or column heading you want to adjust. You should see two handle icons that you can drag and drop.
- Drag and drop the handles to adjust row and column sizes. Remember that you have to tap the heading in order to get these handles. If you tap on a cell, you'll just select the cell.[5]
Expert Q&A
Tips
References
- ↑ https://support.office.com/en-us/article/change-column-width-or-row-height-b6e6d067-f41c-4b1d-adda-8ffeaded5f35
- ↑ https://support.office.com/en-us/article/change-column-width-or-row-height-in-excel-for-mac-581232c8-f6f8-496e-b059-721ce9e836b4
- ↑ https://support.office.com/en-us/article/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46
- ↑ https://support.office.com/en-us/article/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2#ID0EAACAAA=Windows
- ↑ https://support.office.com/en-us/article/Resize-table-columns-and-rows-51ca071f-4c1c-4914-8338-ecaf5357ec7b
About This Article
1. Open Excel.
2. Open your project or start a new one.
3. Tap the row or column heading you want to adjust.
4. Drag and drop the handles to adjust row and column sizes.
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.