|
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 HIS "Marc" wrote in message ink.net... Marc |
Is this in all version of Excel? I can't get it to work in97.
Marc "Don Guillett" wrote in message ... BTW this only applies to all text. you can't do it in a formula without vba -- Don Guillett SalesAid Software "Nick Hodge" wrote in message ... 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 HIS "Marc" wrote in message ink.net... 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" wrote in message nk.net... Is this in all version of Excel? I can't get it to work in97. Marc "Don Guillett" wrote in message ... BTW this only applies to all text. you can't do it in a formula without vba -- Don Guillett SalesAid Software "Nick Hodge" wrote in message ... 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 HIS "Marc" wrote in message ink.net... Marc |
Marc
Excel 97 has this capability. You must enter edit mode then select the characters to change then FormatCellsFont and pick your font. Gord Dibben Excel MVP On Mon, 11 Apr 2005 01:04:34 GMT, "Marc" wrote: Is this in all version of Excel? I can't get it to work in97. Marc "Don Guillett" wrote in message ... BTW this only applies to all text. you can't do it in a formula without vba -- Don Guillett SalesAid Software "Nick Hodge" wrote in message ... 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 HIS "Marc" wrote in message ink.net... Marc |
| All times are GMT +1. The time now is 03:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com