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

The ZCush Nap Mat (Product Review and Giveaway)
Congrats to Donna. With our second daughter only days away from arriving, I can't wait to try out the ZCush Baby Nap Mat with her.   What is the ZCush Nap Mat you ask?   Formerly known as the zCush Infant Support Mat, the zCush Baby Nap Ma t is a lightweight, cushiony mat designed to place a newborn for comfort security.
Please help me make excellent nachos
Here be the truth... Major components... Chips. Find high quality restaurant style corn tortilla chips, or make your own. In the SF bay area, Casa Sanchez Thin and Organic White Corn Cheaps are two great brands.
About