How to Enlarge a Cell in Excel 2010

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. 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. In the example image below, my cell would be located in column E.

double-click for wider column

 

Step 3: Double-click your mouse to automatically resize the column.

 

Manually Set Column Width

 

Step 1: Make sure that the spreadsheet is open in Excel.

Step 2: Right-click the column heading containing the cell that you want to enlarge, then click the Column Width option.

manually adjust column width

 

Step 3: Type a value for the width into the field at the center of the window. The default size is 8.43, so increase the size accordingly.

Step 4: Click the OK button to apply the width and resize the column.

 

Automatically Set Row Height

 

Step 1: Make sure that the spreadsheet is still open in Excel.

Step 2: Position your mouse cursor on the bottom border of the row containing your cell. In the example image below, my target cell would be in row 14.

double-click to resize row height

 

Step 3: Double-click your mouse to automatically resize the row based on the cell containing the largest data.

 

Manually Set Row Height

 

Step 1: Open the spreadsheet in Excel.

Step 2: Right-click the row heading containing the cell that you want to enlarge, then click the Row height option.

manually adjust row height

 

Step 3: Type your desired row height into the field at the center of the window (the default value is 15), then click the OK button to resize the row.

 

How to Merge Cells

 

Step 1: Locate the cell that you want to enlarge. In order for you to merge cells without disrupting data in surrounding cells, you are going to need to make sure that the cells surrounding your target cell are empty.

locate the cell to merge

 

Step 2: Use your mouse to select all of the cells that you want to merge into one.

Step 3: Click the Home tab at the top of the window.

Step 4: Click the Merge and Center button in the Alignment section of the ribbon at the top of the window.

how to enlarge a cell in Excel 2010

 

Using one of the methods described above should help you to solve your problem. If you would like further information on changing cell sizes in Excel 2010, you can read this article.

If you are in the market for a new laptop and want something that will come with a free, non-trial version of Excel, you should check out our review of theĀ Dell Inspiron i15R-2632sLV. Not only does it have a ton of awesome features, but it is priced very reasonably for a machine that is built for both performance and portability.

Share this...Share on FacebookTweet about this on TwitterShare on Google+Pin on PinterestShare on TumblrShare on RedditEmail this to someone