jQuery(function($){ if ($(‘#wpadminbar’).length > 0) { $(‘.et_pb_section_0_tb_header’).css(‘top’, ’32px’); } });

If you have ever clicked the plus icon to create a new tab and renamed the tab multiple times you know how tedious this can be when using a spreadsheet. I wrote a script that allows you to take a list and create a tab for each item in the list. I previously posted the RosterTab script for Google Sheets. I have updated the script to give you the option to delete the original list.

List to Tabs

The original RosterTab creates and names a tab for each item in column A. I have added ListToTabs to the RosterTab menu. This allows you take your list and create a tab for each item in the list. Since you were utilizing ListToTabs to save time in creating and naming tabs the sheet that contains the list is not needed. After creating the tabs, ListToTabs deletes the first sheet.



To utilize either ListToTabs or RosterTab start with the RosterTab template:


Type or paste a list of names or items in Column A of the first sheet. At the top, next to the Help menu, is the RosterTab menu. Choose ListToTabs to create sheets for each item in the list and to delete the list. Use the RosterTab option to keep the list.


If you would like to have a template on each of the sheets rather than creating blank sheets try out TemplateTab.

Subscribe to the Alice Keeler Newsletter



WP Twitter Auto Publish Powered By : XYZScripts.com