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

School Homework – Making a Candlestick Telephone
Categories Select Category10 things…  (12)10 tips in 10 minutes  (1)altered art  (10)American Crafts  (6)art journal  (5)blog hop  (7)CHA Picks  (1)challenges  (33)Classes  (1)cooking  (8)counterfeit kits  (28)craft projects  (73)Crate Paper  (14)Cricut Explore  (9)crochet  (1)digi layouts  (2)DIY Details  (4)Echo Park  (2)Elle’s Studio  (10)etsy  (1)event  (4)Fancy Pants  (1)Frosty 2013 Challenge  (5)Frosty Festivities  (101)gifts  (6)giveaway  (61)Glitz Designs  (21)handmade cards  (120)Happy Scatter  (6)I must scrapbook this…  (3)I want to make  (2)Jillibean Soup  (2)JYC  (1)JYC2011  (2)kids craft  (5)LSNED 2010  (12)LSNED 2011  (7)LSNED 2012  (1)Month In Numbers  (10)my 30th birthday  (10)my little girl  (54)my little man  (2)My Mind’s Eye  (3)Online Classes  (1)Onwards and Upwards  (34)organisation celebration  (35)paint tutorial  (4)paper tutorials  (2)paperhaus  (11)pocket-sized plans  (3)recipes  (3)Refresh Your Craft Soul  (34)S J Crafts  (8)SCRAP 365  (11)scrapbook layouts  (208)scrapbook mini books  (13)sewing  (4)Sketch  (2)storytelling sunday  (8)Studio Calico  (1)summer  (2)Sweet Stamp Shop  (2)tags  (11)The Scrapbooking Soiree  (5)tutorials  (41)Uncategorized  (69)Videos  (4)
Birth-Control-Sex-Ed
Yeah, yeah, it’s another post about condoms. I feel like a condom salesman. But hey, it’s important. Condoms are by far the most widely known and most used type of birth control out there.
How To Use X-Ray In Photoshop
This is totally fake. First used your own image and followed all steps exactly and came out with nothing but a grey blob. I shoulda figured off the bat it was bullsh*t. You start with the "Pen tool" in the first step and then somehow get a marquee selection by the 3rd step without changing tools.
About