How to expand all columns in Google Sheets and Excel

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

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.

Leave a Comment