How to Make Cells Bigger in Excel? Adjusting the Dimensions
If you want to make just one row or column larger, you can do so by adjusting its dimensions. This is useful if you see “###” in the cells because the text doesn’t fit. You can also resize all the rows or columns to fit the data within them, which is handy if you’re working on large worksheets. To make these changes, follow one of the instructions below.
Solution 1. Changing Row Height and Column Width Manually
How to make cells bigger in Excel manually? First, select the area where you want to adjust the row height or column width. Then, follow these steps:
- Click the “Format” button on the toolbar. It’s located to the right, before “AutoSum”.
- Select “Column Width” or “Row Height” from the drop-down menu.
- Enter the desired width or height in the “Column Width” or “Row Height” box. The maximum column width is 255, and the maximum row height is 409.
- Click “OK,” and the changes will be applied to the selected cells.
Simple, isn’t it? Now, you don’t have to always resize the rows and columns manually. There’s another option – read on for the instructions.
Solution 2. Automatically Resizing Columns to Fit the Data Inside Them
If you want your data to always fit in the cells – or rather dictate their size – this solution is for you. Here’s how to make cells bigger in Excel automatically:
- Select the entire worksheet by clicking on the small triangle in the upper-left corner.
- Double-click any boundary between two rows, columns or cells. It doesn’t matter where you click – all the cells will be adjusted to fit the data in them.
What if you only want one column to autofit? Without highlighting anything, double-click on its right boundary, and it will resize to accommodate the data. You can do the same with rows by double-clicking their lower boundary.
This is how you can make cells bigger in Excel so that the data inside them is more visible or doesn’t get cut off. Now, we’ll move on to merging cells if that’s what you’re interested in. It will make cells literally bigger – as in, take up more than one row or column.
Merging Cells in Excel to Make Them Bigger
When you merge cells in Excel, only the data from the upper-left cell is retained, while the rest is lost. If you don’t mind that, follow the instructions below – here’s how to make cells bigger in Excel by merging and centering them.
- Select the cells you want to merge.
- Click the “Merge & Center” button on the toolbar. It’s located in the “Alignment” section.
- The cells will be merged into one, and the data from the upper-left cell will be retained and moved to the center.
You can also merge cells without losing data by using a workaround. First, make sure the column is wide enough to fit all the content in the cells. Then, select them all and go to “Fill” in the “Editing” section of the toolbar. Click “Justify” to move all the contents to the topmost cell. Now that the data is stored in one cell only, you can merge the cells without losing it!
Are you happy with these solutions? We hope so! If you have any questions or suggestions, feel free to leave a comment. And don’t forget to share this article if you found it helpful.
- How to Merge Cells in Google Sheets (Empty or With Data in Them)
- How to Move a Row in Excel Without Copying and Pasting It
- How to Merge and Center in Excel – Manually or With Keyboard Shortcuts
- How to Wrap Text in Google Sheets: A Step-by-Step Guide for Beginners
- How to Unmerge Cells in Excel After Merging Them – Handy Shortcuts