How To Adjust Cell Size In Excel

Download Article

Exercise you have data in your spreadsheet that doesn't fit into cells nicely? This wikiHow will teach you how to drag row and column boundaries to adjust cell size in Microsoft Excel.

1
Open up your spreadsheet in Excel or create a new file. You can either open up the saved spreadsheet within Excel by clicking File > Open, or you can correct-click the file in your file explorer or Finder.
- This volition work for Windows and Mac computers as well as the web version.^[1]
2

Movement your cursor to the cavalcade or row heading that you want to conform. You won't be able to adjust a single cell inside a row or cavalcade, simply you can alter the size of the entire row's cells.^[2]

Advertisement
3
Elevate the boundary beneath the row heading (rows) or the boundary to the right (columns). As yous drag the line down (rows) or right (columns), the cell size will increment. As you elevate the line up (rows) or to the left (columns), the jail cell size will subtract.
- 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).^[iii]
- If you can't drag the boundary, y'all demand to bank check that drag-and-drop is enabled. To do that, become to File > Options. If you lot're using Excel 2007, click the Microsoft Office Button icon (in the pinnacle left corner of the program) and and then click Excel Options. Get to the "Avant-garde" category and select Enable make full handle and cell drag-and-drop then click Ok.^[four]
Advertizing

1

Open up Excel. This app icon looks similar a light-green square with a white "x" in forepart of another greenish rectangle that yous can observe on one of your Home screens, in the app drawer, or past searching.
ii

Open your project or start a new ane. When you lot open up the app, y'all'll see your OneDrive that lists all your current Excel projects, or you can tap the "New Projection" icon to start a blank spreadsheet.
3

Tap the row or cavalcade heading you want to adjust. You should see 2 handle icons that y'all can elevate and drop.
4

Drag and drop the handles to adapt row and column sizes. Recall that you have to tap the heading in society to get these handles. If yous tap on a cell, you'll just select the cell.^[5]

Advertisement

Inquire a Question

200 characters left

Include your electronic mail address to get a bulletin when this question is answered.

Submit

About This Article

Article Summary X

1. Open Excel.
2. Open your project or outset a new ane.
3. Tap the row or column heading you desire to adjust.
4. Elevate and drop the handles to accommodate row and cavalcade sizes.

Did this summary help you?

Thanks to all authors for creating a page that has been read 17,930 times.

Is this article up to date?