Help

  • Thread starter Thread starter valerie
  • Start date Start date
V

valerie

Is there a icon called Format Painter? Could anyone tell me where is it
under; e.g under file menu, cet etera?
 
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.
 
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?
:confused:

Thanks, help is greatly appreciated.
 
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.
 
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.
 
Valerie wanted the words "unit price" in a cell--not the actual unit price!

I get it now.
 
No. Do you know anything about nesting
functions???????????????????????????????????:confused: :confused:
:confused: :confused: :confused: :confused: :confused:

PLEASE HELP!!!!!!!!!!
 
Back
Top