MAKING A NEW SPREADSHEET - Open the Google Sheets document! (You can see which VERSION it is by checking the title; the current version is also preserved on the INSTRUCTIONS sheet for future reference.)
- FILE > Make a copy - You will want one copy for each character you plan to use this code for. - Review the INSTRUCTIONS sheet if necessary. Also available on this sheet: quick-copy HTML that might be useful to you. Feel free to add more snippets. (You can then RIGHT-CLICK the INSTRUCTIONS SHEET and choose "Hide Sheet" to hide it.) - From the SETTINGS sheet, set up your sections and pick your colors. These can be in any order. You can also add or remove sections. - Fill out the section sheets that you plan to use. You can ignore the others, or right-click on them and choose "Hide Sheet" to get them out of your way!
NOTE: You can create line-breaks in any Google Sheets cell by hitting CTRL/CMD+ENTER.
COPYING YOUR DATA TO A NEW VERSION - You can absolutely copy-paste data from old versions of my spreadsheet to new copies! Click on a column (e.g., "A" at the very top of the Section column on the LIST sheet), hit CTRL/CMD+C, and switch tabs to your fresh copy of my updated spreadsheet. Highlight the "A" column there, then hit CTRL/CMD+V. - Take more care when copy-pasting columns with formulas involved, like the alignment columns. - Everything on the SETTINGS sheet, it would probably be safer to manually copy over instead.
USAGE
- Open the Google Sheets document! (You can see which VERSION it is by checking the title; the current version is also preserved on the INSTRUCTIONS sheet for future reference.)
- FILE > Make a copy
- You will want one copy for each character you plan to use this code for.
- Review the INSTRUCTIONS sheet if necessary. Also available on this sheet: quick-copy HTML that might be useful to you. Feel free to add more snippets. (You can then RIGHT-CLICK the INSTRUCTIONS SHEET and choose "Hide Sheet" to hide it.)
- From the SETTINGS sheet, set up your sections and pick your colors. These can be in any order. You can also add or remove sections.
- Fill out the section sheets that you plan to use. You can ignore the others, or right-click on them and choose "Hide Sheet" to get them out of your way!
NOTE: You can create line-breaks in any Google Sheets cell by hitting CTRL/CMD+ENTER.
COPYING YOUR DATA TO A NEW VERSION
- You can absolutely copy-paste data from old versions of my spreadsheet to new copies! Click on a column (e.g., "A" at the very top of the Section column on the LIST sheet), hit CTRL/CMD+C, and switch tabs to your fresh copy of my updated spreadsheet. Highlight the "A" column there, then hit CTRL/CMD+V.
- Take more care when copy-pasting columns with formulas involved, like the alignment columns.
- Everything on the SETTINGS sheet, it would probably be safer to manually copy over instead.