{"id":48941,"date":"2024-05-01T16:37:29","date_gmt":"2024-05-01T14:37:29","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=48941"},"modified":"2026-10-12T15:58:39","modified_gmt":"2026-10-12T13:58:39","slug":"comment-utiliser-lindice-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/how-to-subscript-in-google-sheets\/","title":{"rendered":"Comment utiliser l'indice dans Google Sheets"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; min_height=&#8221;4476.5px&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Google Sheets doesn\u2019t have a feature to add subscript text easily like in Google Docs. However, it is possible to achieve this and <b>we will cover two ways to add subscript in Google Sheets<\/b>.<\/p>\n<p>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.<\/p>\n<p>You&#8217;ll also see how to add a subscript right after a word with a formula, and how to import a full table of subscript characters into your spreadsheet. By the end, we will go over a few instances in which you might need to add subscript text.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is subscript text?<\/h2>\n<p>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.<\/p>\n<p>Read on to find out how to make small numbers in Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/05\/subscript_in_google_sheets_1.webp&#8221; alt=&#8221;Subscript text \u2014 printed system of equations with subscripted variables x1 to x4&#8243; title_text=&#8221;Printed system of equations with subscripted variables x1 to x4&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;two&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to add subscript in Google Sheets<\/h2>\n<p>We will cover two ways to insert subscript text in Google Sheets. <b>Both of these procedures rely on the character lists provided in the tables below<\/b>, so keep them handy!<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;copy&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Copy subscript characters<\/h3>\n<p>This first method is as simple as it gets: just <b>copy the character you want from the list and paste it<\/b> into a cell in your spreadsheet.<\/p>\n<p>Unfortunately,<b> not all letters have a matching subscript version<\/b>. That\u2019s why the table below includes some letters, and not the complete alphabet.\u00a0<\/p>\n<table xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\" cellspacing=\"0\" cellpadding=\"0\" dir=\"ltr\" border=\"1\">\n<colgroup>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/><\/colgroup>\n<tbody>\n<tr>\n<td rowspan=\"1\" colspan=\"4\" style=\"text-align: center;\">Subscript characters<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">Numbers<\/td>\n<td rowspan=\"1\" colspan=\"2\" style=\"text-align: center;\">Letters<\/td>\n<td style=\"text-align: center;\">Symbols<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2080<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2090<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u209a<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u208a<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2081<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2091<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u1d63<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u208b<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2082<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2095<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u209b<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u208c<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2083<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u1d62<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u209c<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u208d<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2084<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2c7c<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u1d64<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u208e<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2085<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2096<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u1d65<\/span><\/td>\n<td style=\"text-align: center;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2086<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2097<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2093<\/span><\/td>\n<td style=\"text-align: center;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2087<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2098<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u1d67<\/span><\/td>\n<td style=\"text-align: center;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2088<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2099<\/span><\/td>\n<td style=\"text-align: center;\"><\/td>\n<td style=\"text-align: center;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2089<\/span><\/td>\n<td style=\"text-align: center;\"><span style=\"font-size: x-large;\">\u2092<\/span><\/td>\n<td style=\"text-align: center;\"><\/td>\n<td style=\"text-align: center;\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>To add a subscript to text that&#8217;s already in a cell, double-click the cell, place the cursor where the subscript goes, and paste with Ctrl+V (Cmd+V on Mac).<\/p>\n<p>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<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;char&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Use the CHAR function<\/h3>\n<p>The CHAR formula needs only one piece of information: the unicode number of the character you want.<\/p>\n<p>[\/et_pb_text][et_pb_text module_class=&#8221;spreadsheet-function&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>=CHAR(unicode_number)<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Just insert the correct number from the tables below, and the formula will return the selected character.<\/p>\n<table>\n<tbody>\n<tr>\n<td colspan=\"4\" style=\"text-align: center;\">\n<p>Subscript characters and unicode numbers<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" style=\"text-align: center;\">\n<p>Numbers<\/p>\n<\/td>\n<td colspan=\"2\" style=\"text-align: center;\">\n<p>Symbols<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2080<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8320<\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u208a<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8330<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2081<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8321<\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u208b<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8331<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2082<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8322<\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u208c<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8332<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2083<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8323<\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u208d<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8333<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2084<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8324<\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u208e<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p style=\"text-align: center;\">8334<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2085<\/span><\/p>\n<\/td>\n<td>\n<p>8325<\/p>\n<\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2086<\/span><\/p>\n<\/td>\n<td>\n<p>8326<\/p>\n<\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2087<\/span><\/p>\n<\/td>\n<td>\n<p>8327<\/p>\n<\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2088<\/span><\/p>\n<\/td>\n<td>\n<p>8328<\/p>\n<\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: x-large;\">\u2089<\/span><\/p>\n<\/td>\n<td>\n<p>8329<\/p>\n<\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center;\">\u00a0<\/p>\n<table>\n<tbody>\n<tr style=\"text-align: center;\">\n<td colspan=\"4\">\n<p>Subscript characters and unicode numbers<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td colspan=\"4\">\n<p>Letters<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p>Character<\/p>\n<\/td>\n<td>\n<p>Code<\/p>\n<\/td>\n<td>\n<p>Character<\/p>\n<\/td>\n<td>\n<p>Code<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2090<\/span><\/p>\n<\/td>\n<td>\n<p>8336<\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2092<\/span><\/p>\n<\/td>\n<td>\n<p>8338<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2091<\/span><\/p>\n<\/td>\n<td>\n<p>8337<\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u209a<\/span><\/p>\n<\/td>\n<td>\n<p>8346<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2095<\/span><\/p>\n<\/td>\n<td>\n<p>8341<\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u1d63<\/span><\/p>\n<\/td>\n<td>\n<p>7523<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u1d62<\/span><\/p>\n<\/td>\n<td>\n<p>7522<\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u209b<\/span><\/p>\n<\/td>\n<td>\n<p>8347<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2c7c<\/span><\/p>\n<\/td>\n<td>\n<p>11388<\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u209c<\/span><\/p>\n<\/td>\n<td>\n<p>8348<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2096<\/span><\/p>\n<\/td>\n<td>\n<p>8342<\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u1d64<\/span><\/p>\n<\/td>\n<td>\n<p>7524<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2097<\/span><\/p>\n<\/td>\n<td>\n<p>8343<\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u1d65<\/span><\/p>\n<\/td>\n<td>\n<p>7525<\/p>\n<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2098<\/span><\/p>\n<\/td>\n<td>\n<p>8344<\/p>\n<\/td>\n<td>\n<p><span style=\"font-weight: 400; font-size: large;\">\u2093<\/span><\/p>\n<\/td>\n<td>\n<p>8339<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: large;\">\u2099<\/span><\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p>8345<\/p>\n<\/td>\n<td style=\"text-align: center;\">\n<p><span style=\"font-weight: 400; font-size: large;\">\u1d67<\/span><\/p>\n<\/td>\n<td>\n<p style=\"text-align: center;\">7527<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>After you get the character you can remove the formula by copying the result and pasting values only (<b>Right click a cell<\/b> &gt;<b> Paste special<\/b> &gt; <b>Values only<\/b>).<\/p>\n<p>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.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-add-subscript-to-text-with-the-ch&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to add subscript to text with the CHAR function<\/h2>\n<p>CHAR on its own returns a single character. To put a subscript right after a word, join the word and the character with an ampersand (&amp;). In this example, a subscript x goes after the word total. The code for a subscript x is 8339, and the tables above list the codes for the other characters.<\/p>\n<p><strong>1.<\/strong> In an empty cell, type the equal sign. Between quotation marks, type the letter or word that requires the subscript.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-word-in-quotes.webp&#8221; alt=&#8221;Subscript in Google Sheets \u2014 the word total typed in quotes after an equal sign in A3&#8243; title_text=&#8221;The word total typed in quotes after an equal sign in A3&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Add an ampersand (&amp;), followed by the CHAR function.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-ampersand-char.webp&#8221; alt=&#8221;CHAR subscript in Google Sheets \u2014 ampersand and CHAR added after the word total in A3&#8243; title_text=&#8221;Ampersand and CHAR added after the word total in A3&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> The code you use for the CHAR function depends on which subscript character you want. In this case, a lowercase x has the following decimal code: 8339.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-char-8339.webp&#8221; alt=&#8221;CHAR subscript in Google Sheets \u2014 code 8339 typed inside the CHAR function&#8221; title_text=&#8221;Code 8339 typed inside the CHAR function&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Close the parenthesis and press Enter. The full formula is =&quot;total&quot;&amp;CHAR(8339), and the cell shows total\u2093.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-char-result.webp&#8221; alt=&#8221;Subscript in Google Sheets \u2014 A3 shows total with a subscript x after the formula runs&#8221; title_text=&#8221;A3 shows total with a subscript x after the formula runs&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-import-a-table-of-subscript-chara&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to import a table of subscript characters with IMPORTHTML<\/h2>\n<p>If you plan to use subscripts and superscripts frequently, consider importing a table of subscript and superscript Unicode characters with the <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/importhtml-formula-google-sheets\/\">IMPORTHTML function<\/a>. Once it&#8217;s imported, you can copy characters or look up CHAR codes without leaving your spreadsheet. I will import the table from the <a href=\"https:\/\/en.m.wiktionary.org\/wiki\/Appendix:Unicode\/Superscripts_and_Subscripts\" target=\"_blank\" rel=\"noopener\">Wiktionary Appendix on Unicode subscripts and superscripts<\/a>. However, you can use whatever source you prefer.<\/p>\n<p><strong>1.<\/strong> In separate cells, type the URL of the page and the HTML element. Here, the URL goes in A1 and the word table goes in A2.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-importhtml-url-table.webp&#8221; alt=&#8221;Import subscript characters in Google Sheets \u2014 Wiktionary URL in A1 and the word table in A2&#8243; title_text=&#8221;Wiktionary URL in A1 and the word table in A2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> In another cell, type the IMPORTHTML function and select the cell containing the URL.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-importhtml-select-url.webp&#8221; alt=&#8221;IMPORTHTML subscript table in Google Sheets \u2014 IMPORTHTML typed in A3 with A1 as the URL&#8221; title_text=&#8221;IMPORTHTML typed in A3 with A1 as the URL&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Add a comma and select the cell containing the HTML element.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-importhtml-query.webp&#8221; alt=&#8221;IMPORTHTML subscript table in Google Sheets \u2014 A2 added as the query argument&#8221; title_text=&#8221;A2 added as the query argument&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Add another comma and type the index of the table you want. In this case, it\u2019s table 2.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-importhtml-index.webp&#8221; alt=&#8221;IMPORTHTML subscript table in Google Sheets \u2014 index 2 added to IMPORTHTML(A1,A2,2)&#8221; title_text=&#8221;Index 2 added to IMPORTHTML(A1,A2,2)&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> Close the parenthesis and press Enter to import the table. The full formula is =IMPORTHTML(A1,A2,2).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-unicode-table-imported.webp&#8221; alt=&#8221;Unicode subscript table in Google Sheets \u2014 imported code points, characters, and names&#8221; title_text=&#8221;Imported code points, characters, and names&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> Now that you have imported the table, you can easily use the copy &amp; paste method to add subscripts and superscripts in your cells. The table lists the superscripts first, and the subscripts start at code point U+2080. The number in parentheses next to each code point is the decimal code to use with CHAR.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/subscript-google-sheets-copy-from-table.webp&#8221; alt=&#8221;Unicode subscript table in Google Sheets \u2014 decimal code 8304 marked and a character being copied&#8221; title_text=&#8221;Decimal code 8304 marked and a character being copied&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;uses&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Subscripting uses<\/h2>\n<p>In this section we will cover some common uses of subscripting, as well as its importance in various fields.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;formulas&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Subscripting for chemical formulas in Google Sheets<\/h3>\n<p>Subscripting is key to display chemical formulas accurately; it allows you to include the number of atoms of each element. For example, &#8220;H\u2082O&#8221; represents water, with the &#8220;2&#8221; subscripted to indicate two hydrogen atoms.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;math&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Add subscript for mathematical notation in Google Sheets<\/h3>\n<p>Subscripting is also valuable for mathematical notation; you can use it for indices, subscripts, or coefficients in equations and formulas.<\/p>\n<p>For instance, in the equation &#8220;a\u2081x + a\u2082y = b,&#8221; the subscripts &#8220;1&#8221; and &#8220;2&#8221; indicate coefficients associated with variables x and y, respectively.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;insert&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>That\u2019s how to insert subscript in Sheets<\/h2>\n<p>Now you know two ways to add subscript text to your spreadsheets, how to add a subscript after a word with CHAR, and how to import a table of subscript characters with IMPORTHTML. We even covered cases where this knowledge would be fundamental.<\/p>\n<p>The procedure to add superscript is exactly the same. For a set of characters specific for that purpose, check out <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-superscript-in-google-sheets\/\">How to superscript in Google Sheets<\/a>.<\/p>\n<p>For more ways to format text in Google Sheets, see how to <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-indent-in-google-sheet\/\">indent in Google Sheets<\/a>, <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-add-bullet-points-in-google-sheets\/\">add bullet points<\/a>, or <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/google-sheets-new-line-in-cell\/\">insert a new line in a cell<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets doesn\u2019t have a feature to add subscript text easily like in Google Docs. However, it is possible to achieve this and we will cover two ways to add subscript in Google Sheets. The first method is straightforward, all you have to do is copy and paste. For the second you will need to [&hellip;]<\/p>\n","protected":false},"author":33,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-48941","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/48941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/33"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=48941"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/48941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=48941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=48941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=48941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}