{"id":16179,"date":"2024-11-22T23:58:10","date_gmt":"2024-11-22T14:58:10","guid":{"rendered":"https:\/\/84office.jp\/?p=16179"},"modified":"2024-11-23T00:08:02","modified_gmt":"2024-11-22T15:08:02","slug":"redisplay-or-delete-sheets","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/redisplay-or-delete-sheets\/","title":{"rendered":"Effortlessly Unhide and Delete Hidden Sheets in Google Sheets All at Once!"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<div class=\"swell-block-capbox cap_box is-style-small_ttl u-mb-ctrl u-mb-50\" data-colset=\"col3\"><div class=\"cap_box_ttl\" data-has-icon=\"1\"><svg height=\"1em\" width=\"1em\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" viewBox=\"0 0 48 48\"><path d=\"M32 46.5H16c-1.1 0-2-.9-2-2s.9-2 2-2h16c1.1 0 2 .9 2 2s-.9 2-2 2zM33.3 18.6c-.7 0-1.3-.5-1.5-1.2-.7-3.2-3.2-5.7-6.4-6.3-.8-.1-1.4-.9-1.2-1.7s.9-1.4 1.7-1.2c4.4.8 8 4.2 8.9 8.6.2.8-.4 1.6-1.2 1.8h-.3z\"><\/path><path d=\"M30 40.5H18c-2.2 0-4-1.8-4-4v-1.6c0-.6-.3-1.1-.8-1.5C8.4 29.8 5.7 24 6 18c.5-9.1 8-16.6 17.1-17C29 .8 34.5 3.2 38.2 8c1.8 2.3 3 5.1 3.5 7.9 1.1 6.8-1.5 13.3-6.9 17.4-.6.4-.9 1-.9 1.7v1.5c.1 2.2-1.7 4-3.9 4zM23.3 5c-7.1.3-12.9 6.2-13.3 13.2-.2 4.7 1.8 9.1 5.6 11.9 1.5 1.1 2.4 2.9 2.4 4.7v.6c0 .6.4 1 1 1h10c.6 0 1-.4 1-1V35c0-1.9.9-3.7 2.5-4.8 4.3-3.2 6.3-8.5 5.3-13.9-.4-2-1.2-3.8-2.4-5.4-3-4-7.4-6.1-12.1-5.9z\"><\/path><\/svg><span>Recommended for<\/span><\/div><div class=\"cap_box_content\">\n<ul class=\"wp-block-list\">\n<li>For those who have more than 10 hidden sheets in one file<\/li>\n\n\n\n<li>For those who want to save time on manually unhiding or deleting sheets<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>In managing weekly reports and other data in Google Sheets, do you find that the number of hidden sheets keeps growing?<\/p>\n\n\n\n<p>Hiding sheets can be done with multiple selections, but what is troublesome is when you want to re-hide or delete sheets that have been hidden together.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-50\">In the case of Google Sheets, it is time-consuming to manually redisplay or delete them one by one.<\/p>\n\n\n\n<p>Google Apps Script is useful in such cases.<\/p>\n\n\n\n<p>Google Apps Script allows you to re-display or delete hidden sheets at once.<\/p>\n\n\n\n<p>Google Apps Script may sound difficult, but you can use it by copying the script, so you do not have to write it yourself.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-50\">This article will show you how to take advantage of Google Apps Script to re-display hidden sheets together and how to delete them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Script to re\uff70display hidden sheets in bulk<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-resized u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"719\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-2-1024x719.png\" alt=\"\" class=\"wp-image-16189\" style=\"width:629px\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-2-1024x719.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-2-300x211.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-2-768x539.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-2.png 1197w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Script to redisplay hidden sheets in bulk<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-40\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"function showAllSheets() {\n  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();  \/\/ Get the currently open spreadsheet\n  var sheets = spreadsheet.getSheets();  \/\/ Get the list of sheets\n  \n  \/\/ Check all sheets\n  for (var i = 0; i &lt; sheets.length; i++) {\n    var sheet = sheets[i];\n    if (sheet.isSheetHidden()) {  \/\/ If the sheet is hidden\n      sheet.showSheet();  \/\/ Unhide the sheet\n    }\n  }\n}\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">showAllSheets<\/span><span style=\"color: #F8F8F2\">() {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> spreadsheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> SpreadsheetApp.<\/span><span style=\"color: #A6E22E\">getActiveSpreadsheet<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Get the currently open spreadsheet<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheets <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> spreadsheet.<\/span><span style=\"color: #A6E22E\">getSheets<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Get the list of sheets<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #88846F\">\/\/ Check all sheets<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #F92672\">for<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> i <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">; i <\/span><span style=\"color: #F92672\">&lt;<\/span><span style=\"color: #F8F8F2\"> sheets.length; i<\/span><span style=\"color: #F92672\">++<\/span><span style=\"color: #F8F8F2\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> sheets[i];<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (sheet.<\/span><span style=\"color: #A6E22E\">isSheetHidden<\/span><span style=\"color: #F8F8F2\">()) {  <\/span><span style=\"color: #88846F\">\/\/ If the sheet is hidden<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      sheet.<\/span><span style=\"color: #A6E22E\">showSheet<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Unhide the sheet<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"u-mb-ctrl u-mb-50\">There is a copy button in the upper right corner of the code block (black screen).<\/p>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-50\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Script Description<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<p><strong><code>SpreadsheetApp.getActiveSpreadsheet()<\/code><\/strong><br><br>A command to retrieve the entire spreadsheet that is currently open.<\/p>\n\n\n\n<p>This is the part that specifies in which spreadsheet the script is running.<br><br><br><strong><code>spreadsheet.getSheets()<\/code><\/strong><br><br>Get all sheets existing in the current spreadsheet as an array (list).<\/p>\n\n\n\n<p>All sheets are retrieved here, regardless of whether they are hidden or displayed.<br><br><br><strong><code>for<\/code> <\/strong><br><br>Loop.<\/p>\n\n\n\n<p>Check all retrieved sheets one by one to see if they are hidden.<br><br><\/p>\n\n\n\n<p><strong><code>sheet.isSheetHidden()<\/code><\/strong><br><br>Function to check if a sheet is hidden or not.<\/p>\n\n\n\n<p>Returns<code>true<\/code> if hidden.<br><\/p>\n\n\n\n<p><strong><code>sheet.showSheet()<\/code><\/strong><br><br>Displays sheets in a hidden state.<\/p>\n\n\n\n<p> Only sheets that are determined to be hidden by <code>isSheetHidden()<\/code><br><br><\/p>\n<\/div><\/details>\n<\/div>\n\n\n\n<p><strong><strong>After script execution<\/strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"246\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/702114fb58551e47d3330ca5cbc3624f-1024x246.png\" alt=\"\" class=\"wp-image-16187\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/702114fb58551e47d3330ca5cbc3624f-1024x246.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/702114fb58551e47d3330ca5cbc3624f-300x72.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/702114fb58551e47d3330ca5cbc3624f-768x184.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/702114fb58551e47d3330ca5cbc3624f-1536x369.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/702114fb58551e47d3330ca5cbc3624f-2048x492.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>All sheets that were hidden will be re-displayed.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">If there are only a few hidden sheets, it will not take long to re-display them one by one, but if there are a large number of sheets, Google Apps Script can save time.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Script to delete all hidden sheets in bulk<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-resized u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"719\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-1-1024x719.png\" alt=\"\" class=\"wp-image-16188\" style=\"width:629px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-1-1024x719.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-1-300x211.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-1-768x539.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/d30195d5cba8b6150dc9ca24da93ad33-1.png 1197w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong><strong>Script to delete all hidden sheets in bulk<\/strong><\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-40\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"function deleteHiddenSheets() {\n  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();  \/\/ Get the currently open spreadsheet\n  var sheets = spreadsheet.getSheets();  \/\/ Get the list of sheets\n  \n  for (var i = sheets.length - 1; i &gt;= 0; i--) {  \/\/ Loop through all sheets from the last to the first\n    var sheet = sheets[i];\n    if (sheet.isSheetHidden()) {  \/\/ If the sheet is hidden\n      spreadsheet.deleteSheet(sheet);  \/\/ Delete the hidden sheet\n    }\n  }\n}\n\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">deleteHiddenSheets<\/span><span style=\"color: #F8F8F2\">() {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> spreadsheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> SpreadsheetApp.<\/span><span style=\"color: #A6E22E\">getActiveSpreadsheet<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Get the currently open spreadsheet<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheets <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> spreadsheet.<\/span><span style=\"color: #A6E22E\">getSheets<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Get the list of sheets<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #F92672\">for<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> i <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> sheets.length <\/span><span style=\"color: #F92672\">-<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">1<\/span><span style=\"color: #F8F8F2\">; i <\/span><span style=\"color: #F92672\">&gt;=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">; i<\/span><span style=\"color: #F92672\">--<\/span><span style=\"color: #F8F8F2\">) {  <\/span><span style=\"color: #88846F\">\/\/ Loop through all sheets from the last to the first<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> sheets[i];<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (sheet.<\/span><span style=\"color: #A6E22E\">isSheetHidden<\/span><span style=\"color: #F8F8F2\">()) {  <\/span><span style=\"color: #88846F\">\/\/ If the sheet is hidden<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      spreadsheet.<\/span><span style=\"color: #A6E22E\">deleteSheet<\/span><span style=\"color: #F8F8F2\">(sheet);  <\/span><span style=\"color: #88846F\">\/\/ Delete the hidden sheet<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"u-mb-ctrl u-mb-50\">There is a copy button in the upper right corner of the code block (black screen).<\/p>\n\n\n\n<div class=\"swell-block-accordion u-mb-ctrl u-mb-50\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Script Description<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<p><br><strong><code>SpreadsheetApp.getActiveSpreadsheet()<\/code><\/strong><br><br>Get the currently open spreadsheet.<br><\/p>\n\n\n\n<p><strong><code>spreadsheet.getSheets()<\/code><\/strong><br><br>Get all sheets. Again, all sheets regardless of whether they are hidden or not.<br><\/p>\n\n\n\n<p><strong><code>for<\/code> <\/strong><br><br>Loop.<\/p>\n\n\n\n<p><code>deleteHiddenSheets<\/code> checks the list of sheets in reverse order.<br>This is to prevent errors from occurring when deleting out of order listings.<br><\/p>\n\n\n\n<p><strong><code>sheet.isSheetHidden()<\/code><\/strong><br><br>Function to check if a sheet is hidden or not.<\/p>\n\n\n\n<p>Only hidden sheets are targeted for deletion.<br><\/p>\n\n\n\n<p><strong><code>spreadsheet.deleteSheet(sheet)<\/code><\/strong><br><br>Delete hidden sheets. This command allows you to delete at once all the hidden sheets that you no longer need.<\/p>\n<\/div><\/details>\n<\/div>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<p class=\"is-style-big_icon_caution u-mb-ctrl u-mb-50\">It is recommended that you back up your files before deleting them.<\/p>\n\n\n\n<p>A script to delete hidden sheets is useful in this situation.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You no longer need the sheets that have been hidden<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-50\">You want to organize because the file size is full and you can no longer copy sheets<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">How to use the script<\/h2>\n\n\n\n<div class=\"swell-block-capbox cap_box u-mb-ctrl u-mb-50\" data-colset=\"col3\"><div class=\"cap_box_ttl\"><span>\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u4f7f\u7528\u65b9\u6cd5<\/span><\/div><div class=\"cap_box_content\">\n<ul class=\"wp-block-list is-style-num_circle\">\n<li>Toolbar &#8211; Extensions &#8211; Apps Script<\/li>\n\n\n\n<li>Script Paste<\/li>\n\n\n\n<li>Script Save<\/li>\n\n\n\n<li>Execution<\/li>\n\n\n\n<li>Sheet is re-displayed or deleted<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Open the Apps Script Editor<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"828\" height=\"638\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/49eb48b95d4c4504148a0386b7cb3e2b.jpg\" alt=\"\" class=\"wp-image-15967\" style=\"width:483px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/49eb48b95d4c4504148a0386b7cb3e2b.jpg 828w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/49eb48b95d4c4504148a0386b7cb3e2b-300x231.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/49eb48b95d4c4504148a0386b7cb3e2b-768x592.jpg 768w\" sizes=\"(max-width: 828px) 100vw, 828px\" \/><\/figure>\n<\/div>\n\n\n<p>Open Google Sheets, then click on \u201c<strong>Extensions<\/strong>\u201d in the menu and select \u201c<strong>Apps Script<\/strong>\u201d to open the editor.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Create the Script<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"472\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-1024x472.png\" alt=\"\" class=\"wp-image-16191\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-1024x472.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-300x138.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-768x354.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662.png 1387w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>function myFunction(){<\/p>\n\n\n\n<p>}<\/p>\n\n\n\n<p>is included from the beginning, so delete it and paste the previous script.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Save the Script<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"591\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-1024x591.png\" alt=\"\" class=\"wp-image-16192\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-1024x591.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-300x173.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-768x444.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6.png 1385w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Run the Script<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"591\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-1-1024x591.png\" alt=\"\" class=\"wp-image-16193\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-1-1024x591.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-1-300x173.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-1-768x444.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fae10d4f18a02d9a3b80ad73592c94a6-1.png 1385w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Completion<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"727\" height=\"280\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-128.png\" alt=\"\" class=\"wp-image-16190\" style=\"width:482px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-128.png 727w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-128-300x116.png 300w\" sizes=\"(max-width: 727px) 100vw, 727px\" \/><\/figure>\n<\/div>\n\n\n<p>When the execution is completed, it is OK.<\/p>\n\n\n\n<p>Verify that hidden sheets have been re-displayed or deleted.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_memo u-mb-ctrl u-mb-60\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>If you&#8217;re running the script for the first time, you need to authorize it.<\/p>\n\n\n\n<p><strong>Therefore, press &#8220;<strong>Review Permissions.<\/strong>&#8220;<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"882\" height=\"345\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79.png\" alt=\"\" class=\"wp-image-15938\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79.png 882w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79-300x117.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79-768x300.png 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/figure>\n<\/div>\n\n\n<div class=\"swell-block-accordion\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Detailed Authorization Steps<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<p><strong>Press &#8220;Advanced.&#8221;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full u-mb-ctrl u-mb-50\"><img decoding=\"async\" width=\"1272\" height=\"688\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d.jpg\" alt=\"\" class=\"wp-image-15939\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d.jpg 1272w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-300x162.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-1024x554.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-768x415.jpg 768w\" sizes=\"(max-width: 1272px) 100vw, 1272px\" \/><\/figure>\n\n\n\n\n\n\n\n<p><strong>Press &#8220;Go to Untitled project (Unsafe).&#8221;<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"1305\" height=\"893\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9.jpg\" alt=\"\" class=\"wp-image-15940\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9.jpg 1305w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-300x205.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-1024x701.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-768x526.jpg 768w\" sizes=\"(max-width: 1305px) 100vw, 1305px\" \/><\/figure>\n<\/div>\n\n\n<p><strong>After that, press &#8220;Allow.&#8221;<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"955\" height=\"543\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049.jpg\" alt=\"\" class=\"wp-image-15941\" style=\"width:566px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049.jpg 955w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049-300x171.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049-768x437.jpg 768w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/figure>\n<\/div>\n\n\n\n<\/div><\/details>\n<\/div>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\">Conclusion<\/h2>\n\n\n\n<p><strong>Script to redisplay hidden sheets in bulk<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-50\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"function showAllSheets() {\n  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();  \/\/ Get the currently open spreadsheet\n  var sheets = spreadsheet.getSheets();  \/\/ Get the list of sheets\n  \n  \/\/ Check all sheets\n  for (var i = 0; i &lt; sheets.length; i++) {\n    var sheet = sheets[i];\n    if (sheet.isSheetHidden()) {  \/\/ If the sheet is hidden\n      sheet.showSheet();  \/\/ Unhide the sheet\n    }\n  }\n}\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">showAllSheets<\/span><span style=\"color: #F8F8F2\">() {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> spreadsheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> SpreadsheetApp.<\/span><span style=\"color: #A6E22E\">getActiveSpreadsheet<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Get the currently open spreadsheet<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheets <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> spreadsheet.<\/span><span style=\"color: #A6E22E\">getSheets<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Get the list of sheets<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #88846F\">\/\/ Check all sheets<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #F92672\">for<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> i <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">; i <\/span><span style=\"color: #F92672\">&lt;<\/span><span style=\"color: #F8F8F2\"> sheets.length; i<\/span><span style=\"color: #F92672\">++<\/span><span style=\"color: #F8F8F2\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> sheets[i];<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (sheet.<\/span><span style=\"color: #A6E22E\">isSheetHidden<\/span><span style=\"color: #F8F8F2\">()) {  <\/span><span style=\"color: #88846F\">\/\/ If the sheet is hidden<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      sheet.<\/span><span style=\"color: #A6E22E\">showSheet<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Unhide the sheet<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong><strong><strong>Script to delete all hidden sheets in bulk<\/strong><\/strong><\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-50\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"function deleteHiddenSheets() {\n  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();  \/\/ Get the currently open spreadsheet\n  var sheets = spreadsheet.getSheets();  \/\/ Get the list of sheets\n  \n  for (var i = sheets.length - 1; i &gt;= 0; i--) {  \/\/ Loop through all sheets from the last to the first\n    var sheet = sheets[i];\n    if (sheet.isSheetHidden()) {  \/\/ If the sheet is hidden\n      spreadsheet.deleteSheet(sheet);  \/\/ Delete the hidden sheet\n    }\n  }\n}\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">deleteHiddenSheets<\/span><span style=\"color: #F8F8F2\">() {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> spreadsheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> SpreadsheetApp.<\/span><span style=\"color: #A6E22E\">getActiveSpreadsheet<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Get the currently open spreadsheet<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheets <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> spreadsheet.<\/span><span style=\"color: #A6E22E\">getSheets<\/span><span style=\"color: #F8F8F2\">();  <\/span><span style=\"color: #88846F\">\/\/ Get the list of sheets<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #F92672\">for<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> i <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> sheets.length <\/span><span style=\"color: #F92672\">-<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">1<\/span><span style=\"color: #F8F8F2\">; i <\/span><span style=\"color: #F92672\">&gt;=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">; i<\/span><span style=\"color: #F92672\">--<\/span><span style=\"color: #F8F8F2\">) {  <\/span><span style=\"color: #88846F\">\/\/ Loop through all sheets from the last to the first<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #66D9EF; font-style: italic\">var<\/span><span style=\"color: #F8F8F2\"> sheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> sheets[i];<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (sheet.<\/span><span style=\"color: #A6E22E\">isSheetHidden<\/span><span style=\"color: #F8F8F2\">()) {  <\/span><span style=\"color: #88846F\">\/\/ If the sheet is hidden<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      spreadsheet.<\/span><span style=\"color: #A6E22E\">deleteSheet<\/span><span style=\"color: #F8F8F2\">(sheet);  <\/span><span style=\"color: #88846F\">\/\/ Delete the hidden sheet<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>The script introduced here is useful when you have a large number of hidden sheets.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">Save time by letting Google Apps Script take care of the tedious work.<\/p>\n\n\n<div class=\"p-postListWrap\"><ul class=\"p-postList -type-card -pc-col3 -sp-col1\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/duplicate-data-extraction\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/f713dfc6aeb4da01bcd388842c732c69-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/f713dfc6aeb4da01bcd388842c732c69-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/f713dfc6aeb4da01bcd388842c732c69-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/f713dfc6aeb4da01bcd388842c732c69-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/f713dfc6aeb4da01bcd388842c732c69.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">How to Identify Duplicate Data in Google Sheets: Using Functions and Conditional Formatting<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-03\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u67083\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/googlesheets-xmatch\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/513f3a0811e53a7de868b7f72fa4eb1d-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/513f3a0811e53a7de868b7f72fa4eb1d-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/513f3a0811e53a7de868b7f72fa4eb1d-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/513f3a0811e53a7de868b7f72fa4eb1d-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/513f3a0811e53a7de868b7f72fa4eb1d.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">An Overview and How to Use the XMATCH Function in Google Sheets<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-18\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u670818\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/gas-pop-up\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/f7db322d686e3090883637bf91b1d3ac.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">Enhance User Interaction with Google Apps Script: How to Add Confirmation Pop-Ups to Prevent Mistakes<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-12-31\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7412\u670831\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<p class=\"is-style-emboss_box has-swl-pale-02-background-color has-background\">Our company offers support for improving work efficiency through the use of Google Apps Script. <br>If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us. <br>We are fully committed to supporting your business improvements.<br><br><a href=\"https:\/\/84office.jp\/contact\/\">Contact us here<br><\/a><\/p>\n\n\n\n<script src=\"https:\/\/codoc.jp\/js\/cms.js\" data-css=\"rainbow\" data-usercode=\"pQLZofrBiA\" charset=\"UTF-8\" defer><\/script>\n <div id=\"codoc-entry-9lNr9PuMXQ\" class=\"codoc-entries\" data-without-body=\"1\" data-support-button-text=\"Support with a Tip\" data-support-message=\"We will keep offering tools and information to boost work efficiency. Your support helps us provide even better content.\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In managing weekly reports and other data in Google Sheets, do you find that the number of hidden sheets keeps [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":16184,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=14637","footnotes":""},"categories":[12,8],"tags":[],"class_list":["post-16179","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","category-8","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=16179"}],"version-history":[{"count":4,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16179\/revisions"}],"predecessor-version":[{"id":16197,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16179\/revisions\/16197"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/16184"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=16179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=16179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=16179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}