islamloha.blogg.se - Excel chemistry add in

#Excel chemistry add in how to

Prior to applying subscript format, ensure to convert the cell to text values if it contains a number or formula.The text value can be formatted only in a word document as a subscript with the subscript button. Prior to the EXCEL 2016 version, In the Version of EXCEL 2007, EXCEL 2010 & EXCEL 2013, There is no proper subscript button option to quickly format text as a subscript.Things to Remember About Subscript Function in Excel when you present an equation or a formula in numeric value. The subscript option can also be applied to a numeric value, i.e.In Microsoft Excel, there is no option, or it does not provide any shortcuts or character codes to insert subscripted text or number.To remove superscripts, you have to simply select the cell format in the Format Cells dialog box, under the Font tab, uncheck or untick the Subscript option under Effects or set the cell format back to General.Here visual changes or representation can be seen in the text value of a cell, i.e. The whole text in cell “B16” will get converted to a subscript format. In the Format Cells dialog box, under the Font tab, select the Subscript option under Effects.Īt last, Click OK to save the change and close the dialog box. Open a format cell dialog box by clicking or pressing ctrl+1 or right-click in mouse and select format cells option in it. Here in that text value, I have to apply a Subscript format to the entire whole cell text.Ĭlick on cell “B16” press the F2 key so that the text value in cell B16 text get in to edit mode. In the below-mentioned cell, “B16” contains the word or text value, i.e.

#Excel chemistry add in how to

How To Apply Subscript Format To The Whole Cell Text Note: If you check the text in a formula toolbar, it will display the original text value without any indication of the applied subscript format. Let us now see how to use the Subscript Function in Excel with the help of some examples. This Subscript Function is very simple easy to use. Once applied, you can see the change in the Quick Access Toolbar button at the top left corner, where it enables you to use the subscript format in Excel 2016 with a single key option.

Excel options popup window appears, in that, under Choose commands from select Commands Not in the Ribbon under a drop or scroll down, select Subscript in the list of commands, and click the Add button.

You have to click the down arrow next to the Quick Access Toolbar (QAT) on the upper left corner of the Excel window and select More Commands options from the pop-up menu.

To set up this, we have to follow the below-mentioned steps In Excel 2016, you have an option to add Subscript buttons to Quick Access Toolbar (QAT). How to Add Subscript icon to Quick Access Toolbar (Qat)?

Then, In the final step, hit the Enter key to apply the formatting and close the dialog box.

Once the Format Cells dialog box appears, then press or click on Alt + B to select Subscript.

Then Press Ctrl + 1 to open the Format Cells dialog box.

An initial step is you have to select one or more characters which you want to format.

The above shortcut key is not pressed simultaneously the below-mentioned process does it.

This is carried out with the help of a couple of key combinations i.e. Shortcut Key or keyboard shortcut for a Subscript format in Excel Usually, it is very smaller in size than the normal text value & visible below the baseline. Appearance of the Subscript format: TABLE 1

Subscript: It is a small character or string that fits or sits just below the line of text.Į.g.

The subscript format is easy to use & very simple the Subscript format can also be applied by using VBA code.

electron, muon, and tau neutrinos which are denoted as ν e, ν μ and ν τ.

The subscript is also used to differentiate between different types of subatomic particles.

These mathematical & chemical equations require a Subscript format for a better visual appearance. chemical formulas such as butane C 2H 5, C 6H 6, NO 2, and various other formulas.

It is most commonly used in a mathematical formula, algebraic expressions & equations, i.e., writing number base value OR bases like 49 7, whereas, in chemistry, it is used in the specification of chemical substance or compounds.

Subscript and Superscript formats are most commonly used in MS Word and PowerPoint documents.

Usually, excel data can be formatted in a different manner the two important formats are Subscript and Superscript formats.

Excel functions, formula, charts, formatting creating excel dashboard & others