How to Change Row Height and Column Width on Microsoft Excel Worksheet?

By default, all rows on a new workbook have the same height. However, Microsoft Excel allows you to resize rows differently, such as changing row height using the mouse, auto-fitting rows, and wrapping text. This risewindows article will give you how to shift Row Height and Column Width on Microsoft Excel Worksheet.

To beautify content, there are several ways in Microsoft Excel Worksheet. If you have some data in Excel Worksheet that doesn’t fit your requirement, you may want to adjust the height and width of the rows and columns. Usually, the height of rows and the width of columns in Excel are automatic, but for a reason, you can change the row’s height and column’s width manually. Excel automatically increases and decreases the row height in Excel spreadsheets according to the data’s size entered into the rows. If you want to set the rows’ height for specific reasons, such as a cell with an orientation text, this post will guide you on how to do it.

What are Rows and Columns in Excel?

Rows: Here, rows run horizontally On an Excel Spreadsheet. So, the rows are identified by row numbers running vertically on the Excel spreadsheet’s left side. Row numbers range from 1 to 1048576; in total, 1048576 rows.

Columns: Here, columns run vertically on an Excel spreadsheet. These are identified by alphabetical column headers that run horizontally on the spreadsheet’s top. Columns range from A to XFD; in total, 16384 columns.

How to Change the Height of a row in Microsoft Excel?

Two options are available in the Microsoft Excel worksheet to change the height of a row.

First Option

First, place the cursor on the bottom border of the row number; when the cursor changes to the black cross sign, hold and drag the cursor down.

Then, a particular row height will be increased. Similarly, place the cursor on the bottom border of the row number to decrease the Row’s height; when the cursor changes to the black cross sign, hold and drag the cursor upward.

Second Option

Step 1. If you are uncomfortable with the steps mentioned earlier, select the Row by clicking on the Row number.

Step 2. Then, select the Home tab, and click the Format icon in the Cells group.

Step 3. After that, select Row Height from the Format drop-down menu that appears.

Step 4. Next, a small dialog box will appear with Row Height. Set the new Row Height by changing the number. Finally, click the OK button to apply the changes.

How to Change the width of a column in Microsoft Excel?

Two methods are available in the Microsoft Excel worksheet to change the width of the column.

First Method

First, place your cursor on the right side of the column in the Microsoft Excel worksheet. When the cursor changes to the cross sign, drag the cursor to the right side to increase the width of the column.

Similarly, if you want to decrease the width of the column, place your cursor on the right side of the column in the Microsoft Excel worksheet. When the cursor changes to the cross sign, drag the cursor to the left side to decrease the width of the column.

Second Method

Step 1. First, select the column by clicking on the column letter number (In my example, we will change the width of column C).

Step 2. Then, click the Home tab. After that,  click the Format icon in the Cells group.

Step 3. Next, select Column Width from the drop-down list of Format.

Step 4. Then, the Column Width dialog box will open. Finally, set your desired column width and click the OK button.

That’s it for the article.

I hope this post will be helpful to you.

Good luck & keep growing, guys.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: