

I can’t even find anything to click on to enlarge it again. I dragged a column to such a narrow width that I can’t see it anymore.

(This still may not please you aesthetically, though, because now this cell is probably taller than the others in its row.) Now you can make the column narrower, and Excel will create as many lines of text as necessary to make the words fit into the cell’s width. Click the Alignment tab, checkmark Wrap Text, and click OK. Right-click the cell and choose Format Cells. In that case, try wrapping the long text on several rows inside that cell rather than making the cell wider. The same trick works for nonadjacent cells just hold down CTRL instead of SHIFT as you click them.īut one cell’s contents are a lot wider than everything else in the column, and all the extra space looks odd in every cell except that one. All the columns will match the width of the one you adjust. Then drag the bar on the right side of the rightmost column. If you’d rather adjust the widths of a few adjacent columns in one step, select them all at once by holding down SHIFT as you click the letter at the top of each column. To AutoFit all of their widths to their contents, double-click the vertical bar between any two columns. Clicking the little triangle icon in the upper-left corner between A and 1 selects every cell. If you didn’t know there was such a thing, you’re in for a pleasant surprise. You can AutoFit every cell at once by using the Select All button. This automatically adjusts the column’s width to handle the widest item in the column. For an even quicker adjustment, double-click the right border beside the column’s letter. Click Format and choose AutoFit Column Width. You can let Excel fix the width for you by clicking a cell and going to the Home tab’s Cells group. To change a column’s width, put the cursor over the vertical bar dividing one column’s label from another (such as the line between E and F) and click and drag it left or right. But columns can stretch anywhere from zero characters wide (which constitutes a hidden column) to 255 characters wide. Excel’s columns are set to a default width of 8.43 characters, which was set up to handle the average character count in the standard font. The words I’m trying to put in a cell are too wide to fit inside the cell. (Most of these instructions apply with slight modification to rows as well as columns.) When you’re stumped for a better column setup or find columns acting strangely, use the following tips to find solutions. The size, behavior, and number of columns are all adjustable. Search MS Office A-Z | Search Web Pages/ Design A-ZĪ workbook’s underlying grid isn’t the unchangeable infrastructure some Excel users may think. Word decreases the width of the text by "scrunching" (a highly technical term) the text together horizontally, without adjusting it vertically.Excel 2007- Cell- Troubleshoot Column Settings Home Excel 2007 Cell Troubleshoot Column Settings What Word does is to decrease the apparent size of the text so that everything fits.


The result is that the text in a cell wraps and pushes everything else down a bit. Then, along comes a need to add a bit more text into one of the tables. You have worked long and hard on your page design, including a couple of tables that are just right.
