Note that both of these methods will work if you want to resize multiple rows or columns at once, too. For example, in the image below, I have placed my cursor on the line between columns B and C, because I want to automatically resize column B.ĭouble-click this line to have Excel automatically adjust the size of your row or column. You can utilize this method by placing your mouse cursor on the line that separates your column or row heading from the one either to the right of or below it. Luckily Excel 2010 also includes another option that will automatically resize your row or column for you, based upon the largest cell value in your selected row or column. While this method will work if you can accurately guess the cell width and height that you need, it could prove to be difficult if you do not know an approximate value. Type your desired row height value into the field (any value up to 409 will work) then click the OK button. Right-click the row heading, which is the number at the far-left side of the spreadsheet, then click the Row Height option. Now that we have changed the width of the column, we are going to perform a very similar action to change the height. Once you have entered a new value, click OK. You can enter any value into this field up to 255, but bear in mind that the default value is 8.43, so adjust accordingly. The column heading is the letter above the spreadsheet.Ĭlick the Column Width option, then enter a value into the field. Locate the cell that you want to adjust, then right click the column heading at the top of that cell’s column. Excel will not allow you to change the size of a single cell.īegin the process by double-clicking the Excel file that contains the cells that you want to resize. The first thing to realize before you start changing your Excel cell sizes is that when you are changing the width or height of a particular cell, you are adjusting that value for every other cell in the row or column. Additionally, there are several different methods that you can utilize to change the size of a cell in Microsoft Excel 2010, so you can experiment with the different available methods to determine which one is correct for your needs. Fortunately you can choose to make any cell either smaller or larger to accommodate the information that you are inputting into the cell. This size is ideal for many situations, but you will eventually encounter a piece of information that will not fit within these default parameters. Cells in Microsoft Excel 2010 have a default size of 8.43 characters wide by 15 points high.
0 kommentar(er)
