WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to change the width of column in excel

July 28, 2022
4.5K Views

Spreadsheets such as Excel are commonly used to organize data. Using this tool, you can make formatting adjustments to spreadsheets, making them easier to read.Learning how to change column size in Excel can allow you to create a spreadsheet with large amounts of information and text. In this article, we discuss why you might want to adjust the width of column in Excel, along with the different methods you can use for this process.

What is a column width and why should you change it?

When you are creating a document in a word processing program, you may be given the option to create a column width. Column width is the distance between the left and right sides of the text in a column. A column width that is too small can cause text to wrap around or run together, making your document difficult to read. A column width that is too large can cause text to scroll horizontally without any breaks between columns. Before you decide on a column width, it is important to consider your intended audience and how they will be using your document.

Ways to Change Column Width in Excel 2016/2019 Online

If you want to change the width of a column in Excel, there are a few different ways to do it. One way is to use the Column Width feature in the home tab of the ribbon. Another way is to use the VBA Editor.

How to change column width by Using Mouse in Excel on Mac?

1. Mouse hover and keep the mouse pointer in between the line on the column header, it will change into a double-headed arrow.

2. Drag the mouse pointer towards the left /right to decrease or increase the width of the column.

How to Change Automatically Column width in Excel 2019 online?

You can automatically fit the widest entry in a column by double-clicking its right border.

1. The first step to autofit multiple columns is to click and drag over the column headers to select multiple columns.

2. Click the column headers while holding CTRL to select non-adjacent columns.By default, columns, and rows in WPS Excel have a fixed size. This size doesn't change unless you change it. 

If you don't change this size, it won't change. Unless you change the column size, your data will appear truncated because your data may exceed the default column width.Changing the width of the column will make your spreadsheet look pleasing to the eyes. 

In conclusion, if you want to change the width of a column in Excel, there are a few different ways that you can do it. You can use the Column Width button on the Home tab, the Width property of a worksheet object, or the VBA method Get Orientation ().

Has this process helped you learn about Change the width of Column in Excel. If you want to find out more about excel functions and features, you can view and subscribe to WPS Academy to learn.

You should also download and use WPS Office to edit Excel, PowerPoint, PDF, and Word documents for free. Download now and enjoy these free services! With WPS Office, you can create a simple and enjoyable working environment. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.