Can you mix font sizes in a cell?

Marc

Marc

Yes, highlight the characters you want in the formula bar (or press F2, (or
double click the cell) and edit in-cell), change their font size and enter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
news:IE%[email protected]...
> Marc
>
>

BTW this only applies to all text. you can't do it in a formula without vba

--
Don Guillett
SalesAid Software
[email protected]
"Nick Hodge" <[email protected]> wrote in message
news:[email protected]...
> Marc
>
> Yes, highlight the characters you want in the formula bar (or press F2,
(or
> double click the cell) and edit in-cell), change their font size and enter
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> [email protected]HIS
>
>
> "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
> news:IE%[email protected]...
> > Marc
> >
> >
>
>

Is this in all version of Excel? I can't get it to work in97.

Marc

"Don Guillett" <[email protected]> wrote in message
news:[email protected]...
> BTW this only applies to all text. you can't do it in a formula without
vba
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Nick Hodge" <[email protected]> wrote in message
> news:[email protected]...
> > Marc
> >
> > Yes, highlight the characters you want in the formula bar (or press F2,
> (or
> > double click the cell) and edit in-cell), change their font size and
enter
> >
> > --
> > HTH
> > Nick Hodge
> > Microsoft MVP - Excel
> > Southampton, England
> > [email protected]HIS
> >
> >
> > "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
> > news:IE%[email protected]...
> > > Marc
> > >
> > >
> >
> >
>
>

Goes all the way back to at least 5.0 as far as I recall.

Step by step:
Cell should be text, numbers don't work (text numbers OK).

In the formula bar, select the characters in the cell you wish to format.
Right click and choose "Format Cells".
Click on "Color", click on "Red", click <OK>.

I get red characters, what do you get?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
news:[email protected]...
> Is this in all version of Excel? I can't get it to work in97.
>
> Marc
>
> "Don Guillett" <[email protected]> wrote in message
> news:[email protected]...
> > BTW this only applies to all text. you can't do it in a formula without
> vba
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "Nick Hodge" <[email protected]> wrote in message
> > news:[email protected]...
> > > Marc
> > >
> > > Yes, highlight the characters you want in the formula bar (or press
F2,
> > (or
> > > double click the cell) and edit in-cell), change their font size and
> enter
> > >
> > > --
> > > HTH
> > > Nick Hodge
> > > Microsoft MVP - Excel
> > > Southampton, England
> > > [email protected]HIS
> > >
> > >
> > > "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
> > > news:IE%[email protected]...
> > > > Marc
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Marc

Excel 97 has this capability.

You must enter edit mode then select the characters to change then
Format>Cells>Font and pick your font.


Gord Dibben Excel MVP

On Mon, 11 Apr 2005 01:04:34 GMT, "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com>
wrote:

>Is this in all version of Excel? I can't get it to work in97.
>
>Marc
>
>"Don Guillett" <[email protected]> wrote in message
>news:[email protected]...
>> BTW this only applies to all text. you can't do it in a formula without
>vba
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "Nick Hodge" <[email protected]> wrote in message
>> news:[email protected]...
>> > Marc
>> >
>> > Yes, highlight the characters you want in the formula bar (or press F2,
>> (or
>> > double click the cell) and edit in-cell), change their font size and
>enter
>> >
>> > --
>> > HTH
>> > Nick Hodge
>> > Microsoft MVP - Excel
>> > Southampton, England
>> > [email protected]HIS
>> >
>> >
>> > "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
>> > news:IE%[email protected]...
>> > > Marc
>> > >
>> > >
>> >
>> >
>>
>>
>