You can apply changes to the format of an entire spreadsheet with themes.

  1. Open a spreadsheet in Google Sheets.
  2. At the top, click Format  Theme.
  3. Choose an available theme or click Customize to create your own.


  • If you create a custom theme, the most recent version will be saved.
  • Colors from your current theme are available in the text and fill color pickers.
Community content is available under CC-BY-SA unless otherwise noted.