If you are using the menus (Tools>Macro>pick it>run = 4 clicks) to run the macro, however, it is unlikely to save you much time. one click on a toolbar button to reformat all the supers or subs in a cell. The problem is that Excel's formatting for super- sub-scripts is buried too deep in the menu system, and is impossible to assign to a tool bar button like the defaults for strike-thru, bold, italic, etc., which are operative as you are editing in the formula bar.Ĭonsider that (Format>Cell>Font>check box) is 4 clicks per each super or sub script, vs. This macro is definitely faster if you have more than one super or sub script in a given cell, and if you've assigned this macro to a button or key-command. I setup a tool bar button that shows the two bracket types in the relative positions, so it is double-duty: runs the macro, and is a visual reminder of the syntax to use. SWEET - this really works like a charm now.
RE: Excel Subscript/Superscript Macro broekie (Structural) 28 Oct 05 15:54 NumSuper = Len(Cell) - Len((Cell, "", ActiveCell, 1)ĪctiveCell.Characters(SuperR - 1, 1).DeleteĪctiveCell.Characters(SuperL, SuperR - SuperL - 1).Font.Superscript = True Keyboard shortcuts for Google Docs.NumSub = Len(Cell) - Len((Cell, "[", "")) Note: Some shortcuts might not work for all languages or keyboards. Use keyboard shortcuts in Google Docs to navigate, format, and edit. Open the Font dialog box and make sure the Character Spacing tab is displayed.Select the first character (the one that is superscripted).Type the character you want as the subscript and format it as a subscript.Type the character you want as a superscript and format it as a superscript.Superscript and Subscript at the Same Place Also, how do you write co2 in Word Here is a MS Word tip from a colleague which should help: ã» Type a sentence with CO2 in the middle of it. CTRL + J assigns both a superscript and a subscript. Thereof, how do you write subscripts and superscripts in Word? With Microsoft Word Equation Editor 3.0 or 3.1: CTRL + H puts you into superscript mode. (It needs to have normal text following it to prepare this AutoCorrect, otherwise all text you type after it corrects itself will remain subscript.) ・ Select the 2 and format it as Subscript. Similarly, how do you write co2 in Word? Here is a MS Word tip from a colleague which should help: ・ Type a sentence with CO2 in the middle of it. CTRL + J assigns both a superscript and a subscript.CTRL + H puts you into superscript mode.With Microsoft Word Equation Editor 3.0 or 3.1: Similarly, it is asked, how do you write superscript in equation editor? For subscript, press Ctrl and the Equal sign (=) at the same time. Keyboard shortcuts: Apply superscript or subscript For superscript, press Ctrl, Shift, and the Plus sign (+) at the same time.
0 kommentar(er)
