How to Write CO2 in Excel (5 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Write CO2 in Excel (5 Suitable Ways)

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.

How to write CO2 in Excel


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.

Use format cells to write CO2 in Excel

  • In the Format Cells window, check the box of Subscript.

Use format cells to write CO2 in Excel

  • Now you can see that “2” is turned into a subscript and CO2 is written in the proper format.

Use format cells to write CO2 in Excel

Read More: How to Write Subscript in Excel


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 the Area of a Circle.

Insert an equation to write CO2 in Excel

  • 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.

Insert an equation to write CO2 in Excel

  • You will see two boxes. The large box is for normal text and the small box next to it is for subscripts.

Insert an equation to write CO2 in Excel

  • Type “CO” in the large box and “2” in the small box.

Insert an equation to write CO2 in Excel

  • Thus, you will get the result in the desired format.

Insert an equation to write CO2 in Excel


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.

Use keyboard shortcut to write CO2 in Excel

  • Press Enter and get the result.

Use keyboard shortcut to write CO2 in Excel


4. Add a Button in Quick Access Toolbar

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 the Quick Access Toolbar and then select Subscript.
  • Next, press Add to add a button of subscript in the Quick Access Toolbar.
  • Click Ok.

Add a button to write CO2 in Excel

  • 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.

Add a button to write CO2 in Excel

  • 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.

Add a button to write CO2 in Excel


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.

Copy-paste to write CO2 in Excel


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.

Download Practice Workbook


Back to Learn Excel > Formatting Text > Subscript and Superscript


Conclusion

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.


Related Articles


<< Go Back to Subscript and Superscript | Text Formatting | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alif Bin Hussain
Alif Bin Hussain

Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo