[et_pb_section fb_built=”1″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” min_height=”4476.5px” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Google Sheets doesn\u2019t have a feature to add subscript text easily like in Google Docs. However, it is possible to achieve this and <\/span>we will cover two ways to add subscript in Google Sheets<\/b>.<\/span><\/p>\n The first method is straightforward, all you have to do is copy and paste. For the second you will need to use the CHAR function and Unicode numbers to get the desired character.<\/span><\/p>\n By the end, we will go over a few instances in which you might need to add subscript text.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”what” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Subscript text is positioned lower than the baseline of the surrounding characters, typically appearing at the bottom-right of a character. This formatting is commonly used to denote indices, subscripts, or coefficients in scientific or mathematical notation.<\/span><\/p>\n Read on to find out how to make small numbers in Google Sheets.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/05\/subscript_in_google_sheets_1.webp” alt=”how to subscript in google sheets 1″ title_text=”subscript_in_google_sheets_1″ align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”two” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We will cover two ways to insert subscript text in Google Sheets. <\/span>Both of these procedures rely on the character lists provided in the tables below<\/b>, so keep them handy!<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”copy” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This first method is as simple as it gets: just <\/span>copy the character you want from the list and paste it<\/b> into a cell in your spreadsheet.<\/span><\/p>\n Unfortunately,<\/span> not all letters have a matching subscript version<\/b>. That\u2019s why the table below includes some letters, and not the complete alphabet.<\/span>\u00a0<\/span><\/p>\n If you do this often it can become quite time consuming to go back and forth to copy and paste. In that scenario, the second method shines.<\/p>\n <\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”char” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The CHAR formula needs only one piece of information: the unicode number of the character you want.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =CHAR(unicode_number)<\/span><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Just insert the correct number from the tables below, and the formula will return the selected character.<\/span><\/p>\n Subscript characters and unicode numbers<\/span><\/p>\n<\/td>\n<\/tr>\n Numbers<\/span><\/p>\n<\/td>\n Symbols<\/span><\/p>\n<\/td>\n<\/tr>\n \u2080<\/span><\/p>\n<\/td>\n 8320<\/span><\/p>\n<\/td>\n \u208a<\/span><\/p>\n<\/td>\n 8330<\/span><\/p>\n<\/td>\n<\/tr>\n \u2081<\/span><\/p>\n<\/td>\n 8321<\/span><\/p>\n<\/td>\n \u208b<\/span><\/p>\n<\/td>\n 8331<\/span><\/p>\n<\/td>\n<\/tr>\n \u2082<\/span><\/p>\n<\/td>\n 8322<\/span><\/p>\n<\/td>\n \u208c<\/span><\/p>\n<\/td>\n 8332<\/span><\/p>\n<\/td>\n<\/tr>\n \u2083<\/span><\/p>\n<\/td>\n 8323<\/span><\/p>\n<\/td>\n \u208d<\/span><\/p>\n<\/td>\n 8333<\/span><\/p>\n<\/td>\n<\/tr>\n \u2084<\/span><\/p>\n<\/td>\n 8324<\/span><\/p>\n<\/td>\n \u208e<\/span><\/p>\n<\/td>\n 8334<\/span><\/p>\n<\/td>\n<\/tr>\n \u2085<\/span><\/p>\n<\/td>\n 8325<\/span><\/p>\n<\/td>\n \u2086<\/span><\/p>\n<\/td>\n 8326<\/span><\/p>\n<\/td>\n \u2087<\/span><\/p>\n<\/td>\n 8327<\/span><\/p>\n<\/td>\n \u2088<\/span><\/p>\n<\/td>\n 8328<\/span><\/p>\n<\/td>\n \u2089<\/span><\/p>\n<\/td>\n 8329<\/span><\/p>\n<\/td>\n \u00a0<\/span><\/p>\n Subscript characters and unicode numbers<\/span><\/p>\n<\/td>\n<\/tr>\n Letters<\/span><\/p>\n<\/td>\n<\/tr>\n Character<\/span><\/p>\n<\/td>\n Code<\/span><\/p>\n<\/td>\n Character<\/span><\/p>\n<\/td>\n Code<\/span><\/p>\n<\/td>\n<\/tr>\n \u2090<\/span><\/p>\n<\/td>\n 8336<\/span><\/p>\n<\/td>\n \u2092<\/span><\/p>\n<\/td>\n 8338<\/span><\/p>\n<\/td>\n<\/tr>\n \u2091<\/span><\/p>\n<\/td>\n 8337<\/span><\/p>\n<\/td>\n \u209a<\/span><\/p>\n<\/td>\n 8346<\/span><\/p>\n<\/td>\n<\/tr>\n \u2095<\/span><\/p>\n<\/td>\n 8341<\/span><\/p>\n<\/td>\n \u1d63<\/span><\/p>\n<\/td>\n 7523<\/span><\/p>\n<\/td>\n<\/tr>\n \u1d62<\/span><\/p>\n<\/td>\n 7522<\/span><\/p>\n<\/td>\n \u209b<\/span><\/p>\n<\/td>\n 8347<\/span><\/p>\n<\/td>\n<\/tr>\n \u2c7c<\/span><\/p>\n<\/td>\n 11388<\/span><\/p>\n<\/td>\n \u209c<\/span><\/p>\n<\/td>\n 8348<\/span><\/p>\n<\/td>\n<\/tr>\n \u2096<\/span><\/p>\n<\/td>\n 8342<\/span><\/p>\n<\/td>\n \u1d64<\/span><\/p>\n<\/td>\n 7524<\/span><\/p>\n<\/td>\n<\/tr>\n \u2097<\/span><\/p>\n<\/td>\n 8343<\/span><\/p>\n<\/td>\n \u1d65<\/span><\/p>\n<\/td>\n 7525<\/span><\/p>\n<\/td>\n<\/tr>\n \u2098<\/span><\/p>\n<\/td>\n 8344<\/span><\/p>\n<\/td>\n \u2093<\/span><\/p>\n<\/td>\n 8339<\/span><\/p>\n<\/td>\n<\/tr>\n \u2099<\/span><\/p>\n<\/td>\n 8345<\/span><\/p>\n<\/td>\n \u1d67<\/span><\/p>\n<\/td>\n 7527<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n After you get the character you can remove the formula by copying the result and pasting values only (<\/span>Right click a cell<\/b> ><\/span> Paste special<\/b> > <\/span>Values only<\/b>).<\/span><\/p>\n This method is particularly useful if you use these subscript characters frequently. If that\u2019s the case, you could write the codes down or memorize them. This ensures that they will always be handy.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”uses” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In this section we will cover some common uses of subscripting, as well as its importance in various fields.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”formulas” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Subscripting is key to display chemical formulas accurately; it allows you to include the number of atoms of each element. For example, “H\u2082O” represents water, with the “2” subscripted to indicate two hydrogen atoms.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”math” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Subscripting is also valuable for mathematical notation; you can use it for indices, subscripts, or coefficients in equations and formulas.<\/span><\/p>\n For instance, in the equation “a\u2081x + a\u2082y = b,” the subscripts “1” and “2” indicate coefficients associated with variables x and y, respectively.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”insert” _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Now you know two different ways to add subscript text to your spreadsheets. We even covered cases where this knowledge would be fundamental.<\/span><\/p>\nWhat is subscript text?<\/span><\/h2>\n
Two methods to subscript in Google Sheets<\/span><\/h2>\n
Copy subscript characters<\/span><\/h3>\n
\n
\n Subscript characters<\/td>\n<\/tr>\n \n Numbers<\/td>\n Letters<\/td>\n Symbols<\/td>\n<\/tr>\n \n \u2080<\/span><\/td>\n \u2090<\/span><\/td>\n \u209a<\/span><\/td>\n \u208a<\/span><\/td>\n<\/tr>\n \n \u2081<\/span><\/td>\n \u2091<\/span><\/td>\n \u1d63<\/span><\/td>\n \u208b<\/span><\/td>\n<\/tr>\n \n \u2082<\/span><\/td>\n \u2095<\/span><\/td>\n \u209b<\/span><\/td>\n \u208c<\/span><\/td>\n<\/tr>\n \n \u2083<\/span><\/td>\n \u1d62<\/span><\/td>\n \u209c<\/span><\/td>\n \u208d<\/span><\/td>\n<\/tr>\n \n \u2084<\/span><\/td>\n \u2c7c<\/span><\/td>\n \u1d64<\/span><\/td>\n \u208e<\/span><\/td>\n<\/tr>\n \n \u2085<\/span><\/td>\n \u2096<\/span><\/td>\n \u1d65<\/span><\/td>\n <\/td>\n<\/tr>\n \n \u2086<\/span><\/td>\n \u2097<\/span><\/td>\n \u2093<\/span><\/td>\n <\/td>\n<\/tr>\n \n \u2087<\/span><\/td>\n \u2098<\/span><\/td>\n \u1d67<\/span><\/td>\n <\/td>\n<\/tr>\n \n \u2088<\/span><\/td>\n \u2099<\/span><\/td>\n <\/td>\n <\/td>\n<\/tr>\n \n \u2089<\/span><\/td>\n \u2092<\/span><\/td>\n <\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Use the CHAR function<\/span><\/h3>\n
\n\n
\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n <\/td>\n <\/td>\n<\/tr>\n \n \n \n <\/td>\n <\/td>\n<\/tr>\n \n \n \n <\/td>\n <\/td>\n<\/tr>\n \n \n \n <\/td>\n <\/td>\n<\/tr>\n \n \n \n <\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \n\n
\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n Subscripting uses<\/span><\/h2>\n
Subscripting for chemical formulas in Google Sheets<\/span><\/h3>\n
Add subscript for mathematical notation in Google Sheets<\/span><\/h3>\n
That\u2019s how to insert subscript in Sheets<\/span><\/h2>\n