Spreadsheet Styling Rules
Please follow all Guidelines listed here
To create good looking and easy to work with Templates for users, we would like You to follow all steps mentioned here. This Section is devoted on the look of the Spreadsheet. It covers visual, naming and other convetions which we should maintain.
#01 Use ready Template
Duplicate an existing Template, for example the Blank Template Spreadsheet as an start for creating Your own Template. Check out our Templates here.
#02 Name Your Spreadsheet
Following this nameing convention for your templates: $Templatename @Nor

  • $ - Short for the money You will be making!
  • @Nor - The first 3 letters of your name.
  • Templatename - This I will provide you with.
#03 Sheets Naming
Each sheet within your spreadsheet should be starting with an capital letter and have no spaces. In addition to this...

  • The home page should always be called Home
  • Any form result tabs should be called Form
  • You should take care to name sheets in English and in a logical manner.
  • Color Sheets

    • Main sheet should be green
    • Table sheets should be blue
    • Form sheet should be violet
    • You can use more colors if making sense, for example for grouping of sections

  • You should create new tabs to store big tables – check out Products from $Farmer Shop Template to see an example! Here are a couple of sample names that you might use:

    • Team
    • Products
    • Conference
    • Contacts
    • Events
#04 Sheet Order
  1. Keep same order of sheets as You would link them in Your Menu.
  2. Prodcuts, Table & Data Sheets should be next.
  3. The Form recieving Sheet should be always last.
#05 Column Headers Naming
If you create new columns, you should use unique, logical titles for each. Here are some example column names you want to use:

  • Title
  • Subtitle
  • Description
  • Type ( with Combo Box )
  • Link ( with link, websheet link or absolute link https://.. )
  • Link Text
  • Button Text
  • Button Link ( same as Link )
  • Image Url ( with FORMULATEXT() or IMAGE() )
  • Image Description
  • Date
  • Price
  • Show ( with checkbox )
  • Hide ( with checkbox )
#06 Table Header
Vertical and horizontal table headers should always be in bold.
#07 Named Ranges
When creating Named Ranges, remember that new ranges should always be names with the prefix Ws_ Here are some examples you may wish to use:
  • Ws_Team
  • Ws_Products
  • Ws_Conference
  • Ws_Contacts
  • Ws_Events
#08 Use Checkboxes
Make full use of spreadsheet checkboxes to bring a new level of customization to your site! Find out more about this here
#09 Use Comboboxes
You can make use of comboboxes within your tables to make it easier for your users to select specific items.

Find out more about this here.
#10 Use Filters in Tables
Whenever you add a table, think about whether or not a user might want to make use of any filters at all – and add these beforehand to give them a smooth experience!
#11 Add Informative Notes
Add instructions and suggestions! Give your users more information on how to use your template, e.g. add the note into specific cell. Add when possible * symbol to mark that given cell contains an note. Read more on how to do that here.
#12 Column and Row Height and Width
When setting Rows and Cols Sizes, You should remember that the user should with ease change row order and navigate in the sheet, this may be hard if those size are too big. Still if we have cells with images(min 100px) we should set an size which allows to view them in an good manner. Please use the following sizes for your columns and rows: Sizes [px]:
  • 21( Height )
  • 60(  Formula Row , Height )
  • 100( Image Cell, Height )
  • 200
  • 300
  • 350( Formula Column Width )
#13 Groups
You can also make groups to help make your sheet look more appealing for anyone who wishes to use it!
#14 Add Sections
Create sections with clear instructions for your users on how exactly they should fill out the sheet to generate a site as they would like. Just make sure to separate your sections with 10px columns and rows as needed to keep everything formatted well.
#15 Fill Colors and Fonts
You should style your spreadsheet in a similar way to as has been done in the blank template sheet.
#16 Default Theme
All texts should be set to Roboto as a default, Link color into "dark cornerflower blue 2". To change create an custom theme, check out this link. to learn how to set an custom Theme.
#17 Spreadsheet Zoom
The Spreadsheet Default Zoom should be changed into 110%. Check out this link. to learn how to set an custom Zoom value.
#18 Cell Text Alignment
Texts should always be left and down-aligned.
#19 Cell Text Font
All texts dont should be set to Roboto as a default.
#20 Cell Text Size
All text should normally be 10px.
#21 Cell Text Wrapping
You should always format text with wrapping on.
#22 Unnecessary Named Ranges
Named Ranges may occasionally be copied over when you duplicate sheets. Double check to ensure that all Named Ranges present are needed, and remove any that aren't.
#23 Unnecessary Columns and Rows
Take a moment to remove any extra columns and rows that aren't needed. Across all sheets and tabs, still You should keep Your row count an multiply of 5. For example 10, 15, 20, 25, 30 and so on. For Page Sheets do in addition same for Block Formula Counters, pleas review $Websheet Guide > Home sheet as example.
What can I do next?
The sky's the limit!

I am always open to collaboration to create more advanced spreadsheets. It's also possible to combine with other plug-ins such as Zapier and Glide – and many others!

You can make use of advanced spreadsheet formulas to import dynamic data as well – stock prices and RSS feeds, for example. You can also use Google Forms, Google Charts, and our own Form Blocks to import even more data into your sheets and incorporated into your templates
Websheet'smissionis to help you easily create the website of your dreams. Explore the thousands of possibilities.