{"id":204883,"date":"2023-10-26T18:25:53","date_gmt":"2023-10-26T09:25:53","guid":{"rendered":"https:\/\/www.stock-app.info\/en\/media\/?p=204883"},"modified":"2024-02-16T17:26:01","modified_gmt":"2024-02-16T08:26:01","slug":"google-sheets","status":"publish","type":"post","link":"https:\/\/www.stock-app.info\/en\/media\/google-sheets\/","title":{"rendered":"Best usage of Google Sheets for beginners\u00a0"},"content":{"rendered":"<div>Among them, Google Sheets is used by many companies because it is available free of charge.<\/div>\n<div>&nbsp;<\/div>\n<div>However, there are many people who want to use Google Sheets for data management but do not know how to use it in detail.<\/div>\n<div>&nbsp;<\/div>\n<div>In this article, <b>we will focus on the features and usage of Google Sheets<\/b> for below people.<\/div>\n<div>&nbsp;<\/div>\n<ul>\n \t<li>&#8220;I want to use Google Sheets in my work.&#8221;<\/li>\n \t<li>&#8220;I want to know what Google Sheets can do.&#8221;<\/li>\n \t<li>&#8220;I want to manage documents digitally and save time and effort in filing and sharing.&#8221;<\/li>\n<\/ul>\n<div>If so, this article will help you learn more about how to use Google Sheets and find the best way to manage information for your company.<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>\n<div id=\"toc_container\" class=\"toc_white no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#What_is_a_Google_Sheets\"><span class=\"toc_number toc_depth_1\">1<\/span> What is a Google Sheets?<\/a><ul><li><a href=\"#Differences_between_Google_Sheets_and_other_tools\"><span class=\"toc_number toc_depth_2\">1.1<\/span> Differences between Google Sheets and other tools<\/a><\/li><li><a href=\"#Features_of_Google_Sheets\"><span class=\"toc_number toc_depth_2\">1.2<\/span> Features of Google Sheets<\/a><\/li><\/ul><\/li><li><a href=\"#6_things_you_can_do_with_Google_Sheets\"><span class=\"toc_number toc_depth_1\">2<\/span> 6 things you can do with Google Sheets<\/a><ul><li><a href=\"#1_Multiple_people_can_edit_at_the_same_time\"><span class=\"toc_number toc_depth_2\">2.1<\/span> (1) Multiple people can edit at the same time<\/a><\/li><li><a href=\"#2_Can_be_viewed_and_edited_with_a_web_browser\"><span class=\"toc_number toc_depth_2\">2.2<\/span> (2) Can be viewed and edited with a web browser<\/a><\/li><li><a href=\"#3_Data_is_automatically_saved\"><span class=\"toc_number toc_depth_2\">2.3<\/span> (3) Data is automatically saved<\/a><\/li><li><a href=\"#4_Excel_support\"><span class=\"toc_number toc_depth_2\">2.4<\/span> (4) Excel support.<\/a><\/li><li><a href=\"#5_Data_can_be_restored\"><span class=\"toc_number toc_depth_2\">2.5<\/span> (5) Data can be restored<\/a><\/li><li><a href=\"#6_Exporting_as_CSV_or_PDF\"><span class=\"toc_number toc_depth_2\">2.6<\/span> (6) Exporting as CSV or PDF<\/a><\/li><\/ul><\/li><li><a href=\"#Best_tool_for_use_with_Google_Sheets\"><span class=\"toc_number toc_depth_1\">3<\/span> Best tool for use with Google Sheets<\/a><ul><li><a href=\"#Stock_The_easiest_way_to_keep_your_team_informed\"><span class=\"toc_number toc_depth_2\">3.1<\/span> Stock | The easiest way to keep your team informed<\/a><\/li><\/ul><\/li><li><a href=\"#How_to_use_Google_Sheets\"><span class=\"toc_number toc_depth_1\">4<\/span> How to use Google Sheets<\/a><ul><li><a href=\"#Usage_1Log_in_Create_a_new_spreadsheet\"><span class=\"toc_number toc_depth_2\">4.1<\/span> Usage 1\uff5cLog in \/ Create a new spreadsheet<\/a><\/li><li><a href=\"#Usage_2Creating_a_table\"><span class=\"toc_number toc_depth_2\">4.2<\/span> Usage 2\uff5cCreating a table<\/a><\/li><li><a href=\"#Usage_3_Leave_comments\"><span class=\"toc_number toc_depth_2\">4.3<\/span> Usage 3 | Leave comments<\/a><\/li><li><a href=\"#Usage_4_Decide_a_title_of_Sheets\"><span class=\"toc_number toc_depth_2\">4.4<\/span> Usage 4 | Decide a title of Sheets<\/a><\/li><li><a href=\"#Usage_5Sharing_a_sheet\"><span class=\"toc_number toc_depth_2\">4.5<\/span> Usage 5\uff5cSharing a sheet<\/a><\/li><li><a href=\"#Usage_6Using_on_a_smartphone\"><span class=\"toc_number toc_depth_2\">4.6<\/span> Usage 6\uff5cUsing on a smartphone<\/a><\/li><\/ul><\/li><li><a href=\"#Advanced_usage_of_Google_Sheets\"><span class=\"toc_number toc_depth_1\">5<\/span> Advanced usage of Google Sheets<\/a><ul><li><a href=\"#Usage_1Convert_to_Excel_and_save\"><span class=\"toc_number toc_depth_2\">5.1<\/span> Usage 1\uff5cConvert to Excel and save<\/a><\/li><li><a href=\"#Usage_2Checking_the_changelog\"><span class=\"toc_number toc_depth_2\">5.2<\/span> Usage 2\uff5cChecking the changelog<\/a><\/li><li><a href=\"#Usage_3Add_extensions\"><span class=\"toc_number toc_depth_2\">5.3<\/span> Usage 3\uff5cAdd extensions<\/a><\/li><li><a href=\"#Usage_4Setting_sheet_sharing_permissions_and_protection\"><span class=\"toc_number toc_depth_2\">5.4<\/span> Usage 4\uff5cSetting sheet sharing permissions and protection<\/a><\/li><li><a href=\"#Usage_5Use_functions\"><span class=\"toc_number toc_depth_2\">5.5<\/span> Usage 5\uff5cUse functions<\/a><\/li><li><a href=\"#Usage_6Use_absolute_and_relative_references\"><span class=\"toc_number toc_depth_2\">5.6<\/span> Usage 6\uff5cUse absolute and relative references<\/a><\/li><li><a href=\"#Usage_7Referencing_data\"><span class=\"toc_number toc_depth_2\">5.7<\/span> Usage 7\uff5cReferencing data<\/a><\/li><li><a href=\"#Usage_8Using_shortcut_keys\"><span class=\"toc_number toc_depth_2\">5.8<\/span> Usage 8\uff5cUsing shortcut keys<\/a><\/li><\/ul><\/li><li><a href=\"#What_is_the_difference_of_Google_Workspace_between_the_free_version_and_the_paid_version\"><span class=\"toc_number toc_depth_1\">6<\/span> What is the difference of Google Workspace between the free version and the paid version?<\/a><ul><li><a href=\"#Fees\"><span class=\"toc_number toc_depth_2\">6.1<\/span> Fees<\/a><\/li><li><a href=\"#Strength_of_security\"><span class=\"toc_number toc_depth_2\">6.2<\/span> Strength of security<\/a><\/li><li><a href=\"#Data_capacity\"><span class=\"toc_number toc_depth_2\">6.3<\/span> Data capacity<\/a><\/li><\/ul><\/li><li><a href=\"#Frequently_asked_questions_about_sheets\"><span class=\"toc_number toc_depth_1\">7<\/span> Frequently asked questions about sheets<\/a><\/li><li><a href=\"#Summary_of_how_to_use_Google_Sheets\"><span class=\"toc_number toc_depth_1\">8<\/span> Summary of how to use Google Sheets<\/a><\/li><\/ul><\/div>\n<h2><span id=\"What_is_a_Google_Sheets\">What is a Google Sheets?<\/span><\/h2>\n<div>The following describes the features and functions of Google Sheets. Find out how it differs from similar sheets and determine if it is the right tool for your company.<\/div>\n\n<h3><span id=\"Differences_between_Google_Sheets_and_other_tools\">Differences between Google Sheets and other tools<\/span><\/h3>\n<img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.41.03.jpg\" alt=\"Image of top page of Google Sheets\" width=\"700\">\n<div>Refer to: <a href=\"https:\/\/www.google.com\/sheets\/about\/\" target=\"_blank\" rel=\"noopener noreferrer\">Official site of Google Sheets<\/a><\/div>\n<div>&nbsp;<\/div>\n<div>Google Sheets is a &#8220;spreadsheet software&#8221; provided by Google Inc. Anyone can use it immediately after obtaining a free Google account.<\/div>\n<div>&nbsp;<\/div>\n<div>Unlike &#8220;Excel,&#8221; which can also create and decorate graphs, Google Sheets is specialized for simple sheets and regression analysis. On the other hand, a programming language called GAS (Google Apps Script) can automate complex processes.<\/div>\n<div>&nbsp;<\/div>\n<div>Therefore, it can be said that Google Sheets is a tool that can greatly reduce the time and effort required for calculation and analysis.<\/div>\n<div>&nbsp;<\/div>\n<div>\u30fb<a href=\"https:\/\/www.google.com\/sheets\/about\/\" target=\"_blank\" rel=\"noopener noreferrer\">Click here for the official Google Sheets website.<\/a><\/div>\n<div>\u30fb<a href=\"https:\/\/apps.apple.com\/us\/app\/google-sheets\/id842849113\" target=\"_blank\" rel=\"noopener noreferrer\">Click here for the App Store download page<\/a><\/div>\n<div>\u30fb<a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.google.android.apps.docs.editors.sheets&#038;hl=en_US&#038;gl=US\" target=\"_blank\" rel=\"noopener noreferrer\">Click here for the Google Play download page<\/a><\/div>\n\n<h3><span id=\"Features_of_Google_Sheets\">Features of Google Sheets<\/span><\/h3>\n<div>The following are the six basic features of Google Sheets.<\/div>\n<div>&nbsp;<\/div>\n<div style=\"overflow-x:scroll\"><\/div>\n<table>\n<tbody>\n<tr>\n<th style=\"min-width:100px\"><b>Function<\/b><\/th>\n<th style=\"min-width:200px\"><b>Contents<\/b><\/th>\n<\/tr>\n<tr>\n<td>Simultaneous editing<\/td>\n<td>\n<div>Multiple people can edit at the same time<\/div><\/td>\n<\/tr>\n<tr>\n<td>Viewing and Editing in Web Browser<\/td>\n<td>\n<div>Viewing and editing can be performed not only from the app but also from a web browser<\/div><\/td>\n<\/tr>\n<tr>\n<td>Auto Save<\/td>\n<td>\n<div>Data is always saved automatically<\/div><\/td>\n<\/tr>\n<tr>\n<td>Compatible with Excel<\/td>\n<td>\n<div>Google Sheets and Excel can be exchanged with each other<\/div><\/td>\n<\/tr>\n<tr>\n<td>Data Restoration<\/td>\n<td>\n<div>Easily restore past versions<\/div><\/td>\n<\/tr>\n<tr>\n<td>Export as CSV or PDF<\/td>\n<td>\n<div>Export files in CSV or PDF format<\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div>In addition to the above six functions, Google Sheets has many other useful features for data management and analysis.<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>\n<h2><span id=\"6_things_you_can_do_with_Google_Sheets\">6 things you can do with Google Sheets<\/span><\/h2>\n<div>Below are six things you can do with Google Sheets. Before learning how to use them specifically, let&#8217;s check what kind of scenarios they can be used in.<\/div>\n\n<h3><span id=\"1_Multiple_people_can_edit_at_the_same_time\">(1) Multiple people can edit at the same time<\/span><\/h3>\n<div>As long as you are connected to a network environment, multiple people can edit at the same time.<\/div>\n<div>&nbsp;<\/div>\n<div>The member&#8217;s name is displayed in the cell being edited, so you can see &#8220;who is editing where&#8221; at a glance. This prevents the mistake of editing the same cell more than once.<\/div>\n\n<h3><span id=\"2_Can_be_viewed_and_edited_with_a_web_browser\">(2) Can be viewed and edited with a web browser<\/span><\/h3>\n<div>Google Sheets can be viewed and edited from web browsers such as Google Chrome and Safari. Therefore, even in the unlikely event that app installation is restricted, you can rest assured that you can view and edit your sheets.<\/b><\/div>\n<div>&nbsp;<\/div>\n<div>In addition, as shown in the figure below, if you issue a shared URL (link) for the sheet, there is no need to download the file and send it by e-mail.<\/div>\n<div>&nbsp;<\/div>\n<div>However, if the URL is shared via a chat tool, it will be swept away in other messages and the URL will not be found when needed. Therefore, use a tool like <b><a href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_text_link', 'value': '0'});\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color:blue\">Stock<\/a><\/b> to share URLs.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.44.35.png\" alt=\"Image of share setting of Google Sheets\" width=\"700\"><\/div>\n\n<h3><span id=\"3_Data_is_automatically_saved\">(3) Data is automatically saved<\/span><\/h3>\n<div>Data on a Google Sheets is always saved automatically. This avoids the situation where data is lost because you forgot to save it.<\/div>\n<div>&nbsp;<\/div>\n<div>In addition, the data saved in the past is recorded in the edit history, including &#8220;when, who, and what kind of changes were made. When checking the edit history, use the [clock symbol] at the top of the screen to check any version.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.44.42.png\" alt=\"Image of confirming edit history\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>Note, however, that the data is saved automatically only when you are connected to the Internet, so you need to pay attention to your connection environment.<\/div>\n\n<h3><span id=\"4_Excel_support\">(4) Excel support.<\/span><\/h3>\n<div>Google Sheets and Excel can be converted to each other.<\/div>\n<div>&nbsp;<\/div>\n<div>For example, to convert Excel to a spreadsheet, select [File] > [Import] > [Upload] in the upper left corner of the screen, drag and drop any file, and you are done.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.44.51.png\" alt=\"Image of uploading a Excel file to Google Sheets\" width=\"700\"><\/div>\n\n<h3><span id=\"5_Data_can_be_restored\">(5) Data can be restored<\/span><\/h3>\n<div>Google Sheets stores past versions as edit history and can be easily restored.<\/div>\n<div>&nbsp;<\/div>\n<div>To restore data, go to [Last Edit] or [File] > [Change History] at the top of the screen to display the history list. When you find the version you wish to restore, click [Restore this version] in the upper left corner of the screen.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.45.33.png\" alt=\"Image of recovering from edit history\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>With these operations, you can restore the old version of the data.<\/div>\n\n<h3><span id=\"6_Exporting_as_CSV_or_PDF\">(6) Exporting as CSV or PDF<\/span><\/h3>\n<div>Files created in Google Sheets can be exported in CSV or PDF format.<\/div>\n<div>&nbsp;<\/div>\n<div>For example, to export in PDF format, select [PDF(.pdf)] from [File] > [Download] in the upper left corner of the screen.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.45.50.png\" alt=\"Image of download CSV or PDF\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>Exporting in different file formats like this will help with printing and importing data.<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>\n<h2><span id=\"Best_tool_for_use_with_Google_Sheets\">Best tool for use with Google Sheets<\/span><\/h2>\n<div>Below is the best tool for use with Google Sheets.<\/div>\n<div>&nbsp;<\/div>\n<div>Data created in Google Sheets can be shared with your team via a shared link. However, if you send a share link via a chat tool, it gets buried in other messages and cannot be found when it is needed.<\/div>\n<div>&nbsp;<\/div>\n<div>Therefore, it is recommended to manage shared URLs with &#8220;information sharing tools that do not allow information to be lost like chat tools. Furthermore, if the information sharing can be stored and a &#8220;message function&#8221; is provided, you can easily communicate about the shared information.<\/div>\n<div>&nbsp;<\/div>\n<div>In conclusion, the tool that should be used in combination with Google Sheets is <b><mark><b><a href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_text_link', 'value': '0'});\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color:blue\">Stock<\/a><\/b>, which allows you to leave a shared link in the &#8220;Note&#8221; where you store information, and allows casual communication through &#8220;Messages&#8221;<\/b><\/mark>.<\/div>\n<div>&nbsp;<\/div>\n<div>Stock&#8217;s &#8220;Note&#8221; allows you to easily stock information such as text and files, as well as shared links. In addition, each &#8220;note&#8221; is associated with a &#8220;message,&#8221; so that the topics of communication do not get mixed up, which is an advantage that other information sharing tools do not have.<\/div>\n\n<h3><span id=\"Stock_The_easiest_way_to_keep_your_team_informed\">Stock | The easiest way to keep your team informed<\/span><\/h3>\n<a href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_top', 'value': '0'});\"><img decoding=\"async\" class=\"wp-image-1874 aligncenter\" src=\"https:\/\/d1e4giw8bkqfro.cloudfront.net\/stock_media\/en\/stock_top_2.png\" alt=\"TopPage of Stock\" width=\"600\" data-dummy-height=\"227\" loading=\"lazy\"><\/a>\n<div>&nbsp;<\/div>\n<div>The simplest tool to stock information \"Stock\"<\/div>\n<p><a href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" class=\"mn_test_link_top\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_top', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a><\/p>\n<div>Stock is the simplest tool to stock information. Stock solves the problem, \"there is no easy way to stock information within the company\".<\/div>\n<div>&nbsp;<\/div>\n<div>With Stock, anyone can easily store all kinds of information, including text information such as requirements, images, and files, using the Note feature.<\/div>\n<div>&nbsp;<\/div>\n<div>In addition, by using the \"Task\" and \"Message\" functions, you can communicate with each topic described in the Note, so that information is not dispersed here and there and work can always be carried out in an organized manner.<\/div>\n<h4>\uff1cWhy do we recommend Stock?\uff1e<\/h4>\n<ol>\n    <li><b>A tool for companies that are not familiar with IT<\/b>\n        <div>You don't need to have any IT expertise to get started.<\/div>\n    <\/li>\n    <li><b>Simple and usable by anyone<\/b>\n        <div>Stock is so simple that anyone can use it without any unnecessary features.<\/div>\n    <\/li>\n    <li><b>Amazingly easy information storing and task management<\/b>\n        <div>It is amazingly easy to store information such as shared information within a company, and intuitive task management is also possible.<\/div>\n    <\/li>\n<\/ol>\n<div class=\"stock_area_pricing\">\n    <h4>\uff1cStock's pricing\uff1e<\/h4>\n    <p><a href=\"https:\/\/www.stock-app.info\/en\/pricing.html?utm_source=blog&amp;utm_medium=204883\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_pricing', 'value': '0'});\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter size-medium wp-image-1078\" src=\"https:\/\/d1e4giw8bkqfro.cloudfront.net\/stock_media\/stock_pricing_en_240903.png\" alt=\"Stock's fee plan page\" width=\"600\" loading=\"lazy\"><\/a><\/p>\n    <ul style=\"margin-bottom: 20px;\">\n        <li>        <!-- MN102\u304c\u7d42\u308f\u3063\u305f\u3089event_label: 'Stock_pricing'\u306egtag\u3092\u524a\u9664 -->\n        <a href=\"https:\/\/www.stock-app.info\/en\/pricing.html?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" class=\"pricingBtn\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_pricing', 'value': '0'});gtag('event', 'Stock_pricing', {'event_category': '204883', 'value': '0'})\">\n            Free plan        <\/a>\n\uff1a<b>Free<\/b><\/li>\n        <li>        <!-- MN102\u304c\u7d42\u308f\u3063\u305f\u3089event_label: 'Stock_pricing'\u306egtag\u3092\u524a\u9664 -->\n        <a href=\"https:\/\/www.stock-app.info\/en\/pricing.html?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" class=\"pricingBtn\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_pricing', 'value': '0'});gtag('event', 'Stock_pricing', {'event_category': '204883', 'value': '0'})\">\n            Business plan        <\/a>\n\uff1a<b>$5 \/ User \/ Month<\/b><\/li>\n        <li>        <!-- MN102\u304c\u7d42\u308f\u3063\u305f\u3089event_label: 'Stock_pricing'\u306egtag\u3092\u524a\u9664 -->\n        <a href=\"https:\/\/www.stock-app.info\/en\/pricing.html?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" class=\"pricingBtn\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_pricing', 'value': '0'});gtag('event', 'Stock_pricing', {'event_category': '204883', 'value': '0'})\">\n            Enterprise plan        <\/a>\n\uff1a<b>$10 \/ User \/ Month<\/b><\/li>\n    <\/ul>\n    <p>*Minimum number of users: 5 users<\/p>\n    <p>        <!-- MN102\u304c\u7d42\u308f\u3063\u305f\u3089event_label: 'Stock_pricing'\u306egtag\u3092\u524a\u9664 -->\n        <a href=\"https:\/\/www.stock-app.info\/en\/pricing.html?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" class=\"pricingBtn\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_pricing', 'value': '0'});gtag('event', 'Stock_pricing', {'event_category': '204883', 'value': '0'})\">\n            https:\/\/www.stock-app.info\/en\/pricing.html        <\/a>\n<\/div>\n<div class=\"article_link_button_container\">\n    <a class=\"btn-square-little-rich detail_btn\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_button', 'value': '0'});\">For more information about Stock<\/a>\n<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>\n<h2><span id=\"How_to_use_Google_Sheets\">How to use Google Sheets<\/span><\/h2>\n<div>This section explains how to register and basically use Google Sheets. The operation method is almost the same as that of Excel, so even first-time members can use it with ease.<\/div>\n\n<h3><span id=\"Usage_1Log_in_Create_a_new_spreadsheet\">Usage 1\uff5cLog in \/ Create a new spreadsheet<\/span><\/h3>\n<div>First, access <a href=\"https:\/\/www.google.com\/sheets\/about\/\" target=\"_blank\" rel=\"noopener noreferrer\">the official Google Sheets website<\/a> and click [Go to sheets].<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.46.10.jpg\" alt=\"Image of top page of Google Sheets\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>If you do not have a Google account, register a new one.<\/div>\n<div>&nbsp;<\/div>\n<div>Once you are logged in, you will be taken to the Google Sheets home page, where you can create a new sheet by clicking [+] as shown below.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.47.09.png\" alt=\"Image of creating Google Sheets\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>With the above operations, you are ready to use Google Sheets.<\/div>\n\n<h3><span id=\"Usage_2Creating_a_table\">Usage 2\uff5cCreating a table<\/span><\/h3>\n<div>Next, let&#8217;s create a table in Google Sheets. Here, we will explain how to create a simple sales table.<\/div>\n<div>&nbsp;<\/div>\n<div>First, click on any cell and enter the product name, and then also prepare the &#8220;Product Unit Price,&#8221; &#8220;Number of Items,&#8221; and &#8220;Total Amount&#8221; fields, and enter a numerical value (one-byte character) in each of the Product Unit Price and Number of Items. Then, enter &#8220;=cell for product unit price * cell for number of items&#8221; in the cell for total amount, and the total amount will be calculated automatically.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.50.12.png\" alt=\"Image of entering the formula in the cell\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>Once you have filled in all the fields, select the entire table and click on the desired [border] from the top of the screen to complete the sales table.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.50.37.png\" alt=\"Image of reflecting grid line to make table\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>You can also change the color of the cells and text to make the table visually easier to understand. Change them as appropriate from the icons at the top of the screen, as shown in the diagram below.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.50.54.png\" alt=\"Image of filling the color to cell\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.51.01.png\" alt=\"Image of changing the color of letter\" width=\"700\"><\/div>\n\n<h3><span id=\"Usage_3_Leave_comments\">Usage 3 | Leave comments<\/span><\/h3>\n<div>Google Sheets allows you to leave comments in specific cells.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.51.31.png\" alt=\"Image of adding the comment\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>To leave a comment, simply select [Insert Comment] and enter text.<\/div>\n<div>&nbsp;<\/div>\n<div>By doing so, you can see who left the comment and reply to the comment. This makes it easy to share information and check progress within the sheet.<\/div>\n\n<h3><span id=\"Usage_4_Decide_a_title_of_Sheets\">Usage 4 | Decide a title of Sheets<\/span><\/h3>\n<div>To add a title to the sheet, enter the title in the [untitled sheet] box in the top left-hand corner of the screen.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.51.41.png\" alt=\"Image of entering the title of Sheets\" width=\"700\"><\/div>\n\n<h3><span id=\"Usage_5Sharing_a_sheet\">Usage 5\uff5cSharing a sheet<\/span><\/h3>\n<div>To share a Google Sheets, first click [Share] in the top right corner of the screen.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.52.12.png\" alt=\"Image of share setting of Google Sheets\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>Next, enter the email addresses of the members you wish to share with and select from the following three permissions.<\/div>\n<div>&nbsp;<\/div>\n<ul>\n \t<li>[Viewer] Can only view the sheet.<\/li>\n \t<li>[Viewer (comments allowed)] Cannot edit sheets, but can leave comments.<\/li>\n \t<li>[Editor] Can edit the sheet.<\/li>\n<\/ul>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.52.39.png\" alt=\"Image of changing privilege\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>You can also copy and send URLs using [Copy link]. However, be aware that if you set the permission setting to &#8216;Everyone who knows the link&#8217;, anyone who knows the URL can access it.<\/div>\n\n<h3><span id=\"Usage_6Using_on_a_smartphone\">Usage 6\uff5cUsing on a smartphone<\/span><\/h3>\n<div>Below are the steps for creating a Google Sheets on a smartphone.<\/div>\n<div>&nbsp;<\/div>\n<div>Launch the Google Sheets app and the screen shown below will appear. Select [New sheet] from [+] in the bottom right-hand corner of the screen.<\/div>\n<div>&nbsp;<\/div>\n<div>Finally, enter a sheet name and you can use it in the same way as the web browser version.<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>\n<h2><span id=\"Advanced_usage_of_Google_Sheets\">Advanced usage of Google Sheets<\/span><\/h2>\n<div>This section describes eight ways to use Google Sheets in a variety of apps. The following uses will help you to work more smoothly.<\/div>\n\n<h3><span id=\"Usage_1Convert_to_Excel_and_save\">Usage 1\uff5cConvert to Excel and save<\/span><\/h3>\n<div>To convert a Sheets to Excel, click File > Download > Microsoft Excel (.xlsx) in the top left-hand corner of the screen.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.53.51.png\" alt=\"Image of converting to Excel file\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>This will allow you to save your edits in the Sheets as Excel.<\/div>\n\n<h3><span id=\"Usage_2Checking_the_changelog\">Usage 2\uff5cChecking the changelog<\/span><\/h3>\n<div>To check the changelog, click [Last Edit] at the top of the screen, as shown below.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-10.44.42.png\" alt=\"Image of displayed edit history\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>The history will be displayed on the right-hand side of the screen when you click on it.<\/div>\n\n<h3><span id=\"Usage_3Add_extensions\">Usage 3\uff5cAdd extensions<\/span><\/h3>\n<div>Google Sheets has &#8216;add-ons&#8217; to extend its functionality.<\/div>\n<div>&nbsp;<\/div>\n<div>To use them, select [Extensions] > [Add-ons] > [Get Add-ons] at the top of the screen and install the add-on of your choice to complete the process.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-11.35.37.png\" alt=\"Image of setting of add-on\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>By utilizing add-ons, you can automatically add Gantt chart templates and automatically paste Google Analytics analysis results into a spreadsheet.<\/div>\n\n<h3><span id=\"Usage_4Setting_sheet_sharing_permissions_and_protection\">Usage 4\uff5cSetting sheet sharing permissions and protection<\/span><\/h3>\n<div>To set sharing permissions and protect specific sheets, follow the instructions below.<\/div>\n<h4>Sheet sharing permissions<\/h4>\n<div>There are two types of sharing methods: &#8216;link sharing&#8217;, which uses the URL allocated to each sheet, and &#8217;email address sharing&#8217; between Gmail accounts.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-11.35.52.png\" alt=\"Image of setting share Google Sheets\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>In link sharing, sheets can be shared with members who do not have a Google account. However, since anyone with knowledge of the shared link can access it, extreme care must be taken to avoid information leaks.<\/div>\n<div>&nbsp;<\/div>\n<div>Email address sharing, on the other hand, has a low risk of leakage because the sharing settings are set individually. However, email addresses have to be entered one by one.<\/div>\n<h4>Setting up sheet protection<\/h4>\n<div>To protect a sheet, select [\u25bc] > [Protect sheet] in the Sheet tab at the bottom of the screen and set the protection range.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-11.36.20.png\" alt=\"Image of protection of a sheet\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>This will protect the sheet and prevent accidental editing.<\/div>\n\n<h3><span id=\"Usage_5Use_functions\">Usage 5\uff5cUse functions<\/span><\/h3>\n<div>You can use the following functions in Google Sheets to automate tedious calculations.<\/div>\n<div>&nbsp;<\/div>\n<div style=\"overflow-x:scroll\">\n<table>\n<tbody>\n<tr>\n<th style=\"min-width:120px\"><b>Function<\/b><\/th>\n<th style=\"min-width:250px\"><b>Effect<\/b><\/th>\n<\/tr>\n<tr>\n<td>=SUM(starting cell: ending cell)<\/td>\n<td>\n<div>This function sums the numbers in a specified range.<\/div><\/td>\n<\/tr>\n<tr>\n<td>=AVERAGE(starting cell: ending cell)<\/td>\n<td>\n<div>This function averages the numbers in the specified range.<\/div><\/td>\n<\/tr>\n<tr>\n<td>=COUNT(Cells at start:Cells at end)<\/td>\n<td>\n<div>Function to calculate the number of cells in a specified range.<\/div><\/td>\n<\/tr>\n<tr>\n<td>=MAX(Cells at start:cells at end)<\/td>\n<td>\n<div>This function calculates the maximum number of cells in the specified range.<\/div><\/td>\n<\/tr>\n<tr>\n<td>=MIN (starting cell: ending cell)<\/td>\n<td>\n<div>This function returns the minimum number in the specified range.<\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>Use the above functions to significantly improve your business.<\/div>\n\n<h3><span id=\"Usage_6Use_absolute_and_relative_references\">Usage 6\uff5cUse absolute and relative references<\/span><\/h3>\n<div>When using functions in Google Sheets, it is useful to use &#8216;absolute references&#8217; and &#8216;relative references&#8217; separately. Specifically, this is explained in the following &#8216;Example of obtaining the percentage of the total amount for a single product&#8217;.<\/div>\n<div>&nbsp;<\/div>\n<div>If you enter a function as shown in the diagram below and try to reflect it in other cells, an error occurs and the calculation cannot be performed. The reason for this is that you are using a &#8216;relative reference&#8217; where the range changes accordingly, and the referenced cell (cell 2770 in the following) is shifted.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-11.39.57.png\" alt=\"Image of calculation by each cell\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-11.40.03.png\" alt=\"Image that is not calculated by cells displacement\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div>Absolute referencing&#8221; is therefore the solution to errors such as the one shown above.<\/div>\n<div>&nbsp;<\/div>\n<div>To set up an absolute reference, simply add a [$] to the cell you want to always include in the range. As a result, reflecting the function in other cells will not cause errors.<\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-11.40.40.png\" alt=\"Image of setting for absolute reference cells\" width=\"700\"><\/div>\n<div>&nbsp;<\/div>\n<div class=\"stock-center\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-02-16-11.40.54.png\" alt=\"Image of absolute reference\" width=\"700\"><\/div>\n\n<h3><span id=\"Usage_7Referencing_data\">Usage 7\uff5cReferencing data<\/span><\/h3>\n<div>One of the functions of Google Sheets is &#8216;Referencing data&#8217;. Specifically, enter the following formula in the cell at the reference location.<\/div>\n<div>&nbsp;<\/div>\n<ul>\n \t<li><b>= &#8216;sheet name&#8217;! Cell location.<\/b><\/li>\n<\/ul>\n<div>The above formula saves you the trouble of moving between sheets and manually copying and pasting. The diagram below shows an example of a cell on Sheet 1 with the word &#8216;sample&#8217; in cell A1 of Sheet 2, reflecting the cell.<\/div>\n\n<h3><span id=\"Usage_8Using_shortcut_keys\">Usage 8\uff5cUsing shortcut keys<\/span><\/h3>\n<div>To work more efficiently with Google Sheets, use shortcut keys. The table below lists useful shortcut keys unique to Google Sheets.<\/div>\n<div>&nbsp;<\/div>\n<div>\n<table border=\"1\">\n<tbody>\n<tr>\n<th><b>Shortcut<\/b><\/th>\n<th><b>Effect<\/b><\/th>\n<\/tr>\n<tr>\n<td>Ctrl+Home<\/td>\n<td>\n<div>Move to the top of the sheet<\/div><\/td>\n<\/tr>\n<tr>\n<td>Ctrl+End<\/td>\n<td>\n<div>Move to the end of the sheet<\/div><\/td>\n<\/tr>\n<tr>\n<td>Alt+\u2193<\/td>\n<td>\n<div>Move to the next sheet<\/div><\/td>\n<\/tr>\n<tr>\n<td>Alt+\u2191<\/td>\n<td>\n<div>Move to the previous sheet<\/div><\/td>\n<\/tr>\n<tr>\n<td>Ctrl+Alt+Shift+H<\/td>\n<td>\n<div>Open changelog<\/div><\/td>\n<\/tr>\n<tr>\n<td>shift+F2<\/td>\n<td>\n<div>Create or edit a note<\/div><\/td>\n<\/tr>\n<tr>\n<td>Ctrl+Alt+9<\/td>\n<td>\n<div>Hide a line<\/div><\/td>\n<\/tr>\n<tr>\n<td>Ctrl+Shift+9<\/td>\n<td>\n<div>Redisplay a line<\/div><\/td>\n<\/tr>\n<tr>\n<td>Ctrl+Alt+0<\/td>\n<td>\n<div>Hide columns<\/div><\/td>\n<\/tr>\n<tr>\n<td>Ctrl+Shift+0<\/td>\n<td>\n<div>Redisplay column<\/div><\/td>\n<\/tr>\n<tr>\n<td>Ctrl+~<\/td>\n<td>\n<div>Show all formulas<\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>Refer to:<a href=\"https:\/\/support.google.com\/docs\/answer\/181110?hl=en&#038;co=GENIE.Platform\" target=\"_blank\" rel=\"nofollow noopener noreferrer\"> Keyboard shortcuts in Google Sheets<\/a><\/div>\n<div>&nbsp;<\/div>\n<div>The above shortcut keys can be difficult to remember, but master them little by little to improve your work efficiency.<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>\n<h2><span id=\"What_is_the_difference_of_Google_Workspace_between_the_free_version_and_the_paid_version\">What is the difference of Google Workspace between the free version and the paid version?<\/span><\/h2>\n<div>Google Sheets can be used for free, but the paid version of Google Workspace expands your usage. Different plans have different features and functions, and the differences between the free and paid versions are explained below.<\/div>\n\n<h3><span id=\"Fees\">Fees<\/span><\/h3>\n<div>The paid version of Google Sheets (Google Workspace) has the following four plans<\/div>\n<div>&nbsp;<\/div>\n<div>\n<table border=\"1\">\n<tbody>\n<tr>\n<th>Plan name<\/th>\n<th>Annually fee\/user<\/th>\n<\/tr>\n<tr>\n<td><b>Business Starter<\/b><\/td>\n<td>$6.00<\/td>\n<\/tr>\n<tr>\n<td><b>Business Standard<\/b><\/td>\n<td>$12.00<\/td>\n<\/tr>\n<tr>\n<td><b>Business Plus<\/b><\/td>\n<td>$18.00<\/td>\n<\/tr>\n<tr>\n<td><b>Enterprise<\/b><\/td>\n<td>Inquiry required<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>Refer to: <a href=\"https:\/\/workspace.google.com\/intl\/en_us\/lp\/business\/?utm_source=google&#038;utm_medium=cpc&#038;utm_campaign=1707696-Workspace-APAC-JP-en-BKWS-EXA-HV&#038;utm_content=text-ad-none-none-DEV_c-CRE_592376947167-ADGP_Hybrid%20%7C%20BKWS%20-%20EXA%20%7C%20Txt-Workspace-N%2FA-KWID_43700070620942688-kwd-971606609186&#038;userloc_1009307-network_g&#038;utm_term=KW_workspace%20business%20starter&#038;gad_source=1&#038;gclid=CjwKCAiAibeuBhAAEiwAiXBoJI5XjUV42XtZxlXPpzwBqg3rthT9QK84EgbuQJzmX-VvP5wLJUpDERoC5xAQAvD_BwE&#038;gclsrc=aw.ds\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google Workspace price plans<\/a><\/div>\n<div>&nbsp;<\/div>\n<div>All of the above plans have unlimited Google Sheets functionality. However, the capacity and security of Google Drive, where data is stored, differ.<\/div>\n\n<h3><span id=\"Strength_of_security\">Strength of security<\/span><\/h3>\n<div>The free version of Google Sheets does not have advanced security features.<\/div>\n<div>&nbsp;<\/div>\n<div>Paid plans, on the other hand, offer a higher level of security by placing restrictions on your account, such as &#8216;two-step verification&#8217;. They also have a support system in case of problems.<\/div>\n<div>&nbsp;<\/div>\n<div>Therefore, if you handle sensitive data such as customer information or research results, it is recommended to subscribe to a paid plan.<\/b><\/div>\n\n<h3><span id=\"Data_capacity\">Data capacity<\/span><\/h3>\n<div>The data capacity of each plan is as follows<\/div>\n<div>&nbsp;<\/div>\n<div>\n<table border=\"1\">\n<tbody>\n<tr>\n<th>Plan name\/th>\n<th>Data capacity (per user)<\/th>\n<\/tr>\n<tr>\n<td><b>Free plan<\/b><\/td>\n<td>15GB<\/td>\n<\/tr>\n<tr>\n<td><b>Business Starter<\/b><\/td>\n<td>30GB<\/td>\n<\/tr>\n<tr>\n<td><b>Business Standard<\/b><\/td>\n<td>2TB<\/td>\n<\/tr>\n<tr>\n<td><b>Business Plus<\/b><\/td>\n<td>5TB<\/td>\n<\/tr>\n<tr>\n<td><b>Enterprise<\/b><\/td>\n<td>5TB(expandable as required)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div>In addition to the above, the free version of the web conferencing tool Google Meet can be used by up to 100 simultaneous users, while the paid version can be used by &#8220;up to 1,000 users&#8221;, although there are differences between plans.<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>\n<h2><span id=\"Frequently_asked_questions_about_sheets\">Frequently asked questions about sheets<\/span><\/h2>\n<div>Here are some frequently asked questions and answers about spreadsheets. The main examples are as follows.<\/div>\n<div>&nbsp;<\/div>\n<ul>\n \t<li><b><u>Question 1: What is the difference between a Google Sheet and Excel?<\/u><\/b><\/li>\n<div>Sheets use a browser, while Excel is basically software-based. Also, sheets are easier to edit simultaneously than Excel, and it is easy to see &#8220;who made what changes and where&#8221;.<\/div>\n<div>&nbsp;<\/div>\n \t<li><b><u>Question 2\uff5cWhich is better, sheets or Excel?<\/u><\/b><\/li>\n<div>In conclusion, it is recommended that you use both depending on the purpose.<\/div>\n<div>&nbsp;<\/div>\n<div>For example, Excel has a wealth of functions other than sheets, such as creating and decorating graphs. Therefore, it is advisable to use Excel when you want to use it for a wide range of purposes, and use a sheet when you only want to use it for sheets.<\/div>\n<div>&nbsp;<\/div>\n \t<li><b><u>Question 3\uff5cWhat do you use Google Sheets for?<\/u><\/b><\/li>\n<div>Google Sheets are used for creating sheets and simple charts. Although direct interaction on the tool is not possible, sheets can be shared by creating links.<\/div><\/ul>\n<div>From the above, it can be seen that sheets are specialised in sheets. On the other hand, charting and communication require a different tool.<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>\n<h2><span id=\"Summary_of_how_to_use_Google_Sheets\">Summary of how to use Google Sheets<\/span><\/h2>\n<div>We have focused on the features and usage of Google Sheets, as well as the differences between the different pricing plans.<\/div>\n<div>&nbsp;<\/div>\n<div>Google Sheets can be easily shared with members via a link (URL), but sharing a link via a chat tool can be troublesome as it gets buried in other messages. On the other hand, sharing email addresses takes a lot of time and effort to input.<\/div>\n<div>&nbsp;<\/div>\n<div>Using an &#8216;information sharing tool with no data flow&#8217; makes it easy to find the desired link and share sheets smoothly. Furthermore, if you use an information sharing tool with a &#8216;message function&#8217;, you can save time and effort in communication.<\/div>\n<div>&nbsp;<\/div>\n<div>In conclusion, the best tool for use with Google Sheets is <b><mark>&#8216;Stock&#8217;, which has a &#8216;Notebook&#8217; where anyone can easily leave all kinds of information<\/b><\/mark>. In addition, Stock has &#8216;messages&#8217; tied to each note, so there is no intermingling of communication at all.<\/div>\n<div>&nbsp;<\/div>\n<div><b>It only takes a minute to register for free<\/b>, so using <b><a href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_text_link', 'value': '0'});\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color:blue\">Stock<\/a><\/b> in conjunction with Google Sheets for efficient information management.<\/div>\n<div class=\"article_banner\"><br \/>\n    <hr \/>\"There is no easy way to stock information within the company.\"<br \/>\n            The simplest tool to stock information \"Stock\".\n        <br \/><br \/>Simpler than any other tool, so that anyone can start to use easily.<br \/><a class=\"stock_body_ad\" href=\"https:\/\/www.stock-app.info\/en\/?utm_source=blog&amp;utm_medium=204883\" target=\"_blank\" rel=\"noopener\" onclick=\"gtag('event', 'Stock', {'event_category': '204883', 'event_label': 'Stock_body_ad', 'value': '0'});\">https:\/\/www.stock-app.info\/en\/<\/a>\n    <hr \/>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Among them, Google Sheets is used by many companies because&#8230;<\/p>\n","protected":false},"author":8,"featured_media":209573,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":{"0":"post-204883","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-project-management-apps","8":"one-column","9":"ar-one-column","10":"au-one-column"},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.stock-app.info\/en\/media\/wp-content\/uploads\/2023\/10\/rubaitul-azad-TisvwNLLWA4-unsplash-1.jpg","_links":{"self":[{"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/posts\/204883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/comments?post=204883"}],"version-history":[{"count":108,"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/posts\/204883\/revisions"}],"predecessor-version":[{"id":209622,"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/posts\/204883\/revisions\/209622"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/media\/209573"}],"wp:attachment":[{"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/media?parent=204883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/categories?post=204883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stock-app.info\/en\/media\/wp-json\/wp\/v2\/tags?post=204883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}