Thursday, November 5, 2009

Microsoft Excel Question?

When you're in Microsoft Excel and you're typing something into a box, how to get the to be several lines long and not just one big line across the whole screen? For instance....



aaaaaabbbbbbbb



cccccccdddddddd



instead of....



aaaaaabbbbbbbbccccccccddddddd



Microsoft Excel Question?adware remover



Right click the cell, choose "Format cells", choose the second tab, and click "Word wrap" or "wrap text".



This will make it fit the space provided. If you want to choose where to break the lines, paste in text with more than one line -- or press Alt-Enter to get a newline within a cell.



Microsoft Excel Question?antivirus protection



with your cursor in the cell, right-click and choose Format Cells. Click on Alignment tab and mid-way down by Text Control, click on Wrap text, then click on OK to close dialogue box. Anything you type in that cell will wrap like you indicated above. You can highlight a number of cells in a row or column and apply the same formatting.



Or, just follow Cliff's suggestion above
Sorry trade secret! I didn't tell you this, but... check no one is watching... if you press alt+Enter you will get a carriage return in your text. but you didn;t hear it from me...
Try re-sizing the cell and/or using the "wrap text" option.
ALT enter
Right click the box, or click



format%26gt;cells%26gt;format cells



Then click ALIGNMENT



Then click WRAP AROUND, or WRAP TEXT



Hope that helps
Try "text wrapping."



Right click. Whoops - Charles describes it correctly above.

No comments:

Post a Comment