{"id":128586,"date":"2025-08-23T15:49:05","date_gmt":"2025-08-23T15:49:05","guid":{"rendered":"https:\/\/goodwriterz.com\/site\/?p=128586"},"modified":"2025-08-23T15:49:05","modified_gmt":"2025-08-23T15:49:05","slug":"4-essential-google-sheets-shortcuts-for-former-excel-users","status":"publish","type":"post","link":"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/","title":{"rendered":"4 Essential Google Sheets Shortcuts for Former Excel Users"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u062d\u062a\u0648\u064a\u0627\u062a<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#1_QUERY_Manipulate_Your_Data_for_Quick_Analysis\" title=\"1 \n        \n                            QUERY: Manipulate Your Data for Quick Analysis\">1 \n        \n                            QUERY: Manipulate Your Data for Quick Analysis<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#QUERY_Syntax\" title=\"QUERY: Syntax\">QUERY: Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#QUERY_Examples\" title=\"QUERY: Examples\">QUERY: Examples<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#2_IMPORTRANGE_Import_Data_From_One_Google_Sheets_File_Into_Another\" title=\"2 \n        \n                            IMPORTRANGE: Import Data From One Google Sheets File Into Another\">2 \n        \n                            IMPORTRANGE: Import Data From One Google Sheets File Into Another<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#IMPORTRANGE_Syntax\" title=\"IMPORTRANGE: Syntax\">IMPORTRANGE: Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#IMPORTRANGE_Examples\" title=\"IMPORTRANGE: Examples\">IMPORTRANGE: Examples<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#3_GOOGLETRANSLATE_Translate_Text_From_One_Language_Into_Another\" title=\"3 \n        \n                            GOOGLETRANSLATE: Translate Text From One Language Into Another\">3 \n        \n                            GOOGLETRANSLATE: Translate Text From One Language Into Another<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#GOOGLETRANSLATE_Syntax\" title=\"GOOGLETRANSLATE: Syntax\">GOOGLETRANSLATE: Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#GOOGLETRANSLATE_Examples\" title=\"GOOGLETRANSLATE: Examples\">GOOGLETRANSLATE: Examples<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#4_SPARKLINE_Create_Miniature_In-Cell_Charts\" title=\"4 \n        \n                            SPARKLINE: Create Miniature In-Cell Charts\">4 \n        \n                            SPARKLINE: Create Miniature In-Cell Charts<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#SPARKLINE_Syntax\" title=\"SPARKLINE: Syntax\">SPARKLINE: Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#SPARKLINE_Line_Charts\" title=\"SPARKLINE: Line Charts\">SPARKLINE: Line Charts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#SPARKLINE_Column_and_Win-Loss_Charts\" title=\"SPARKLINE: Column and Win-Loss Charts\">SPARKLINE: Column and Win-Loss Charts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/#SPARKLINE_Bar_Charts\" title=\"SPARKLINE: Bar Charts\">SPARKLINE: Bar Charts<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<div>\n<p>If you&#8217;re well-versed in Microsoft Excel, making the switch to Google Sheets shouldn&#8217;t cause you too many problems. However, there are some essential functions exclusive to Google Sheets that will make your life much easier once you get to know them.<\/p>\n<p>    <!-- No AdsNinja v10 Client! --><\/p>\n<h2 id=\"query-manipulate-your-data-for-quick-analysis\">\n            <span class=\"item-num\">1 <\/span><br \/>\n        <span><br \/>\n                            QUERY: Manipulate Your Data for Quick Analysis<br \/>\n                    <\/span><br \/>\n       <\/h2>\n<p>The QUERY function is as useful in <a rel=\"noopener noreferrer\" target=\"_blank\" href=\"https:\/\/sheets.google.com\/\">Google Sheets<\/a> as the Power Query tool is in Microsoft Excel. However, where Power Query in Excel operates through a separate window, queries in Google Sheets are powered through a series of clauses in a formula.<\/p>\n<h3 id=\"query-syntax\">\n            QUERY: Syntax<br \/>\n    <\/h3>\n<p>The QUERY function in Google Sheets has three arguments:<\/p>\n<pre>=QUERY(<em>a<\/em>,<em>b<\/em>,<em>c<\/em>)<\/pre>\n<p>where<\/p>\n<ul>\n<li>\n                                        <em>a<\/em> is the range of cells containing the data to be manipulated,\n                        <\/li>\n<li>\n                                        <em>b<\/em> is the query to perform, written using <a rel=\"noopener noreferrer\" target=\"_blank\" href=\"https:\/\/developers.google.com\/chart\/interactive\/docs\/querylanguage\">Google Visualization API Query Language<\/a>, and\n                        <\/li>\n<li>\n                                        <em>c<\/em> (optional) is the number of headers at the top of the data, which, if omitted or set to -1, forces Google Sheets to work this out automatically by analyzing the structure and content of your dataset.\n                        <\/li>\n<\/ul>\n<h3 id=\"query-examples\">\n            QUERY: Examples<br \/>\n    <\/h3>\n<p>If you&#8217;ve never used structured query language (SQL) before, the QUERY function might seem daunting at first. However, once you try using the function in some straightforward scenarios, the sky&#8217;s the limit!<\/p>\n<p>In this example, let&#8217;s say you want to produce a list of employees from the T_Staff table who have completed their training (in other words, those who have &#8220;Y&#8221; in column D.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :46.4%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/a-google-sheets-table-showing-employee-ids-first-names-last-names-whether-employees-have-completed-training-and-the-profit-they-generated.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"A Google Sheets table showing employee IDs, first names, last names, whether employees have completed training, and the profit they generated.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> To do this, in a separate cell or spreadsheet, type:<\/p>\n<pre>=QUERY(T_Staff,\"SELECT B, C WHERE D = 'Y'\")<\/pre>\n<p>where<\/p>\n<ul>\n<li>\n                                        <em>T_Staff<\/em> is the table where the data you want to extract is stored,\n                        <\/li>\n<li>\n                                        <em>SELECT B, C<\/em> tells Google Sheets that you want to extract certain data from columns B and C of the T_Staff table, and\n                        <\/li>\n<li>\n                                        <em>WHERE D = &#8216;Y&#8217;<\/em> tells Google Sheets that you only want to extract the rows where there&#8217;s a &#8220;Y&#8221; in column D.\n                        <\/li>\n<\/ul>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :46.25%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-query-function-in-google-sheets-being-used-to-extract-the-names-of-all-employees-who-have-completed-training.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The QUERY function in Google Sheets being used to extract the names of all employees who have completed training.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964137_557_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964137_557_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<div class=\"emaki-custom note\" id=\"custom_block_17\">\n<div class=\"custom_block-content note\">\n<p>Notice how the whole query is in double quotes, and individual text criteria are in single quotes.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<p>In a second example, suppose you want to know which employees have completed training and earned over $30,000 in profit. The formula for this query is as follows:<\/p>\n<pre>=QUERY(T_Staff,\"SELECT B, C WHERE D='Y' AND E&gt;30000\")<\/pre>\n<p>where <em>D=&#8217;Y&#8217; AND E&gt;30000<\/em> combines the two logical arguments to only extract values from column B and C where there&#8217;s a &#8220;Y&#8221; in column D and the value in column E is more than \u00a330,000.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :43.667679837893%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-query-function-in-google-sheets-being-used-to-extract-the-names-of-all-employees-who-have-completed-training-and-made-over-30-000-dollars.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The QUERY function in Google Sheets being used to extract the names of all employees who have completed training and made over 30,000 dollars.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_866_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_866_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Now, let&#8217;s explore some slightly more advanced scenarios. Let&#8217;s imagine that this time, you want to count the number of employees who have and haven&#8217;t completed their training, and group those totals into individual tallies.<\/p>\n<p>In this case, the formula is:<\/p>\n<pre>=QUERY(T_Staff,\"SELECT D, COUNT(D) GROUP BY D\")<\/pre>\n<p>where <em>SELECT D<\/em> first extracts the information from column D, <em>COUNT(D) <\/em>counts the number of entries in the same column, and <em>GROUP BY D<\/em> collates the count according to the common values (in this case, &#8220;Y&#8221; and &#8220;N&#8221;).<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :27.055150884495%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-query-function-in-google-sheets-being-used-to-count-the-number-of-employees-who-have-completed-training-and-those-who-have-not.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The QUERY function in Google Sheets being used to count the number of employees who have completed training and those who have not.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_654_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_654_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Finally, you now want to analyze whether those who have attended training have turned a greater profit than those who haven&#8217;t. To do this, type:<\/p>\n<pre>=QUERY(T_Staff,\"SELECT D, AVG(E) GROUP BY D\")<\/pre>\n<p>where <em>SELECT D<\/em> extracts the data from column D, <em>AVE(E) <\/em>averages the values in column E according to the common values in the previously selected column, and <em>GROUP BY D<\/em> aggregates the averages according to their common values.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :26.880641925777%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-query-function-in-google-sheets-being-used-to-find-the-average-profit-of-employees-who-have-completed-training-and-those-who-have-not.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The QUERY function in Google Sheets being used to find the average profit of employees who have completed training and those who have not.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_451_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_451_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> As a result, you can see that those who attended training made, on average, a profit that is around $5,000 greater than those who didn&#8217;t.<\/p>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<div class=\"emaki-custom note\" id=\"custom_block_32\">\n<div class=\"custom_block-content note\">\n<p>The aggregation functions you can use in a QUERY formula are avg(), count(), max(), min(), and sum(). The clause types are select, where, group by, pivot, order by, limit, offset, label, format, and options.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<h2 id=\"importrange-import-data-from-one-google-sheets-file-into-another\">\n            <span class=\"item-num\">2 <\/span><br \/>\n        <span><br \/>\n                            IMPORTRANGE: Import Data From One Google Sheets File Into Another<br \/>\n                    <\/span><br \/>\n       <\/h2>\n<p>In Microsoft Excel, if you wanted to import data from one file to another, you would most likely use Power Query. However, in Google Sheets, you&#8217;ll need to use the IMPORTRANGE function.<\/p>\n<h3 id=\"importrange-syntax\">\n            IMPORTRANGE: Syntax<br \/>\n    <\/h3>\n<p>The IMPORTRANGE function has a straightforward syntax with two arguments:<\/p>\n<pre>=IMPORTRANGE(<em>a<\/em>,<em>b<\/em>)<\/pre>\n<p>Argument <em>a<\/em> directs Google Sheets to the file containing the range you want to import, either in the form of a URL (enclosed in double quotes) or a reference to a cell containing the URL.<\/p>\n<p>Argument <em>b<\/em> is the reference to the range within the identified file. This can be cell references, a sheet name followed by cell references, a named range, a table name, or a column within a table\u2014all of which must be in double quotes. It can also reference a cell containing the cell references of the source data, and this <em>doesn&#8217;t<\/em> need quotation marks.<\/p>\n<h3 id=\"importrange-examples\">\n            IMPORTRANGE: Examples<br \/>\n    <\/h3>\n<p>Let me show you IMPORTRANGE in action.<\/p>\n<p>In this first example, your aim is to import the list of names from File 1 to File 2.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :54.310344827586%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/07\/two-google-sheets-files-one-has-a-list-of-names-in-column-a-and-the-other-is-empty.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"Two Google Sheets Files. One has a list of names in column A, and the other is empty.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_24_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_24_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p>To do this, select the cell in File 2 where you want the list to be imported to, and type the following formula:<\/p>\n<pre>=IMPORTRANGE(\"<\/pre>\n<p>Note how the URL and cell references are placed inside double quotes.<\/p>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<div class=\"emaki-custom note\" id=\"custom_block_47\">\n<div class=\"custom_block-content note\">\n<p>The example formulas only show a part of the URL for demonstration purposes. In your case, when typing your formula, paste the <em>whole<\/em> URL.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<p>The first time you make the connection between the two files, you may see a #REF! error. In this case, hover over the cell containing one of the following two errors.<\/p>\n<p>If you own both spreadsheets, Google Sheets requires you to grant permission to link the files. To do this, click &#8220;Allow Access.&#8221;<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :32.933333333333%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/07\/an-alert-in-google-sheets-that-tells-the-user-that-access-is-required-and-the-allow-access-button-is-highlighted.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"An alert in Google Sheets that tells the user that access is required, and the Allow Access button is highlighted.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_660_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964138_660_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Alternatively, if you&#8217;re not the owner of the source file and haven&#8217;t already been given edit access, you&#8217;ll be told that you don&#8217;t have permission to import the identified range using the IMPORTRANGE function. In this case, copy and paste the source file&#8217;s URL into the browser address bar, and press Enter. Then, click &#8220;Request Edit Access,&#8221; and wait for the owner to grant permission.<\/p>\n<p>As soon as the correct permissions are activated, the range is imported to File 2.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :51.866666666667%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/07\/a-range-is-imported-into-a-google-sheets-file-using-the-importrange-function.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"A range is imported into a Google Sheets file using the IMPORTRANGE function.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964139_177_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964139_177_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> One benefit of the IMPORTRANGE function is that if the contents of the referenced cells in File 1 change, this is reflected in the imported data in File 2. However, if the source data expands or changes location, you&#8217;ll need to adjust the formula accordingly.<\/p>\n<p>By default, IMPORTRANGE imports from the source file&#8217;s first worksheet. To import a range from another worksheet in the source file, for argument <em>b<\/em>, type the sheet name, followed by an exclamation mark, and then the cell references.<\/p>\n<p>In this example, the formula will import the data from cells A2 to A11 in Sheet 2:<\/p>\n<pre>=IMPORTRANGE(\"https:\/\/docs.google.com\/spreadsheets\/d...\",\"<strong>Sheet2!A2:A11<\/strong>\")<\/pre>\n<p>One issue with the above formulas is that they&#8217;re lengthy and difficult to parse. So, to make the formula tidier, for argument <em>a<\/em>, you can reference a cell containing the source URL. For example, typing:<\/p>\n<pre>=IMPORTRANGE(A1,\"C2:C11\")<\/pre>\n<p>imports the data in cells C2 to C11 in the Google Sheets file linked in cell A1.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :54.666666666667%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/07\/the-importrange-function-in-google-sheets-that-references-a-cell-containing-a-link-to-another-file.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The IMPORTRANGE function in Google Sheets that references a cell containing a link to another file.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.p.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.p.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> You could do the same for argument <em>b<\/em> of the formula by referencing a cell that contains a reference to the range you want to import. Here, typing:<\/p>\n<pre>=IMPORTRANGE(A1,B1)<\/pre>\n<p>into cell B2 takes the URL from cell A1, and the cell references from cell B1:<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :54.533333333333%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/07\/the-importrange-function-in-google-sheets-references-a-file-link-in-cell-a1-and-cell-ranges-in-cell-b1.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The IMPORTRANGE function in Google Sheets references a file link in cell A1 and cell ranges in cell B1.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964139_133_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964139_133_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-tip\" data-nosnippet=\"\">\n<div class=\"emaki-custom tip\" id=\"custom_block_66\">\n<div class=\"custom_block-content tip\">\n<p>If your source data is a named range or formatted as a Google Sheets table, for argument <em>b<\/em>, type the range name, table name, or table name and column header (all inside double quotes).<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<h2 id=\"googletranslate-translate-text-from-one-language-into-another\">\n            <span class=\"item-num\">3 <\/span><br \/>\n        <span><br \/>\n                            GOOGLETRANSLATE: Translate Text From One Language Into Another<br \/>\n                    <\/span><br \/>\n       <\/h2>\n<p>As its name suggests, the GOOGLETRANSLATE function takes some text in your spreadsheet, and translates it into another language, much like the TRANSLATE function in Microsoft Excel.<\/p>\n<h3 id=\"googletranslate-syntax\">\n            GOOGLETRANSLATE: Syntax<br \/>\n    <\/h3>\n<p>Here&#8217;s how the GOOGLETRANSLATE function works in Google Sheets:<\/p>\n<pre>=GOOGLETRANSLATE(<em>a<\/em>,<em>b<\/em>,<em>c<\/em>)<\/pre>\n<p>where<\/p>\n<ul>\n<li>\n                                        <em>a<\/em> is either the text to be translated (enclosed in double quotation marks) or a reference to a cell containing the text to be translated,\n                        <\/li>\n<li>\n                                        <em>b<\/em> (optional) is the source language code, and\n                        <\/li>\n<li>\n                                        <em>c<\/em> (optional) is the target language code.\n                        <\/li>\n<\/ul>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<\/section>\n<p>If you omit argument <em>b<\/em>, Google Sheets will attempt to detect the language automatically. Omitting argument <em>c<\/em> translates the text into the language selected in your system settings.<\/p>\n<h3 id=\"googletranslate-examples\">\n            GOOGLETRANSLATE: Examples<br \/>\n    <\/h3>\n<p>Let&#8217;s start with a straightforward example before we explore how you can use this function in a real-life scenario.<\/p>\n<p>Let&#8217;s say you&#8217;re sent this Google Sheets file containing four cells containing sentences in four different languages, and you need to translate all the text into English, your system&#8217;s default language.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :21.066666666667%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/a-google-sheets-spreadsheet-containing-four-multilingual-phrases-in-cells-a1-to-a4.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"A Google Sheets spreadsheet containing four multilingual phrases in cells A1 to A4.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964139_49_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964139_49_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> First, to translate the text in cell A1 into English in cell B1, you need to type:<\/p>\n<pre>=GOOGLETRANSLATE(A1)<\/pre>\n<p>and press Enter.<\/p>\n<p>Because you didn&#8217;t specify a source language (argument <em>b<\/em>), Google uses its translation tool to work out that the text in cell A1 is Chinese. Also, since you didn&#8217;t identify a target language (argument <em>c<\/em>), the text is automatically translated into your system&#8217;s language.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :24.666666666667%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-googletranslate-function-in-google-sheets-translating-a-chinese-sentence-into-english.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The GOOGLETRANSLATE function in Google Sheets translating a Chinese sentence into English.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_112_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_112_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Now, double-click the fill handle in the bottom-right corner of cell B1 to apply this formula to cells B2, B3, and B4.<\/p>\n<p>Notice how, even though the source languages in cells A1 to A4 differ, the GOOGLETRANSLATE function still picks them up correctly.<\/p>\n<p>Now, let&#8217;s see this function in action in a practical scenario. Imagine you&#8217;re creating a sheet where you need individuals to enter some personal details in column C. However, you want Google Sheets to translate the text when the respondent selects a different language in cell B1.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :33.333333333333%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/a-google-sheets-spreadsheet-with-select-language-in-cell-a1-various-personal-characteristics-from-cell-a4-downward-and-cells-where-answers-will-go.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"A Google Sheets spreadsheet with &#039;Select Language&#039; in cell A1, various personal characteristics from cell A4 downward, and cells where answers will go.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_691_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_691_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> First, you need to import the language codes into a separate spreadsheet in your Google Sheets file. To do this, head to the <a rel=\"noopener noreferrer\" target=\"_blank\" href=\"https:\/\/developers.google.com\/workspace\/admin\/directory\/v1\/languages\">list of codes on Google&#8217;s website<\/a>, select all the languages and their corresponding codes, and press Ctrl+C to copy them. Then, head back to the new tab in Google Sheets, and in cell A1, press Ctrl+V.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :44%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/languages-and-their-codes-pasted-into-a-google-sheets-worksheet.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"Languages and their codes pasted into a Google Sheets worksheet.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_790_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_790_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Next, you need to translate the English names of these languages into the target language to make it easier for the person selecting a language to find their own. So, in cell C1, type:<\/p>\n<pre>=GOOGLETRANSLATE(A1,\"en\",B1)<\/pre>\n<p>and press Enter. At this point, Google Sheets will offer to autofill the formula to the remaining cells in the range, so click the checkmark to accept.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :33.066666666667%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/google-sheets-suggesting-an-autofill-of-the-googletranslate-function-to-the-remaining-cells-in-the-range.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"Google Sheets suggesting an autofill of the GOOGLETRANSLATE function to the remaining cells in the range.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_386_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_386_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Now, head back to the spreadsheet where the text needs to be translated, and create a drop-down list of all the translated languages you just generated via the Data Validation option in the Data tab on the ribbon.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :43.333333333333%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/a-drop-down-list-of-languages-in-a-cell-in-google-sheets.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"A drop-down list of languages in a cell in Google Sheets.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_492_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964140_492_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> You&#8217;re now ready to use the GOOGLETRANSLATE function to translate the fields in column A into the chosen language in column B. In cell B4, type the following formula, which I&#8217;ve split up into separate lines for easier understanding:<\/p>\n<pre>=IFERROR(<br\/>GOOGLETRANSLATE(A4,\"en\",<br\/>XLOOKUP($B$1,Codes!$C$1:$C$55,Codes!$B$1:$B$55)),<br\/>\"\")<\/pre>\n<p>where<\/p>\n<ul>\n<li>\n                                        Line 2 translates the text in A4 from English,\n                        <\/li>\n<li>\n                                        Line 3 uses the XLOOKUP function to take the language cell B1, look it up in the list of languages in the Codes spreadsheets (cells C1 to C55), and return the corresponding language code (cells B1 to B55), and\n                        <\/li>\n<li>\n                                        Lines 1 and 4 use the IFERROR function to return a blank cell if no language is selected in cell B1.\n                        <\/li>\n<\/ul>\n<p>Then, use the fill handle in cell B4 to apply the formula to the remaining cells in the range, and select a language in cell B1 to see your work in action.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :37.6%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/some-text-is-translated-from-english-into-a-selected-language-in-google-sheets.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"Some text is translated from English into a selected language in Google Sheets.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964141_748_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964141_748_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Next, in cell B3, type:<\/p>\n<pre>=B1<\/pre>\n<p>so that the selected language heads the translated column, and in cell C3, type:<\/p>\n<pre>=IF(ISBLANK(B1),\"Answer\",GOOGLETRANSLATE(\"Answer\",\"en\",XLOOKUP($B$1,Codes!$C$1:$C$55,Codes!$B$1:$B$55)))<\/pre>\n<p>so that the word &#8220;Answer&#8221; in cell C3 is also translated if a language is selected in cell B1.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :34%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/a-google-sheets-spreadsheet-with-various-words-translated-according-to-the-selected-language.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"A Google Sheets spreadsheet with various words translated according to the selected language.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964141_817_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964141_817_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<h2 id=\"sparkline-create-miniature-in-cell-charts\">\n            <span class=\"item-num\">4 <\/span><br \/>\n        <span><br \/>\n                            SPARKLINE: Create Miniature In-Cell Charts<br \/>\n                    <\/span><br \/>\n       <\/h2>\n<p>Charts are a great way to visualize your data, but they can take up lots of real estate in your spreadsheet, especially if you insert more than one. Luckily, the SPARKLINE function in Google Sheets creates a miniature chart within a cell.<\/p>\n<p>The main difference between sparklines in Microsoft Excel and Google Sheets is that in the former, they&#8217;re inserted and modified on the ribbon, while in the latter, everything is done within the formula. What&#8217;s more, there are more modification options for sparklines in Sheets than in Excel.<\/p>\n<section class=\"emaki-custom-block emaki-custom-tip\" data-nosnippet=\"\">\n<div class=\"emaki-custom tip\" id=\"custom_block_113\">\n<div class=\"custom_block-content tip\">\n<p>Sparklines in Google Sheets automatically adjust to fill the whole cell. So, to make sparklines more readable, increase the size of the cells that accommodate them.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<h3 id=\"sparkline-syntax\">\n            SPARKLINE: Syntax<br \/>\n    <\/h3>\n<p>Although the SPARKLINE syntax initially appears quite simple, as you add modifications, it becomes more complex:<\/p>\n<pre>=SPARKLINE(<em>a<\/em>,{<em>b<\/em>})<\/pre>\n<p>where <em>a<\/em> references the cells containing the data you want to visualize, and <em>b<\/em> are optional settings you can apply to your sparklines, enclosed within curly braces. If you want to create a minimal in-cell line chart, you can omit argument <em>b<\/em> altogether. However, to use other types of charts and modify how they appear, argument <em>b<\/em> becomes necessary.<\/p>\n<h3 id=\"sparkline-line-charts\">\n            SPARKLINE: Line Charts<br \/>\n    <\/h3>\n<p>As I mentioned above, if you want a basic line sparkline, you only have to input the cells containing the data into argument <em>a<\/em> in your formula:<\/p>\n<pre>=SPARKLINE(B2:E2)<\/pre>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :33.733333333333%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-sparkline-function-in-google-sheets-visualizing-a-four-week-trend-through-a-miniature-line-chart.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The SPARKLINE function in Google Sheets visualizing a four-week trend through a miniature line chart.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964141_974_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964141_974_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> However, you can modify the layout of these lines through argument <em>b<\/em>, which is a series of pairs of settings and their associated values. A setting and its value are separated by a comma, and each setting-value pairing is separated by a semicolon:<\/p>\n<pre>=SPARKLINE(<em>a<\/em>,{b\u00b9,b\u00b2;b\u00b9,b\u00b2;b\u00b9,b\u00b2})<\/pre>\n<p>This table shows you the different types of settings you can apply:<\/p>\n<div class=\"table-container\">\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"\" align=\"\" summary=\"\">\n<thead>\n<tr>\n<th scope=\"col\">\n<p>Setting<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Definition<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Values<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Example Formula<\/p>\n<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\n<p>&#8220;xmin&#8221;<\/p>\n<\/td>\n<td>\n<p>The minimum value along the x-axis<\/p>\n<\/td>\n<td>\n<p>Any numerical value (no quotation marks)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"xmin\",50})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;xmax&#8221;<\/p>\n<\/td>\n<td>\n<p>The maximum value along the x-axis<\/p>\n<\/td>\n<td>\n<p>Any numerical value (no quotation marks)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"xmax\",200})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;ymin&#8221;<\/p>\n<\/td>\n<td>\n<p>The minimum value along the y-axis<\/p>\n<\/td>\n<td>\n<p>Any numerical value (no quotation marks)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"ymin\",50})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;ymax&#8221;<\/p>\n<\/td>\n<td>\n<p>The maximum value along the y-axis<\/p>\n<\/td>\n<td>\n<p>Any numerical value (no quotation marks)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"ymax\",200})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;color&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the color of the line<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"color\",\"green\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;empty&#8221;<\/p>\n<\/td>\n<td>\n<p>Defines whether empty cells are counted as zeros or ignored<\/p>\n<\/td>\n<td>\n<p>&#8220;zero&#8221; visualizes blank cells as zero values in the sparkline; &#8220;ignore&#8221; discounts blank cells from the result<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B3:E3,{\"empty\",\"ignore\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;nan&#8221;<\/p>\n<\/td>\n<td>\n<p>Defines what happens to values that are not a number<\/p>\n<\/td>\n<td>\n<p>&#8220;convert&#8221; turns non-numeric values into zeros; &#8220;ignore&#8221; discounts non-numeric values from the result<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"nan\",\"convert\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;rtl&#8221;<\/p>\n<\/td>\n<td>\n<p>Determines whether the sparkline is rendered to the right or left<\/p>\n<\/td>\n<td>\n<p>true (no quotation marks) renders the sparkline to the left; false (no quotation marks) renders the sparkline to the right<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"rtl\",false})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;linewidth&#8221;<\/p>\n<\/td>\n<td>\n<p>Determines the thickness of the line<\/p>\n<\/td>\n<td>\n<p>Any numerical value (no quotation marks)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"linewidth\",4})<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<p>So, in this example, the sparkline is red, ignores empty cells, and is slightly thicker than the default:<\/p>\n<pre>=SPARKLINE(B2:E2,{\"color\",\"red\";\"empty\",\"ignore\";\"linewidth\",2})<\/pre>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :23.066666666667%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/a-sparkline-in-google-sheets-with-various-settings-applied-to-change-its-appearance.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"A sparkline in Google Sheets with various settings applied to change its appearance.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964141_834_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964141_834_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<h3 id=\"sparkline-column-and-win-loss-charts\">\n            SPARKLINE: Column and Win-Loss Charts<br \/>\n    <\/h3>\n<p>To turn your sparkline into a column chart, use the following for argument <em>b<\/em>:<\/p>\n<pre>=SPARKLINE(B2:E2,<strong>{\"charttype\",\"column\"}<\/strong>)<\/pre>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :32.8%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-sparkline-function-in-google-sheets-visualizing-a-four-week-trend-through-a-miniature-column-chart.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The SPARKLINE function in Google Sheets visualizing a four-week trend through a miniature column chart.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_453_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_453_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Similarly, to insert a win-loss sparkline, type:<\/p>\n<pre>=SPARKLINE(B2:E2,<strong>{\"charttype\",\"winloss\"}<\/strong>)<\/pre>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :32.933333333333%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-sparkline-function-in-google-sheets-visualizing-a-four-week-trend-through-a-miniature-win-loss-chart.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The SPARKLINE function in Google Sheets visualizing a four-week trend through a miniature win-loss chart.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_430_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_430_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p> Here are the other optional setting-value pairings you can include in argument <em>b<\/em> for column or win-loss sparklines:<\/p>\n<div class=\"table-container\">\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"\" align=\"\" summary=\"\">\n<thead>\n<tr>\n<th scope=\"col\">\n<p>Setting<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Definition<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Values<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Example Formula<\/p>\n<\/th>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;color&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the color of the columns<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"color\",\"green\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;lowcolor&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the color of the lowest value<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"lowcolor\",\"green\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;highcolor&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the color of the highest value<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"highcolor\",\"green\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;firstcolor&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the color of the first column<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"firstcolor\",\"green\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;lastcolor&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the color of the last column<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"lastcolor\",\"green\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;negcolor&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the color of all negative columns<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"negcolor\",\"green\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;empty&#8221;<\/p>\n<\/td>\n<td>\n<p>Defines whether empty cells are counted as zeros or ignored<\/p>\n<\/td>\n<td>\n<p>&#8220;zero&#8221; visualizes blank cells as zero values in the sparkline; &#8220;ignore&#8221; discounts blank cells from the result<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"empty\",\"ignore\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;nan&#8221;<\/p>\n<\/td>\n<td>\n<p>Defines what happens to values that are not a number<\/p>\n<\/td>\n<td>\n<p>&#8220;convert&#8221; turns non-numeric values into zeros; &#8220;ignore&#8221; discounts non-numeric values from the result<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"nan\",\"convert\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;axis&#8221;<\/p>\n<\/td>\n<td>\n<p>Determines whether axes are shown<\/p>\n<\/td>\n<td>\n<p>true (no quotation marks) shows the axes; false (no quotation marks) hides the axes<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"axis\",\"false\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;axiscolor&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the color of the axes (if the &#8220;axis&#8221; setting is included)<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"axiscolor\",\"green\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;ymin&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the minimum value along the y-axis (column sparklines only)<\/p>\n<\/td>\n<td>\n<p>Any numerical value (no quotation marks)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"ymin\",50})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;ymax&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the maximum value along the y-axis (column sparklines only)<\/p>\n<\/td>\n<td>\n<p>Any numerical value (no quotation marks)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"ymax\",100})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;rtl&#8221;<\/p>\n<\/td>\n<td>\n<p>Determines whether the sparkline is rendered to the right or left<\/p>\n<\/td>\n<td>\n<p>true (no quotation marks) renders the sparkline to the left; false (no quotation marks) renders the sparkline to the right<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"rtl\",\"false\"})<\/pre>\n<\/td>\n<\/tr>\n<\/thead>\n<\/table><\/div>\n<p>Here, this formula uses a column sparkline whose columns are colored light gray, except for the highest value which is colored green, and sets a y-axis minimum of 50:<\/p>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\";\"color\",\"#D3D3D3\";\"highcolor\",\"green\";\"ymin\",50})<\/pre>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :28.8%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-sparkline-function-in-google-sheets-visualizing-a-four-week-trend-through-a-miniature-column-chart-with-various-additional-settings.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The SPARKLINE function in Google Sheets visualizing a four-week trend through a miniature column chart with various additional settings.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_855_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_855_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<h3 id=\"sparkline-bar-charts\">\n            SPARKLINE: Bar Charts<br \/>\n    <\/h3>\n<p>Bar chart sparklines don&#8217;t work the same way as a usual bar chart, as they don&#8217;t have variables on the y-axis and values on the x-axis. Instead, they group a single variable&#8217;s values into one bar, allowing you to compare their proportions. For this reason, bar chart sparklines work best when you don&#8217;t have too many values to plot.<\/p>\n<p>For example, typing:<\/p>\n<pre>=SPARKLINE(B2:C2,<strong>{\"charttype\",\"bar\"}<\/strong>)<\/pre>\n<p>into cell D2 and extending the formula to the other cells in the range means you can quickly see that team E accumulated the greatest proportion of its points in week 1, while team B did better in week 2.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :33.466666666667%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-sparkline-function-in-google-sheets-visualizing-a-two-week-trend-through-a-miniature-bar-chart.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The SPARKLINE function in Google Sheets visualizing a two-week trend through a miniature bar chart.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_208_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.p.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_208_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.p.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<p>Here are some other settings you can apply to bar chart sparklines:<\/p>\n<div class=\"table-container\">\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"\" align=\"\" summary=\"\">\n<thead>\n<tr>\n<th scope=\"col\">\n<p>Setting<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Definition<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Values<\/p>\n<\/th>\n<th scope=\"col\">\n<p>Example Formula<\/p>\n<\/th>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;max&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the maximum value along the horizontal axis<\/p>\n<\/td>\n<td>\n<p>Any numerical value (no quotation marks)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:C2,{\"charttype\",\"bar\";\"max\",100})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;color1&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the first color used for bars<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:C2,{\"charttype\",\"bar\";\"color1\",\"red\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;color2&#8221;<\/p>\n<\/td>\n<td>\n<p>Sets the second color used for bars<\/p>\n<\/td>\n<td>\n<p>Color names (like &#8220;green&#8221;) or color hex codes (like &#8220;#52D978&#8221;)<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:C2,{\"charttype\",\"bar\";\"color2\",\"blue\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;empty&#8221;<\/p>\n<\/td>\n<td>\n<p>Defines whether empty cells are counted as zeros or ignored<\/p>\n<\/td>\n<td>\n<p>&#8220;zero&#8221; visualizes blank cells as zero values in the sparkline; &#8220;ignore&#8221; discounts blank cells from the result<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:C2,{\"charttype\",\"bar\";\"empty\",\"zero\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;nan&#8221;<\/p>\n<\/td>\n<td>\n<p>Defines what happens to values that are not a number<\/p>\n<\/td>\n<td>\n<p>&#8220;convert&#8221; turns non-numeric values into zeros; &#8220;ignore&#8221; discounts non-numeric values from the result<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:C2,{\"charttype\",\"bar\";\"nan\",\"convert\"})<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>&#8220;rtl&#8221;<\/p>\n<\/td>\n<td>\n<p>Determines whether the sparkline is rendered to the right or left<\/p>\n<\/td>\n<td>\n<p>true (no quotation marks) renders the sparkline to the left; false (no quotation marks) renders the sparkline to the right<\/p>\n<\/td>\n<td>\n<pre>=SPARKLINE(B2:C2,{\"charttype\",\"bar\";\"rtl\",\"false\"})<\/pre>\n<\/td>\n<\/tr>\n<\/thead>\n<\/table><\/div>\n<p>To allow for easier comparison across and within variables, I recommend always using the &#8220;max&#8221; setting.<\/p>\n<p>Here, as well as comparing each team&#8217;s overall score, I can easily compare their weekly totals. I&#8217;ve also chosen green and yellow as the two bar colors:<\/p>\n<pre>=SPARKLINE(B2:C2,{\"charttype\",\"bar\";\"color1\",\"green\";\"color2\",\"yellow\";\"max\",200})<\/pre>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :32.933333333333%\" data-img-url=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2025\/08\/the-sparkline-function-in-google-sheets-visualizing-a-two-week-trend-through-a-miniature-bar-chart-with-additional-settings-applied.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"The SPARKLINE function in Google Sheets visualizing a two-week trend through a miniature bar chart with additional settings applied.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_236_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/1755964142_236_4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.png?w=1200&#038;ssl=1\" title=\"\">\n                        <\/picture>\n<\/p><\/div>\n<\/p><\/div>\n<hr\/>\n<p>Whether you should use Google Sheets or Microsoft Excel depends on several factors, including the complexity of the tasks you want to perform, whether you want to collaborate with others, and if you like working on a desktop app or your web browser. Many people prefer the advanced analysis tools of Excel, while others prefer the more intuitive interface of Google Sheets.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re well-versed in Microsoft Excel, making the switch to Google Sheets shouldn&#8217;t cause you too many problems. However, there are some essential functions exclusive to Google Sheets that will make your life much easier once you get to know them. 1 QUERY: Manipulate Your Data for Quick Analysis The QUERY function is as useful &#8230; <a title=\"4 Essential Google Sheets Shortcuts for Former Excel Users\" class=\"read-more\" href=\"https:\/\/goodwriterz.com\/site\/4-essential-google-sheets-shortcuts-for-former-excel-users\/\" aria-label=\"Read more about 4 Essential Google Sheets Shortcuts for Former Excel Users\">\u0625\u0642\u0631\u0623 \u0627\u0644\u0645\u0632\u064a\u062f<\/a><\/p>\n","protected":false},"author":1,"featured_media":128587,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-128586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/08\/4-Essential-Google-Sheets-Shortcuts-for-Former-Excel-Users.jpeg?fit=2400%2C1600&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/128586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/comments?post=128586"}],"version-history":[{"count":0,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/128586\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media\/128587"}],"wp:attachment":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media?parent=128586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/categories?post=128586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/tags?post=128586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}