By default, the columns of Google Sheets and Excel are small-sized. Thankfully, users can enlarge the column size to fit the data. However, new users are unaware of this feature since there is no direct way of widening cells. This article will discuss all the workarounds and ways of widening cells in Google Sheets and Excel.
To expand columns in Google Sheets
Table of Contents
Methods that can be used:
Using the Right-click feature
Using the Wrapping tool
Using the Column edges
Each of the above is discussed in-depth below:
Using the Right-click feature
Steps to follow:
1. Open an existing or new Google Sheets document you want to widen its cells.
2. Choose the existing sheet that you’re working on.
3. Highlight the Columns you want to enlarge. To select all columns, press the CTRL + A keys.
4. Right-click to open the side-view pane. From the menu, choose the Resize column option.
5. On the dialogue, you can choose to manually enter the column size or toggle on the fit to data button. Finally, click the Ok button.
Using the Wrapping tool
Steps:
Steps to follow:
1. Open an existing or new Google Sheets document you want to widen its cells.
2. Choose the existing sheet that you’re working on.
3. Highlight the Columns you want to enlarge. To select all columns, press the CTRL + A keys.
4. Click on the Format tab on the menu bar. From the menu, hover the mouse over the Wrapping button.
5. Choose the Wrap option.
Using the Column edges
This method is used when expanding each Column at a time. Here are the steps to follow:
1. Choose the existing sheet that you’re working on.
2. Click on the Column you want to widen. Place the cursor on the boundary between the two columns.
3. Finally, move the cursor rightwards to widen the column cells.
To expand columns in Excel
Methods that you can use to achieve this:
Using the Format tool
Using the Right-click feature
Using the Column edges
Using the Format tool
Steps:
1. Open an existing Excel document you want to expand its Column.
2. Highlight all the columns. Press CTRL + A keys and click on the Home tab.
3. Then, locate the Format drop-down button. From the menu, choose the Column width button.
4. In the dialogue box, enter the new width.
Using the Right-click feature
Steps to follow:
1. Open an existing Excel document you want to expand its Column.
2. Highlight all the columns. That is, press CTRL + A keys.
3. Right-click to open the side-view pane. From the menu, choose the column width option.
5. Enter the column width size you want and press the OK button.
Using the Column edges
This method is used when expanding one Column at a time. Here are the steps to follow:
1. Open an existing Excel document you want to expand its columns.
2. Click on the Column you want to widen. Place the cursor on the boundary between the two columns.
3. Finally, move the cursor rightwards to widen the column cells.