Superscript is used in excel when input mathematical and scientific data. Things to Remember About the Superscript in Excel Here it is 5 marked in the above picture for reference. Observe that number and click that number on the keyboard. The superscript option on the Quick Access toolbar will highlight with a number as shown below: Input the required text in the excel cell, select which you want to convert as superscript, and then press the ALT button from the keyboard. If we want to input superscript text by a keyboard shortcut, then it is very easy. Similarly, we can input superscript 1 and 3 also. Now we can check the excel sheet all the selected numbers have power 2. Hold the ALT key and give the number 0178, then zero become zero square. From that popup, choose format cells.Īfter that, select “custom” at the bottom and select “zero” as marked in the picture.
Let’s take the example of 5 numbers to which we want to apply superscript 2. Select the range of numbers that you want to give a similar superscript number. Superscript in Excel Example #4 – Superscript for multiple numbers at a time Once your text is over, click on “Insert” at the bottom of the box. Once you click on “Ink Equation”, another screen will pop up there you can write the required text manually using your mouse. On the left-hand side, we can observe the “Ink Equation” option. Select the first cell and give the Base number and then select the small box at the top to give the power.Īnother way is when you click on the “Equation”, it will take you to the “design” menu. We can observe a pattern in the cell, as shown in the below picture. If we observe the righthand side, we can observe the option” Equation”, which is marked.Ĭlick on the option “Equation”, and then the menu changes to design.Ĭlick on the “e x” option, which is marked then the dropdown will come from that drop-down select the format for superscript, which I marked in the below picture. To apply superscript for numbers, follow the below steps.Ĭlick on the “Insert” at the top. The movement you move from the cell it will convert to normal numbers. you can try in both ways, whether from QAT or from right-click.
Whatever the process we discussed up to now will not work for numbers, i.e. Superscript in Excel Example #2 – Applying Superscript for number If you want to remove the superscript, just reselect the X 2 command then it will be converted to the normal text again. Now it is easy to input superscript just select the letter or text you want to convert as superscript and click on the X 2 option in the Quick access toolbar. Now we can observe the QCT there is an additional option visible that is x 2 marked in the picture. Once you click on “add”, the superscript will move from left to right side QCT rectangular box.Īnd then click on the “Ok” button at the bottom the menu will close and return to excel. One can scroll, select the required commands and click on “Add” to add to the QCT as we required the Superscript command, search for that, select superscript and click on Add. We can observe there are multiple numbers of commands available in the rectangle screen. When you click on the “Options”, another screen will come, as shown below.įrom the above screen, select “Quick Access Toolbar”, which is highlighted left-hand side. From that drop-down menu, select “Options”.
HOW TO MAKE A SUPERSCRIPT IN PAGES HOW TO
Here are the steps on how to do that.įor people who not aware quick access toolbar, below is the screenshot.Ĭurrently, we have “Save”, “Undo”, “Redo” hence we need to add the “Superscript” option to QCT.Ĭlick on the “File” menu the following dropdown menu will come. We can input superscript through QCT also.
HOW TO MAKE A SUPERSCRIPT IN PAGES DOWNLOAD
You can download this Superscript Excel Template here – Superscript Excel Template Superscript in Excel Example #1 -Through Quick access toolbar(QCT) Then the “format cells” menu will appear.įrom the menu “ Font”, we can select the required font for the superscript. Once you select the number 2, right-click on the mouse, a pop up will come, as shown in the below picture.įrom the popup menu, select Format cells. I am giving the screenshot for a better understanding. Now select number 2 alone by clicking F2 and select 2 or double click on the cell and select 2 alone. Input X2 in any of the cell where you required the superscript. It is very easy to input superscript text in Excel follow these simple steps. I hope you all understand what superscript is. Sin 2(30) – Here, superscript is ‘2’, which is a number for its previous string ‘sin’.2 nd – Here, the superscript is ‘nd’ which is a string for its previous number 2.Here, superscript is ‘b’, which is a character for its previous character.X 2 – Here, the superscript is ‘2’, which is a number for its previous character X.Excel functions, formula, charts, formatting creating excel dashboard & others
0 kommentar(er)
