How to Change Width of Column in Excel

This article will teach you two quick methods to adjust column width in Excel.

‍

Adjusting column width in Excel

The width of columns in Excel can be changed in multiple ways, two of which are explained below.

‍

Method 1: Using the ‘Column Width’ option to change the width of columns in Excel

Step 1: Select the column

Step 2: Right-click and select the ‘Column Width’ option

‍Step 3: Enter the width (each unit refers to the width of each character displayed in standard font style)

Step 4: Click ‘OK’

‍Note: To adjust the width of multiple columns together, select all the columns in step 1 and then continue with step 2 to 4 described above.

‍

Method 2: Adjusting the width of columns in Excel with the mouse

Step 1: Select the column whose width you want to change

Step 2: Place the cursor towards the right edge of the column header

Step 3: When the cursor changes to a double-sided arrow, drag the column edge to the required width as indicated in the image below

‍Note: To adjust the width of multiple columns together, select all the columns in step 1 and then continue with step 2 and step 3 described above.

‍

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly. 

To learn more about LiveFlow, book a demo.

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides