How to Make Columns Wider in Excel




How to Make Columns Wider in Excel

by Kevin Lee, Demand Media Use your mouse or keyboard to make Excel columns wider.

Use your mouse or keyboard to make Excel columns wider.

Thinkstock Images/Comstock/Getty Images

When you add text to a cell in your business spreadsheet, that cell will not widen automatically to accommodate your text unless you change a few settings. This behavior can be frustrating when you need to type long data values in a column in the column is too narrow to display all the data. Excel has several methods you can use to make columns wider using your mouse or by typing values into a dialog window.

Resize Using Dialog Window

Step 1

Launch Microsoft Excel and open a spreadsheet that has data.

Resize Using Dialog Window

Step 2

Click the column you would like to make wider. If you want to resize more than one column, press "Ctrl" and click additional columns to select them.

Related Reading: How to Combine First & Last Name Columns in Excel

Resize Using Dialog Window

Step 3

Click the ribbon's "Home" tab and find the ribbon’s Cells section. Click "Format" to display a format menu that displays multiple formatting options.

Resize Using Dialog Window

Step 4

Click the menu’s "Column Width" option to open the Column Width dialog window.

Resize Using Dialog Window

Step 5

Type a width value in the "Column Width" text box and click "OK" to resize the columns.

How do I make excel boxes bigger? - AnandTech Forums
you can either combine that box with other excel boxes, either rows or ... Or you
can simply make that entire column or row larger, by sliding the ...
http://forums.anandtech.com/showthread.php?t=1664430

Resize Using Mouse

Step 1

Select one or more columns you'd like to make wider.

Resize Using Mouse

Step 2

Click the right boundary of one of the columns you selected.

Resize Using Mouse

Step 3

Hold down your left mouse button and drag your mouse to the right to make the columns wider.

Excel 2007: Working with Rows and Columns, UWEC
Excel may widen the column or increase the row height to fit the cell content. ...
HINT: For a narrower column, drag left; for a wider column, drag right. ... When
working with worksheets, you will often need to make changes to the original ...
http://www.uwec.edu/help/excel07/ws-rowcol.htm

Tips

  • After clicking "Format" to display the menu containing formatting options, you can click "AutoFit Column Width" instead of clicking "Column Width." Clicking “AutoFit Column Width” forces Excel to adjust the width of the columns you selected so that they are wide enough to display their contents.
  • Every Excel spreadsheet has a "Select All" button. Find this to the left of the spreadsheet's first column. Click that button when you want to select all a worksheet’s columns.
  • Change the default width for all columns in a worksheet by clicking the worksheet's tab at the bottom Excel and returning to the menu that displays the formatting options as described previously. Click the menu's "Default Width" option and type a value for the width you'd like to use in the Default Width text box. Click “OK” to save your changes. To change the default width for all worksheets in a workbook, perform these steps after right-clicking a worksheet tab and clicking "Select All Sheets."

About the Author

After majoring in physics, Kevin Lee began writing professionally in 1989 when, as a software developer, he also created technical articles for the Johnson Space Center. Today this urban Texas cowboy continues to crank out high-quality software as well as non-technical articles covering a multitude of diverse topics ranging from gaming to current affairs.

Photo Credits

  • Thinkstock Images/Comstock/Getty Images

Have Feedback?

Thank you for providing feedback to our Editorial staff on this article. Please fill in the following information so we can alert the Small Business editorial team about a factual or typographical error in this story. All Fields are required.

×






http://smallbusiness.chron.com

Q-Tip Skeleton
Q-Tip Skeleton This Q-Tip Skeleton is an easy and inexpensive Halloween kids craft. This would be a great activity for preschoolers to add some spooky to the holiday! Level of Difficulty: Easy Here's what you'll need.
Electric Roti Maker + Easy Dough Maker [DRM00256] MRP:-3999
New Instant Electric Roti Maker Chapati Tawa Superior quality  Rolls and cooks chapati in less than  a minute  Saves Time, Cooking oil, Time and  Money   Non stick plates cooking reduces calorie intake, Healthy food  Thermostat controlled  works  on 230/240 V AC, 50 Hz, mains electricity Wattage - 900 Watts  Stainless steel body  Excellent gift Item  Great Utility item.
Mounts and Achievements
slide 1 of 3 Horde / Alliance Faction Ground Mounts   Each race is able to purchase the level 75 riding skill mounts of their own race once they have gained experience level 20. Upon gaining level 40, characters may purchase riding skill 150 and the 'epic' ground mounts of their home race.
About