{"id":48926,"date":"2024-04-30T20:26:55","date_gmt":"2024-04-30T18:26:55","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=48926"},"modified":"2025-12-17T19:55:18","modified_gmt":"2025-12-17T18:55:18","slug":"comment-mettre-en-exposant-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/how-to-superscript-in-google-sheets\/","title":{"rendered":"Comment mettre en exposant dans Google Sheets"},"content":{"rendered":"

[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” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Adding superscript in Google Sheets is not as simple as it is in Google Docs. Still, there are a couple of workarounds to do it.<\/span><\/p>\n

In this article we will explore two ways to superscript in Sheets. The first is pretty simple and just involves copying and pasting. The second uses the CHAR function along with Unicode numbers to return the desired character.<\/span><\/p>\n

We will also explore a couple of cases where superscripting may come in handy.<\/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

What is superscript?<\/span><\/h2>\n

Superscript text is positioned higher than the baseline of the surrounding characters, often appearing at the top-right of a character. It is commonly used to denote exponents, footnotes, or ordinal numbers.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/05\/superscript_in_google_sheets_1.webp” alt=”how to superscript in google sheets 1″ title_text=”superscript_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

Two ways to superscript in Google Sheets<\/span><\/h2>\n

Let\u2019s go over the two methods to add superscript text in Google Sheets. Both of them have reference characters and codes. It\u2019s a good idea to bookmark this post if you do this often \ud83d\ude09.<\/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

Copy superscript characters<\/span><\/h3>\n

The first method is super straightforward: just <\/span>copy the desired character from the table below and paste it<\/b> into your spreadsheet.<\/span><\/p>\n

This approach is useful if you do this sporadically, as it involves finding the symbol you want to use first.<\/span><\/p>\n

<\/google-sheets-html-origin><\/span><\/p>\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Superscript characters<\/strong><\/td>\n<\/tr>\n
Numbers<\/strong><\/td>\nLetters<\/strong><\/td>\nSymbols<\/strong><\/td>\n<\/tr>\n
\u2070<\/td>\n\u1d43<\/td>\n\u1d4f<\/td>\n\u036e<\/td>\n\u207a<\/td>\n<\/tr>\n
\u00b9<\/td>\n\u1d47<\/td>\n\u02e1<\/td>\n\u02b7<\/td>\n\u207b<\/td>\n<\/tr>\n
\u00b2<\/td>\n\u1d9c<\/td>\n\u036b<\/td>\n\u02e3<\/td>\n\u207c<\/td>\n<\/tr>\n
\u00b3<\/td>\n\u0369<\/td>\n\u207f<\/td>\n\u02b8<\/td>\n\u207d<\/td>\n<\/tr>\n
\u2074<\/td>\n\u0364<\/td>\n\u0366<\/td>\n\u1dbb<\/td>\n\u207e<\/td>\n<\/tr>\n
\u2075<\/td>\n\u1da0<\/td>\n\u1d56<\/td>\n<\/td>\n\u00b0<\/td>\n<\/tr>\n
\u2076<\/td>\n\u1d4d<\/td>\n\u036c<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u2077<\/td>\n\u036a<\/td>\n\u02e2<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u2078<\/td>\n\u0365<\/td>\n\u036d<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u2079<\/td>\n\u02b2<\/td>\n\u0367<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

[\/et_pb_text][et_pb_text module_id=”#use” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Use the CHAR function<\/span><\/h3>\n

The CHAR function takes only one argument, a unicode number, and returns the corresponding character.<\/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

All you have to do is insert the correct number from the tables below to get the character you want.<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Superscript characters and unicode numbers<\/span><\/td>\n<\/tr>\n
Numbers<\/span><\/td>\nSymbols<\/span><\/td>\n<\/tr>\n
Character<\/span><\/td>\nCode<\/span><\/td>\nCharacter<\/span><\/td>\nCode<\/span><\/td>\n<\/tr>\n
\u2070<\/span><\/td>\n8304<\/span><\/td>\n\u207a<\/span><\/td>\n8314<\/span><\/td>\n<\/tr>\n
\u00b9<\/span><\/td>\n185<\/span><\/td>\n\u207b<\/span><\/td>\n8315<\/span><\/td>\n<\/tr>\n
\u00b2<\/span><\/td>\n178<\/span><\/td>\n\u207c<\/span><\/td>\n8316<\/span><\/td>\n<\/tr>\n
\u00b3<\/span><\/td>\n179<\/span><\/td>\n\u207d<\/span><\/td>\n8317<\/span><\/td>\n<\/tr>\n
\u2074<\/span><\/td>\n8308<\/span><\/td>\n\u207e<\/span><\/td>\n8318<\/span><\/td>\n<\/tr>\n
\u2075<\/span><\/td>\n8309<\/span><\/td>\n\u00b0<\/span><\/td>\n176<\/span><\/td>\n<\/tr>\n
\u2076<\/span><\/td>\n8310<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u2077<\/span><\/td>\n8311<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u2078<\/span><\/td>\n8312<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u2079<\/span><\/td>\n8313<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Superscript characters and unicode numbers<\/span><\/td>\n<\/tr>\n
Letters<\/span><\/td>\n<\/tr>\n
Character<\/span><\/td>\nCode<\/span><\/td>\nCharacter<\/span><\/td>\nCode<\/span><\/td>\nCharacter<\/span><\/td>\nCode<\/span><\/td>\n<\/tr>\n
\u1d43<\/span><\/td>\n7491<\/span><\/td>\n\u02b2<\/span><\/td>\n690<\/span><\/td>\n\u036d<\/span><\/td>\n877<\/span><\/td>\n<\/tr>\n
\u1d47<\/span><\/td>\n7495<\/span><\/td>\n\u1d4f<\/span><\/td>\n7503<\/span><\/td>\n\u0367<\/span><\/td>\n871<\/span><\/td>\n<\/tr>\n
\u1d9c<\/span><\/td>\n7580<\/span><\/td>\n\u02e1<\/span><\/td>\n737<\/span><\/td>\n\u036e<\/span><\/td>\n878<\/span><\/td>\n<\/tr>\n
\u0369<\/span><\/td>\n873<\/span><\/td>\n\u036b<\/span><\/td>\n875<\/span><\/td>\n\u02b7<\/span><\/td>\n695<\/span><\/td>\n<\/tr>\n
\u0364<\/span><\/td>\n868<\/span><\/td>\n\u207f<\/span><\/td>\n8319<\/span><\/td>\n\u02e3<\/span><\/td>\n739<\/span><\/td>\n<\/tr>\n
\u1da0<\/span><\/td>\n7584<\/span><\/td>\n\u0366<\/span><\/td>\n870<\/span><\/td>\n\u02b8<\/span><\/td>\n696<\/span><\/td>\n<\/tr>\n
\u1d4d<\/span><\/td>\n7501<\/span><\/td>\n\u1d56<\/span><\/td>\n7510<\/span><\/td>\n\u1dbb<\/span><\/td>\n7611<\/span><\/td>\n<\/tr>\n
\u036a<\/span><\/td>\n874<\/span><\/td>\n\u036c<\/span><\/td>\n876<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u0365<\/span><\/td>\n869<\/span><\/td>\n\u02e2<\/span><\/td>\n738<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

After you get the character you can erase 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 some of these characters often. If that\u2019s the case, you could jot them down or commit them to memory. That way they are always close at hand.<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”#common” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Common uses of superscripting<\/span><\/h2>\n

If you are left wondering where you might need to superscript, below are a few common examples.\u00a0<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”#degree” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to add the degree symbol in Google Sheets<\/span><\/h3>\n

The only thing to keep in mind is not to mix up the number \u201c0\u201d,\u00a0 the letter \u201co\u201d and the symbol \u201c\u00b0\u201d. Still, if you use the incorrect symbol chances are no one will know.<\/span><\/p>\n

Let\u2019s say you have temperatures in one column but without the corresponding symbol, and you want to add it. You have two options ahead of you.<\/span><\/p>\n

The first way is to use the CONCAT function to concatenate the two values.<\/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

=CONCAT(<\/span>A1<\/span>, <\/span>“\u00b0C”<\/span>)<\/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

The second way to achieve this is to use the “&” operator to join the value in an existing cell and the symbol (\u201c\u00b0C\u201d or \u201c\u00b0F\u201d). With this method you can perform calculations before joining the values. Among other thighs, this would let you convert celsius into fahrenheit before adding the symbol<\/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

=(<\/span>9<\/span>\/<\/span>5<\/span> * <\/span>A1<\/span> + <\/span>32<\/span>)\u00a0 & <\/span>“\u00b0F”<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”#footnotes” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to add footnotes in Google Sheets<\/span><\/h3>\n

If you want to add footnotes to a cell in Google Sheets, all you have to do is copy and paste superscript numbers. This may come in handy to reference a legend or cite sources of information in your spreadsheets.<\/span><\/p>\n

<\/span><\/p>\n\n\n\n
\u2070 \u00b9 \u00b2 \u00b3 \u2074 \u2075 \u2076 \u2077 \u2078 \u2079<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[\/et_pb_text][et_pb_text module_id=”#exponents” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to do exponents in Google Sheets<\/span><\/h3>\n

Again, the simple methods covered above serve many purposes, among them you can use superscript to show an exponent in google sheets. Just copy and paste the characters below.<\/span><\/p>\n\n\n\n
\u2070 \u00b9 \u00b2 \u00b3 \u2074 \u2075 \u2076 \u2077 \u2078 \u2079<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Note that this method is only used to symbolize an exponent. If you want to calculate it you have to use the \u201c^\u201d operator. For example, 2 to the power of 3 could be shown as \u201c2\u00b3\u201d or you could calculate it using the formula below.<\/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

= 2 ^ 3<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”#superscripting” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

It’s a font, it\u2019s a style\u2026 it\u2019s superscripting!<\/span><\/h2>\n

Now you know two ways to superscript in Google Sheets. We even covered some cases where this knowledge may come in handy. Surely there are many more applications than we imagined.<\/span><\/p>\n

If you want to get the full character list for subscripting, check out How to subscript in Google Sheets<\/a>. <\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Adding superscript in Google Sheets is not as simple as it is in Google Docs. Still, there are a couple of workarounds to do it. In this article we will explore two ways to superscript in Sheets. The first is pretty simple and just involves copying and pasting. The second uses the CHAR function along […]<\/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-48926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/48926","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=48926"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/48926\/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=48926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=48926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=48926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}