Microsoft Excel ... ?

Question

Ok well i dont know how to explain it properly but i'll try..
Ok on microsoft excel theres the columns (A, B, C etc), and i need to type some info in a cell... but it doesnt fit in the one cell because its so long, so it stretches to other columns... but then when i print it it will go off the page, so i want to make the rows longer so the info goes vertically instead of horizontally. How do i do this?? Thanks so much, sorry if this is a bit confusing ...

Answer 1

Select Format>Cells.. , select Alignment tab, check under Text Control 'Wrap text'. Next select Format>Rows.. , Change size to something like 30 or more.

Answer 2

There are a couple of things you can do -- it has to do with alignment, wrap and autofit.

To enter information in a cell which is wider than the width of the column:

1. Select the column by clicking on the letter above it. The column will be highlighted.
Click Format, Column.
Here you can select autofit or click Width and type a number. If it is too wide or too narrow, just remove it and set a new one.
or,
2. You can set the text to wrap to the width of the column.
Select the column as above.
cl Format
cl Cells
cl Alignment
cl in the box to wrap text
or,
type as far as you want to go
Press Alt + Enter to add a line in the cell.

Don't be afraid to experiment -- remember the undo button.

Answer 3

In the tool bar go to File then Page Set Up and then change your orientation from portrait to landscape- hit okay. Then go to the cells where the words are too long- you can either make the cell wider buy lining up your mouse cursor over the right side of the row until it turns into what looks like two little rows and then drag the row width to fit your info OR you can click on the cell then in the tool bar go to Format/Cells in the box that pops up select Alignment then click on the box that says "Wrap Text" , hit okay.... and this will make your text only as wide as your cell is- if it's longer then the text will drop down to make another line- making the cell taller... Or if you need it to be the same width and height instead of selecting "Wrap Text" select "Shrink To Fit"- this will make the text the right size so that it fits in one cell without wrapping or extending beyond the cell you intended it to be in.

To make sure all your info is printed on the page you want it to be- highlight all your info (for example begin at A1 and scroll all the way to F20) then go to the tool bar and select File/ Print Area/Set Print Area. Then go to View in the toolbar and select Page Break Preview- the blue lines show you how your pages will be divided you can drag the blue lines to make it so that everyone fits on just one or several pages by playing around with it a little.... To return to the normal view just go back up to View in the tool bar and select Normal.

Best of luck to you!

Answer 4

For example:
On A3 (column "A", row "3"), you typed "The quick brown fox jumps over the lazy dog.". With that, the characters you've typed will extend from A3 to D3. Right?! If that's the case and you want your information to appear vertically, you can try these steps...

1. Assume that the information is "The quick brown fox jumps over the lazy dog." which is located to A3 extended through D3.
2. Click A3.
3. Go to "Formula Bar". (This is the field where "The quick brown fox jumps over the lazy dog." is displayed)
4. Put the cursor right after the word "fox" or on any words you prefer.
5. Press and hold ALT+ENTER.
6. Press ENTER or click on any cell.
7. You should have your information displayed vertically by now.

Answer 5

Lemme guess, you're in a working laptop or pc Literacy classification... maybe with the artwork Institute??? via fact whats humorous is it rather is the coolest question of this weeks first project. strange. "Week 3: Week 3 - W3: project a million communicate communicate question 3 evaluate Microsoft be conscious, Microsoft Excel, and Microsoft PowerPoint. while must you employ each and each of those purposes? while are you able to apply those purposes interchangeably? provide examples and motives to help your answer."

Answer 6

place your cursor between two columns
click and drag your cursor to the right to make the rows longer

Answer 7

?