Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to create automatic subscript/superscript as you type?
the same way as in Word, for example, when typing CO2, it will automatically
change to CO(subscript)2 I know how to do that with symbol in AutoCorrect fuction, but no idea with subscript... anybody? |
#2
|
|||
|
|||
Also, I'm aware of the J-Walk add-in.. but you'd have to select and change
one cell at a time which is not very convenient for me because I have equations x1+ x2 + x3 ... etc. throughout the worksheet... |
#3
|
|||
|
|||
The only way to do it is to select the 2 in CO2 then
Format Cells then checkmark Subscripts. When you select the cell, do not use the address bar. You have to double-click the cell and highlight the number only then format it as subscript. You can change its font size and color too. Do not tell anyone. This is a secret worth thousands of dollars. - mark How about select the number then change the fon -----Original Message----- the same way as in Word, for example, when typing CO2, it will automatically change to CO(subscript)2 I know how to do that with symbol in AutoCorrect fuction, but no idea with subscript... anybody? . |
#4
|
|||
|
|||
There's no macro you can use.
When you're typing in a cell (or the formula bar), no meaningful macro can be running. If your strings were always the same format, you could have a macro run that parses your string, picks out the characters that should be superscripted/subscripted and puts it back. But I think you'd need to say what the rules are for parsing the string. kt wrote: Also, I'm aware of the J-Walk add-in.. but you'd have to select and change one cell at a time which is not very convenient for me because I have equations x1+ x2 + x3 ... etc. throughout the worksheet... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic backup copy | Charts and Charting in Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
How do I create a bar graph with floating bars? | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel | |||
create a chart with a formula | Charts and Charting in Excel |