Are you wondering how to write subscript in Google Sheets? You are not alone. While the subscript feature isn’t directly available in Google Sheets, there are a couple of workarounds that can help you achieve this function. This blog post will guide you through these methods to make your task of writing subscript in Google Sheets easier.
Method 1: Using the CHAR function
The most common way to create subscript in Google Sheets is by using the CHAR function. This function allows you to insert special characters into your cells, including subscript numbers.
Here’s an example of how to use the CHAR function to create a subscript:
=CHAR(8320)
The number 8320 represents the subscript for the number 0. Replace 8320 with these codes to use other subscript numbers:
1: 8321
2: 8322
3: 8323
4: 8324
5: 8325
6: 8326
7: 8327
8: 8328
9: 8329
Now, if you want to write ‘H20’ with the ‘2’ as a subscript, you would use:
="H"&CHAR(8322)&"O"
Method 2: Using Copy-Paste Method
Another method of inputting subscript in Google Sheets is the copy-paste method. This is more straightforward and involves simply copying a subscripted character from a webpage and pasting it into your Google Sheets cell.
Here’s a step by step guide to accomplish this:
- Find a webpage that has the subscript character you need.
- Select the subscript character, and then right-click and select ‘Copy’.
- Go back to your Google Sheets document, right-click on the cell where you want to place the subscript, then click ‘Paste’.
Please note that this method only works for characters that are already in subscript format on a webpage.
Conclusion
While Google Sheets does not have a direct feature to create subscript, these workarounds make it possible. Whether you prefer using the CHAR function or the copy-paste method, both provide solutions to write subscript in Google Sheets.
Hope this guide has been helpful and you now feel confident about writing subscript in Google Sheets. Happy spreadsheeting!
