Go Back   AnandTech Forums > Software > Software for Windows

Forums
· Hardware and Technology
· CPUs and Overclocking
· Motherboards
· Video Cards and Graphics
· Memory and Storage
· Power Supplies
· Cases & Cooling
· SFF, Notebooks, Pre-Built/Barebones PCs
· Networking
· Peripherals
· General Hardware
· Highly Technical
· Computer Help
· Home Theater PCs
· Consumer Electronics
· Digital and Video Cameras
· Mobile Devices & Gadgets
· Audio/Video & Home Theater
· Software
· Software for Windows
· All Things Apple
· *nix Software
· Operating Systems
· Programming
· PC Gaming
· Console Gaming
· Distributed Computing
· Security
· Social
· Off Topic
· Politics and News
· Discussion Club
· Love and Relationships
· The Garage
· Health and Fitness
· Merchandise and Shopping
· For Sale/Trade
· Hot Deals with Free Stuff/Contests
· Black Friday 2014
· Forum Issues
· Technical Forum Issues
· Personal Forum Issues
· Suggestion Box
· Moderator Resources
· Moderator Discussions
   

Reply
 
Thread Tools
Old 08-07-2005, 11:16 AM   #1
Xcellere
Senior Member
 
Join Date: Mar 2005
Posts: 296
Default How do I make Excel cells expand automatically when a lot of text is entered?

Look at the cell below remarks, there's a large amount of text in the cell below it, but it doesn't expand the cell to show it all:

http://img.photobucket.com/albums/v314/Xcellere/d3.jpg

Now look at how the text in this sample document automatically makes the cell bigger to fit all of the text in the cell:

http://img.photobucket.com/albums/v314/Xcellere/d1.jpg

How do I make it so the cell automatically makes itself bigger to fit all the text?

I don't want to have to adjust each cell individually to adjust itself when a large amount of text goes in it. I just want the program to make each cell bigger whenever large amounts of text go in the cells.
__________________
Heatware
Xcellere is offline   Reply With Quote
Old 08-07-2005, 11:27 AM   #2
Xcellere
Senior Member
 
Join Date: Mar 2005
Posts: 296
Default How do I make Excel cells expand automatically when a lot of text is entered?

Fixed one of the links.
__________________
Heatware
Xcellere is offline   Reply With Quote
Old 08-07-2005, 12:01 PM   #3
Xcellere
Senior Member
 
Join Date: Mar 2005
Posts: 296
Default How do I make Excel cells expand automatically when a lot of text is entered?

If someone can hurry and help, I'd really appreciate it. I'm in a rush to get this done.
__________________
Heatware
Xcellere is offline   Reply With Quote
Old 08-07-2005, 12:48 PM   #4
Concillian
Diamond Member
 
Join Date: May 2004
Location: Dublin, CA
Posts: 3,654
Default How do I make Excel cells expand automatically when a lot of text is entered?

If you right click and choose 'Format Cells' then the 'Alignment' Tab you can check 'wrap text'

That will allow the cell to grow vertically automatically.

You still have to set horiz. yourself, I don't think there is an option for that automatically, but could be wrong.
Concillian is offline   Reply With Quote
Old 08-07-2005, 01:39 PM   #5
Xcellere
Senior Member
 
Join Date: Mar 2005
Posts: 296
Default How do I make Excel cells expand automatically when a lot of text is entered?

Already tried that, it still just forces all the text into the one cell and you can't see most of it.
__________________
Heatware
Xcellere is offline   Reply With Quote
Old 08-07-2005, 02:01 PM   #6
Xcellere
Senior Member
 
Join Date: Mar 2005
Posts: 296
Default How do I make Excel cells expand automatically when a lot of text is entered?

I just tried it with the sample document, and it works, but with the document that I've created, it does absolutely nothing and keeps all the text scrunched into the one cell.

What am I missing here?
__________________
Heatware
Xcellere is offline   Reply With Quote
Old 08-07-2005, 03:19 PM   #7
Xcellere
Senior Member
 
Join Date: Mar 2005
Posts: 296
Default How do I make Excel cells expand automatically when a lot of text is entered?

Here we go:

http://www.dcturanoinc.com/jobsheet.xls

Click on the blue cells that correlate with the following titles:

Job # (the one at the very top)
Building Owner
Remarks (at the very bottom)

These are the ones that don't work. The rest of the entire sheet works fine. Can someone make them work?
__________________
Heatware
Xcellere is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:19 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.