Last updated: January 17, 2017 Making cells bigger in Excel 2010 is something that can be done using a couple of different methods. The first and simplest method involves increasing the width of the column that contains the cell, or increasing the height of the row containing the cell. You can also perform both of these actions if you need to increase a cell in both directions.

Mar 24, 2010  Some of the cells wrap and auto height the rows to show all of the text Some of the cells will not auto height the rows and if I manually expand the row using my cursor, the text. To make text wrap within a cell, on the Home tab, click Wrap Text. To shrink the contents of a cell so that they fit in the current column width: In Excel 2016 for Mac, on the Home tab, click the Format button, click Format Cells, and then select Shrink to Fit. See Excel Help on the topic: Change column width or row height BTW: You posted to the forum for Word:-) Regards, Bob J. Apply auto-fit property to multiple columns simultaneously. You probably know that you can double-click the right border of a column's header cell to automatically adjust the width of a column. Excel widens or narrows the column width to suit the longest entry. You can apply a best-fit to more than one column at a time. Simply select all the columns that need adjusting (if the columns neighbor one another, drag through their column letters on the frame; if they don’t, hold down the Ctrl key while you click the individual column letters). How to make Excel's “Auto Fit Row Height” feature actually auto fit the row height? 16 answers I have copied some data into Excel 2010. I have found that some of the cells need to be widened to allow the data to fit.

However, this will also increase the size of the rest of the cells in that row or column. If you want to make an individual cell larger without increasing the size of the surrounding cells, then you need to merge several cells together. The choice is up to you, and can vary depending upon the situation. Increasing Cell Sizes in Excel 2010 The first option that we are going to go over is increasing the width of a column. You can choose to either manually set the width of the column, or you can choose to automatically size the column based upon the largest amount of data contained within a cell in that column. Automatically Set Column Width Step 1: Open the spreadsheet containing the cell that you want to enlarge. Step 2: Position your mouse cursor on the right border of the column heading in which the cell is located. Free ebook text files.