View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amy Amy is offline
external usenet poster
 
Posts: 165
Default Macro to change part of cell

Hi,
I often need to change the formatting of only part of a cell - e.g. for the
units ug s-1, where the -1 is superscript and the u is actually the Greek
letter mu (m in Symbol font). I know how to do both these things via the
"format cells" dialog box, but would like a keyboard shortcut to do them
quickly. I tried to record a macro to change to superscript and another to
change to Symbol font, but these change the formatting of the whole cell.
When I select just the characters whose format I want to change, the 'macros'
option is greyed out.

How can I run a macro on only part of a cell, or else is there another way
to achieve this with a keyboard shortcut? Ideally I would like to apply this
to chart titles as well.

I'm using Excel 2003.

Thanks,
Amy