Alif Bin Hussain
We often need to write different mathematical, chemical, or other types of expressions while presenting data in Excel. Most of the equations have subscripts and superscripts in them. We can write these subscripts and superscripts in Excel in various ways. CO2 can be written in Excel by converting the “2” into a subscript. In this article, we will demonstrate how to write CO2 in Excel in 5 easy methods.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
5 Suitable Ways to Write CO2 in Excel
In this article, we will learn how to write CO2 in Excel in 5 easy methods. For this purpose, we will use the following dataset.
1. Utilize Format Cells Feature
In the first method, we will use the Format Cells feature to write CO2 in Excel. Read the following steps to learn.
Steps:
- First of all, write CO2 in a cell and highlight the “2”.
- Next, Click on the arrow at the bottom right corner of the Font setting from the ribbon.
- It will launch the Format Cells dialogue box.
- In the Format Cells window, check the box of Subscript.
- Now you can see that “2” is turned into a subscript and CO2 is written in the proper format.
Read More: How to Write Subscript in Excel (11 Easy Ways)
2. Insert an Equation
In this method, we will write CO2 by inserting an equation. The procedure is discussed below.
Steps:
- First, click on the Insert tab.
- Now, from the ribbon, click on Symbols and then select Equation.
- Choose any of the convenient options. We chose Area of Circle.
- A text box to write equations will open.
- Next, highlight the inside of the text box and go to the Equation tab.
- Select the Script and choose the 2nd option from there.
- You will see two boxes. The large box is for normal text and the small box next to it is for subscripts.
- Type “CO” in the large box and “2” in the small box.
- Thus, you will get the result in the desired format.
Read More: How to Add Subscript in Excel Graph (7 Easy Methods)
3. Use Keyboard Shortcut
This is the quickest way to write CO2 in the desired format. Follow these steps to use the keyboard shortcut.
Steps:
- To begin with, type CO2 in a cell and highlight the “2”.
- Press Ctrl+1 to open the Format Cells window.
- Then press Alt+B to make the “2” a subscript.
- Press Enter and get the result.
Read More: [Solved:] Excel Subscript Not Working
4. Add a Button
Now we will add a button to convert a text into a subscript and then use it to write CO2 in the correct format. Keep on reading to learn how to do it.
Steps:
- First of all, click on the down arrow from the Quick Access Toolbar.
- Then select More Commands. A pop-up window will appear.
- In the pop-up window, click on Quick Access Toolbar and then select Subscript.
- Next, press Add to add a button of subscript in the Quick Access Toolbar.
- Click Ok.
- If you look at the Quick Access Toolbar now, you will see the X2 button.
- Now write CO2 and highlight the “2”.
- Then click on the X2 It will turn the “2” into a subscript.
- When the X2 button is added to the Quick Access Toolbar, Excel automatically assigns a shortcut key to it.
- In this case, Excel assigned “5” to the subscript button.
- Therefore, pressing Alt+5 will also change the text format into subscripts.
- After changing the format of “2”, you will get the CO2 in the correct form.
5. Copy-paste the Subscripts
In this method, we will provide you with the already subscripted forms of numbers from 1 to 10. You can just copy-paste it to your Excel file.
Steps:
- First, copy the number “2” from below.
1 2 3 4 5 6 7 8 9 0 + – * / = ( )
- Now write CO in the Excel cell and paste the “2” next to it.
- It will get you the CO2 in the desired format.
Things to Remember
- You can add a subscript button in the Quick Access Toolbar or you can add it to any tabs you want.
- While using the equation to write CO2, you can move the text box freely. Use your mouse to move it to the desired location.
Concluding Remarks
Thanks for making it this far. I hope you find this article useful. Now you know 5 different methods to write CO2 in Excel. Please let us know if you have any further queries and feel free to give us any recommendations in the comment section below.
