Instructions for creating superscript, subscript in Excel

Microsoft Excel is known for its main functions of computation, but sometimes we have to write exponential formulas in e ^x , x ² , y ³ .) or molecular formulas in chemistry. learn (H ₂ O, H ₂ CO ₃ , .), formulas in physics . how to write. The article I will guide you to write the superscript and subscript in Excel.

Instructions for creating superscript, subscript in Excel Picture 1

How to create indexed exponential numbers on subscript in Excel

Step 1: Right-click the number and select Format Cells

Instructions for creating superscript, subscript in Excel Picture 2

Step 2: The Format Cells dialog box appears, we do:

- If creating the above index, select Superscript as shown

Instructions for creating superscript, subscript in Excel Picture 3

And the result is

Instructions for creating superscript, subscript in Excel Picture 4

- If creating subscript, select Subscript as shown

Instructions for creating superscript, subscript in Excel Picture 5

Finally, we get the result:

Instructions for creating superscript, subscript in Excel Picture 6

The index is in excel the index is in excel

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

Instructions on how to create diagonal lines in Excel box
manipulating 1 cell into 2 diagonal triangles with a line on excel is a very basic operation and is often performed during the process of creating tables on excel.
Instructions on how to cross cells in Excel
the operation of dividing 1 cell into 2 diagonal triangle cells with a line in excel is an extremely basic operation and is often performed in the process of creating tables in excel.
How to create a Kanban table in Excel
creating a kanban table in excel is not too difficult. the article will guide you in detail how to create a kanban board using microsoft excel.
Instructions for creating shortcuts in Excel
in a long document, repetition of words, phrases, and word combinations often happens so that to save time editing text faster than microsoft excel has supported a feature that allows users to create keys. turn off.
Instructions on how to create flashing text in Excel
want to highlight information in excel? creating flashing text will help attract attention, and it's very simple to do.
Instructions for creating charts in Excel 2007 or 2010
the chart is a very effective way of displaying data in computational or statistical programs, especially microsoft excel. in the tutorial below, we will cover the basic operations to create a chart from the data table in excel 2007 or 2010 version ...
Instructions for creating charts in Excel 2007
excel always provides an easy tool for you to create charts from existing data tables and in excel 2007 it will become easier.
How to use Style in Excel
how to use style in excel. instructions for applying the available style formats in excel and creating new styles yourself.
How to number columns automatically in Excel
in excel, there is an automatic column numbering feature, so users will not need to perform the dragging of the order as usual.
Instructions on how to create input forms in Excel extremely fast and simple
creating an input form in excel is a very necessary tip if you are an accountant or office worker. it helps you to make statistics and input data for excel simpler and faster. below, tipsmake will guide you the most basic steps to create a simple input form.