Help

[valerie]

Is there a icon called Format Painter? Could anyone tell me where is it
under; e.g under file menu, cet etera?

 

[Dave Peterson]

Mine is on the Standard toolbar.

It's directly to the right of the paste icon (looks like a clipboard).

The format painter icon looks like a paintbrush.

 

[valerie]

ooh, thanks

 

[valerie]

I need to enter Unit Price into a cell. But they have to be on top of
each other in a single row; not two and with no lines in between. I
heard that Format Painter would do the trick. Could anyone tell me how?


Thanks, help is greatly appreciated.

 

[Dave Peterson]

First, Unit Price sounds like one number. But if you want to enter multiple
lines in a cell, you can either allow excel to determine the breaking point (you
turn on wrap text, though). And you could use the format painter for
this--although I think it would be easier just to select the range and
format|cells|alignment tab|check the wrap text box.

But you can have more control over line breaks by using an alt-enter in your
cell. Excel is usually smart enough to recognize your entry and turn on wrap
text, but just in case it doesn't, it's still under format|Cells...

But be aware if you put numbers separated with an alt-enter in a cell, then that
cell isn't a number anymore. It's text. You could extract the two values, but
it makes life a little more difficult for common formulas.

I'd do my best to avoid doing this, if I were you.

 

[Debra Dalgleish]

Type the first word -- Unit
then hold the Alt key, and press the Enter key
Then, type the second word -- Price

Format Painter might help you with this if you had another cell
formatted for Wrap Text, that you could copy.

 

[Dave Peterson]

Valerie wanted the words "unit price" in a cell--not the actual unit price!

I get it now.

 

[Stupid]

No. Do you know anything about nesting
functions???????????????????????????????????


PLEASE HELP!!!!!!!!!!

 

[amby]

wow
i was searching for wraping text since god knows when
thanks