March, 2009
|
Reader question - susbcribe to the gizmo guide today Resizing Excel cells to fit their contents |
|
Dear Gizmo, I’m working on a Microsoft Excel document (for the first time). I’ve put my data into cells, but the cells aren’t large enough to fit the contents so some is cut off. Is there an easy way to resize them all at once so I can actually see it all? Nic, Brunswick |
|
Hi Nic, Good question! Excel is a fantastic tool, but there is a lot to learn for the uninitiated. There are two ways you can format your cells to fit more text in. The first is to automatically expand the width of the cells that are too small so that they fit their contents. To do this, click and drag the mouse over the column headings (A, B, C etc) and then, on the Home tab, in the area called Cells, click Format and select Autofit Column Width. The second way to do it is to expand the height of your cells, and then wrap your text so it appears on two or more lines. To wrap text select the cell (or cells) you want to change, right click on them, select Format > Alignment > Wrap Text and then click OK. Hope this helps. A gizmotech can help you out if you get stuck - call 1300 275 449 to book. |
|