How do you add superscript to Excel cell text?

[Billy T]

Hi Team

I am doing a product-feature comparison spreadsheet in Excel 2000 and I want to add notes to some entries at the bottom of the page. There will be about 5 separate notes and I was intending to add a superscript notation after each product entry, referencing the details recorded below the main spreadsheet data.

Problem is, I can't find any method in the font formatting to set superscript. I naively thought that it would mirror Word's formatting features but apparently not. :(

I tried Excel Help, then killed off the Pooch and tried a deeper search manually, all to no avail. I am sure I have seen this done in other spreadsheet documents so I must be overlooking something.

Any ideas or experience out there?

Cheers

Billy 8-{) :|

[tommy]

You are able to add superscript to Excel cell text but the formatting will apply to the entire contents of the cell, not part of the text. If the spreadsheet will be mainly viewed on a computer rather than as a printed document you could consider inserting Comments to each note for the notations.

[godfather]

Based on Excel 97 and 2002, it can be done.

Select the character in the cell you want superscripted, Format - Cells - Font - Superscript

You wont see the change until you move out of the cell.

I think that will work in 2000 as well, each character can be formatted independently in a cell in 97 and 2002

Alternatively format in Word and paste it in.

[odyssey]

To add superscript to text in a cell you need to highlight the character you want to superscript/subscript and then go to format->cells and select the superscript/subscript effect in the dialogue box that opens.

Note that you can do custom effects for each character in a cell and are not limited to having to apply the effect to the whole cell.

[Billy T]

Magic :^O

So easy, and oh so intuitive, once you know how. :8}

I looked everywhere else but, and when I finally got there with your help I recognised that I'd been there before. So much for dogs that can't find anything and indexes that don't!

Thanks a million guys

Cheers

Billy 8-{) :)

[tommy]

I beg your pardon, I was wrong about selective text in a cell not being able to be formatted separately. After a little experimenting I have found it is indeed able to be done as Godfather and the other poster has indicated. My apologies.