{"id":15893,"date":"2024-11-14T01:31:35","date_gmt":"2024-11-13T16:31:35","guid":{"rendered":"https:\/\/84office.jp\/?p=15893"},"modified":"2024-11-15T01:54:33","modified_gmt":"2024-11-14T16:54:33","slug":"spreadsheet-tab-move","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/spreadsheet-tab-move\/","title":{"rendered":"Enhance Productivity with Google Apps Script: Instantly Rearrange Google Sheets Tabs Right to Left"},"content":{"rendered":"
<\/div>\n\n\n\n\n
<\/path><\/path><\/svg>Recommended for:<\/span><\/div>
\n

For those considering improving googlesheets efficiency<\/strong>.<\/p>\n\n\n\n

Those with many sheet tabs in one file.<\/strong><\/p>\n<\/div><\/div>\n\n\n\n

Google Sheets is a very convenient tool, but a troublesome aspect is moving sheet tabs. <\/p>\n\n\n\n

When there are many tabs, the basic method of moving them one by one can be time-consuming, especially when you want to move a tab from the far right to the far left. In such cases, you can use Google Apps Script to move them all at once. <\/p>\n\n\n\n

If you need to repeatedly move sheet tabs to the far left, using Google Apps Script can make the process easier.<\/p>\n\n\n\n

The script to move the selected sheet tab to the far left<\/h2>\n\n\n\n
<\/code><\/pre>\n\n\n\n
<\/path><\/path><\/svg><\/span>
\/\/ Move the selected sheet tab to the far left<\/span><\/span>\nfunction<\/span> <\/span>moveActiveSheetToLeft<\/span>() {<\/span><\/span>\n  <\/span>var<\/span> spreadsheet <\/span>=<\/span> SpreadsheetApp.<\/span>getActiveSpreadsheet<\/span>();<\/span><\/span>\n  <\/span>var<\/span> activeSheet <\/span>=<\/span> spreadsheet.<\/span>getActiveSheet<\/span>();<\/span><\/span>\n  spreadsheet.<\/span>moveActiveSheet<\/span>(<\/span>1<\/span>);<\/span><\/span>\n}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Here is the script to move the selected sheet tab to the far left.<\/p>\n\n\n\n
You can easily copy the script by clicking the copy icon in the top right corner of the code block.<\/p>\n\n\n\n
You can copy and use the script as it is.<\/p>\n\n\n\n
The number in the fourth line of ‘moveActiveSheet(1)’ determines to which position the sheet will be moved. For example, if you want to move the sheet to the third position, change it to (3).<\/p>\n\n\n\n
Script to move the selected sheet tab to the far right<\/h2>\n\n\n\n
<\/path><\/path><\/svg><\/span>
\/\/ Move the selected sheet tab to the far right<\/span><\/span>\nfunction<\/span> <\/span>moveActiveSheetToRight<\/span>() {<\/span><\/span>\n  <\/span>var<\/span> spreadsheet <\/span>=<\/span> SpreadsheetApp.<\/span>getActiveSpreadsheet<\/span>();<\/span><\/span>\n  <\/span>var<\/span> totalSheets <\/span>=<\/span> spreadsheet.<\/span>getNumSheets<\/span>();<\/span><\/span>\n  <\/span>var<\/span> activeSheet <\/span>=<\/span> spreadsheet.<\/span>getActiveSheet<\/span>();<\/span><\/span>\n  spreadsheet.<\/span>moveActiveSheet<\/span>(totalSheets);<\/span><\/span>\n}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Here’s the script for moving the selected sheet to the far right, opposite to what we did earlier. <\/p>\n\n\n\n
You can copy and use it as is.<\/p>\n\n\n\n
How to Use the Script<\/h2>\n\n\n\n
\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u4f7f\u7528\u65b9\u6cd5<\/span><\/div>
\n
    \n
  1. Toolbar – Extensions – Apps Script<\/li>\n\n\n\n
  2. Paste the script<\/li>\n\n\n\n
  3. Save the script<\/li>\n\n\n\n
  4. Run<\/li>\n\n\n\n
  5. The selected sheet tab moves to the left (right).<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n
    \n
    STEP<\/span><\/div>
    Select ‘Extensions – Apps Script’ from the toolbar.<\/strong><\/div>
    \n
    \"\"<\/a><\/figure>\n<\/div>\n\n\n
    Open the spreadsheet, then click on “Extensions<\/strong>” in the toolbar and select “Apps Script<\/strong>.”<\/p>\n<\/div><\/div>\n\n\n\n
    STEP<\/span><\/div>
    Paste the script.<\/strong><\/div>
    \n
    \"\"<\/figure>\n<\/div>\n\n\n
    Since `function myFunction(){}` is already there at the beginning, delete it and paste the above script.<\/p>\n<\/div><\/div>\n\n\n\n
    STEP<\/span><\/div>
    Press “Save Project”<\/strong><\/div>
    \n
    \"\"<\/a><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
    STEP<\/span><\/div>
    Press “Run.”<\/strong><\/div>
    \n
    \"\"<\/a><\/figure>\n<\/div>\n\n\n
    \n
    If you’re running the script for the first time, you need to authorize it. <\/p>\n\n\n\n
    Therefore, press “Review Permissions.<\/strong>“<\/p>\n\n\n
    \n
    \"\"<\/figure>\n<\/div>\n\n\n
    Next, press “Advanced.”<\/strong><\/p>\n\n\n
    \n
    \"\"<\/figure>\n<\/div>\n\n\n
    Press “Go to Untitled project (Unsafe).”<\/strong><\/p>\n\n\n
    \n
    \"\"<\/figure>\n<\/div>\n\n\n
    After that, press “Allow.”<\/strong><\/p>\n\n\n
    \n
    \"\"<\/figure>\n<\/div>\n\n\n\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n
    STEP<\/span><\/div>
    When executed, the selected sheet tab moves to the far left.<\/strong><\/div>
    \n
    \"\"<\/figure>\n<\/div>\n\n\n
    In the image above, “Sheet 5” has moved to the far left.<\/p>\n\n\n\n
    If there are only a few sheets, you can move them easily without using Apps Script, but when there are many, using Apps Script can save you time.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n
    Basic Method for Moving Sheet Tabs (Without Using Google Apps Script)<\/h2>\n\n\n\n
    Drag & Drop
    Right-click Menu<\/strong><\/p>\n\n\n\n
    \n
    Drag & Drop<\/strong><\/strong><\/dt>\n\n\n\n
    \n
      \n
    1. Hover the cursor over the sheet tab you want to move.<\/li>\n\n\n\n
    2. Click and hold the sheet tab with the mouse.<\/li>\n\n\n\n
    3. Drag the sheet tab all the way to the left.<\/li>\n\n\n\n
    4. Release the sheet tab.<\/li>\n<\/ol>\n<\/dd>\n\n\n\n
      Right-click Menu<\/strong><\/dt>\n\n\n\n
      \n
        \n
      1. Right-click on the sheet tab you want to move.<\/li>\n\n\n\n
      2. Select “Move left” from the menu that appears.<\/li>\n<\/ol>\n\n\n\n
          \n
        1. <\/li>\n<\/ol>\n<\/dd>\n<\/dl>\n\n\n\n
          When there are only a few sheet tabs, using drag and drop is an easy way to move them.<\/p>\n\n\n\n
          Summary<\/h2>\n\n\n\n