Working with a poorly-formatted spreadsheet can be challenging. For example, a value with many decimal places may not fit into a standard-sized cell, cutting off and preventing you from seeing the entire value. One way of improving the formatting of your Microsoft Excel spreadsheet is by increasing the cell size. You can make an individual cell bigger using the “Merge and Center” feature or increase the size of all of the cells in a row or column.
Merge Cells to Increase the Size of One Cell
Highlight the cell you want to enlarge and the empty adjacent cells that you want to merge with the original cell.
Click the “Home” tab, navigate to the “Alignment” group and select “Merge and Center.”
Click the alignment buttons in the “Alignment” group of the “Home” tab to change the alignment of the data within the newly merged cell. For example, you may want to align the contents to the left instead of the right.
Drag Column or Row to Increase Size
Hover the cursor over the boundary line on the right side of a column until you see a double arrow icon if you want to increase column width. Alternatively, hover over the boundary line at the bottom of a row to increase row height.
Click and drag the boundary line to the right to increase column width. Click and drag the bottom boundary line down to increase row height.
Release the mouse to set the new column or row size.
Enter Specific Row or Column Dimension
Highlight the row(s) or column(s) whose dimensions you want to increase.
Click the “Home” tab, and then select the “Format” options to reveal the “Format” drop-down menu.
Select “Row Height” to increase row height or “Column Width” to increase column width.
Enter the desired pixel size into the “Row Height” or “Column Width” dialog box. Click “OK” to apply the new dimensions to the selected row(s) or column(s).
- Merging a cell with adjacent cells that contain data will disrupt the data in the adjacent cells.
- Ablestock.com/AbleStock.com/Getty Images