This article will teach you two quick methods to adjust column width in Excel.
The width of columns in Excel can be changed in multiple ways, two of which are explained below.
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.
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.
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
Learn how to do this step-by-step in the video below 👇