2 Ways to Create Upper and Lower Powers in Excel (Complete+Picture)

Two ways to create upper and lower rank in microsoft excel with keyboard. Both Superscript and Subscript rank.

As we know, that Excel is usually associated with numbers although it is possible that it is related to word processing as well. Not infrequently Excel users will struggle with various kinds of formulas that are hated by some people.

Its use, which is also often related to calculations in certain categories, requires number operations to exponents. The good news, Microsoft Excel provides a feature or tool to make numbers can be raised to powers.

Then how to make a rank in Excel? This article will explain to you about how to create a rank in Excel very easily. Let’s see the explanation below.

How to Create Upper and Lower Powers in Excel

As for making numbers to exponents in Excel, we can using superscript and subscript functions. Both of these features are already embedded by Microsoft Excel so that users will be able to solve this problem. However, the way to create rank in Microsoft Excel is different from creating rank in Microsoft Word. Just follow the steps below.

A. Creating Top Rank With Superscript

The superscript function is a function that is used to make text (letters, numbers, and symbols) to the highest rank. With this function, the text that is given the superscript function will be in a higher position but still in a straight line of writing. Then, the text will also be smaller than the text that is not given the superscript function.

1. Open Microsoft Excel > then type text who want to be made into the top rank.

2. Then writing block who want to be made into the top rank > then right click on the post > then select Format Cells.

Note: In addition to that method, there are 2 quick ways to be able to open the Format cell dialog box only by using a keyboard combination. That is press Shift + Ctrl + F or press Ctrl + 1 on the keyboard.

3. Then the Format Cells dialog box will appear. Look in the Effects section, then select or check superscript to make the writing to the top rank > select OK.

4. The writing will be in the upper rank as shown below.

B. Creating Lower Ranks With Subscript

The opposite of superscript, this subscript function is used to make text (letters, numbers, and symbols) to the lower rank. With this function, the text that is given the subscript function will be in a position further down but still in a straight line of writing. Just like the previous function, subscript will also make the text smaller than the text that is not given this function.

1. Open Microsoft Excel > then type text who want to be made into a lower rank.

2. Next writing block who want to be made into the top rank > then right click on the post > then select Format Cells.

Note: In addition to that method, there are 2 quick ways to be able to open the Format cell dialog box only by using a keyboard combination. That is press Shift + Ctrl + F or press Ctrl + 1 on the keyboard.

3. Then the Format Cells dialog box will appear. Look in the Effects section, then select or check subscript to make writing to lower rank > select OK.

4. The writing will be in the lower rank as shown below.

A few articles about how to make an upper or lower rank in Microsoft Excel. In making posts of rank above and below we only need to use the superscript and subscript features.

With this function, we can not only write in the form of numbers with powers but can also be in the form of letters and symbols. Keep visiting Nesabamedia to get interesting and latest information. Hopefully useful for you and good luck.

Introverted woman. Has a personality that enjoys ‘me time’ more, the beach, and the mountains.

Share :