If you do, however, add highlighting, at some point you will want to remove that highlighting. Instead of step 12, you simply could have clicked Find Next to step through each of the superscripts and review them. Of course, if all you needed to do was to check the superscripts, there was no need to highlight them, meaning you could have skipped steps 1, 2, 10, and 11. With the insertion point still in the Replace With box, click Format | Highlight.Īt this point, all your superscripts are highlighted using whatever color you selected in step 2.(Doing this makes sure your superscripts aren't destroyed.)
This indicates you want whatever was found to be used as the replacement. Enter "^&" (without the quote marks) in the Replace With box.Click OK to close the Find Font dialog box.Click the Superscript check box until it shows as selected.Make sure both the Find What and Replace With boxes are empty.The Replace tab of the Find and Replace dialog box. Click the More button, if it is available.Word displays the Replace tab of the Find and Replace dialog box. Using the drop-down arrow next to the Highlight tool (in the Font group), select a highlight color you want to use for your superscripts.These are great for adding math equations into documents as well as f. Making the superscripts stand out can be easily accomplished by using the Find and Replace capabilities built into Word. Learn how to easily add subscripts and superscripts into your Microsoft Word documents. As one of his proofreading steps he needs to check each of the superscripts, so he wonders if there is an easy way to highlight all of them so he can find them easily. The zipped file is in xlsm format, and contains macros.Anthony has a long Word document that includes a number of superscripts. On Sample Files page, go to the UserForms & VBA section, and look for UF0025 – Change Marked Text to Superscript. To see the sample file, and test the code, you can visit my Contextures website. NOTE: To make a Subscript macro, just change the “.Superscript = True” line to “.Subscript = True” Sub ChangeRedToSuperscript() You can use other color index numbers, instead of Red, if you prefer.
The sample code is shown below, and it will change all the Red characters to Superscript. Later, when you’ve entered all the data, select a range of cells, and run the macro to change all the red characters to Superscript. It’s easy to change the font colour – just right-click on the selected character and click on the Font colour command (NOTE: Use a different colour, if you’re already using Red font for other things in your file). While you’re entering the data, use Red font colour to mark the characters that you want as Superscript.It would take a while to run, on a big worksheet, but it’s better than changing each character manually! If you have a better solution, please let me know. When I saw the question on the Reddit site, it reminded me that I created a macro recently, to change characters to Superscript. Macro to Change Characters to Superscript It looks regular-sized in the formula bar, but you can see the smaller font in the cell. The selected character changes to Superscript.Add a check mark to the Superscript option, and click OK.OR, click the Dialog Launcher button at the bottom right corner of the Font group on the Ribbon’s Home tab.To open the Format Cells dialog box, press Ctrl + 1,.Select the character that you want to change to Superscript.Type the characters in the cell – CO2 in this example.
Here’s how you can change to Subscript manually: Of course, it really should be in Subscript, so you can follow these steps, but choose Subscript instead. Since there’s no QAT shortcut available, how do you add Superscript in a a cell? In this example, I’ll change “CO2”, so the “2” is in Superscript. “In Word you can add the subscript/superscript command, but in Excel, the subscript/superscript commands are not present in the list !!” Format as Superscript I don’t know how many people use Superscript in Excel every day, but one of the questions in the Excel team’s AMA on Reddit pointed out this missing feature: The Strikethrough command is available, but no Subscript or Superscript. You can see the Excel Customize screen below. Unfortunately, it’s not that easy in Excel – those commands aren’t available when you customize the QAT. Then, select a character, and click the Superscript command. When you do this, a box will appear on the screen. At the bottom of the references column, click on the downward-facing arrow in a box. Go to the top of your screen and click on references. After typing out the footnote, select it. In Word, you can add the Superscript and Subscript commands to the Quick Access Toolbar (QAT). Below, you will learn how to change footnotes into any format of your choosing. Here’s how to change characters to Superscript – you could use similar steps to change characters to Subscript. Do you ever use the Subscript or Superscript fonts formats in Excel? Maybe you’re reporting on chemical usage, and you need to enter CO 2 as one of the row headings.