🎓
Models University
  • Alpha Testing
    • 👋Welcome to Alpha
    • Installation and Setup
    • Support and Help
    • Terms and Licence
  • Start Here
    • What is Models?
    • Quick start
    • Tutorials
  • Using Taglo Software
    • The Taglo Interface
      • Navigating in Models
      • List Views
      • Adding Items
      • Deleting Items
      • Searching and Filtering
      • Previewing and Editing
      • Using Wizards
      • Save/Undo/Redo
      • Keyboard Shortcuts
    • Data Storage
    • Namespaces
    • Inbuilt data
  • Tags
    • Introduction to Tags
    • Tag Basics
    • Tags Applet
    • Advanced Tags
  • Models
    • Home Tab
      • Creating a Model
        • Timings
      • Version History
      • Application Settings
    • Model Editor
  • Variables
    • Variable Basics
      • Variable Setup
      • Unit and Calculations
    • Time Segments
      • Time Segment Setup
    • Summaries
    • Default Assumptions
  • Units
    • Introduction to Units
    • Key Unit Concepts
    • Advanced Units
    • Defining a Unit
    • Unit Factors
  • Dimensions
    • Introduction to Dimensions
    • Dimension Setup
    • Defining Unit Variance by Dimension
  • Data Types
    • Data Types
  • Assumptions
    • Introduction to Assumptions
    • Creating/Referencing Assumptions
    • Assumptions Wizard
      • Assumption Dates Step
      • Assumption Values Step
      • Linking to external Data
      • Linking to Excel Inserts
      • Sensitivity Values
  • Calculations
    • Introduction to Calculations
    • The Calculation Page
      • The Formula Entry Bar
      • Unit Analysis
    • Calculation Parts
      • Variable References
        • Referencing Time
        • Referencing Dimensions
        • Lookups
        • Summarising Variables
      • Period References
      • Functions
        • Advanced Functions
  • Aggregation
    • Introduction to Aggregation
    • Creating Aggregations
  • Rearranging
    • Introduction to Rearranging
    • Rearranging Example
    • Rearranging Tips
  • Cases
    • Introduction to Cases
    • Managing Scenarios
    • Managing Sensitivities
  • Layout
    • Generating Excel
    • Auto Layout
    • Sheets
      • Sheet Content
      • Adding and Editing Content
    • Excel Formatting
      • Excel Themes and Styles
      • Line Formatting
    • Data Tables
    • Excel Generation Troubleshooting
  • Excel Inserts and Outputs
    • Excel Inserts
    • Excel Outputs
  • Number Formats
    • Number Formats
  • Dashboards
    • Dashboards Basics
    • Dashboard Layout
    • Dashboard Items
    • Excel Dashboards
  • Metrics
    • Metrics
  • Charts
    • Introduction to Charts
    • Chart Customisation
  • Importing Models
    • Importing Models
  • Data
    • Introduction to Data
    • Creating Data
    • Data Sources
Powered by GitBook
On this page
  • Themes
  • Default and Model Themes
  • Excel Theme Files
  • Styles
  1. Layout
  2. Excel Formatting

Excel Themes and Styles

How to style your Excel outputs

Themes

In Models, you can set a specific theme for any Model, or use a default theme, set in the Application Settings.

You can create as many themes as you like. Each Theme comprises:

  1. An Excel Theme File, which sets the color scheme for your Model

  2. A set of Styles, which instructs Models how it should format different types of cell in your Excel output

You can create and edit Themes in the Themes applet, accessible from the Navigation Bar, or from any Themes picker.

Default and Model Themes

You can set the Theme for a Model in two ways:

  1. Use the Default theme for all Models

  2. Set a specific theme for an individual Model

Default themes are set by navigating to Edit > Edit settings, and selecting/creating a Theme in the Default Theme page of the wizard. This Theme will automatically be applied to any new Models.

To set a specific theme for a Model, in the Model Editor, open the Model settings bar, and click Edit in the Model settings section. This will open a wizard in which you can set the Theme to be used in the Model.

Excel Theme Files

To generate spreadsheets, Models must have access to an Excel color scheme file (.xml extension). Models comes installed with a default Theme File, but you can change to a color scheme of your choosing at any time.

When you create a new Theme File item, you will be asked to select a .xml color scheme file from your computer, which Models will copy to your data folder locally.

Creating a .xml color scheme

There are several ways of creating one of these files, including from within Excel, Word or PowerPoint. Below are the steps to create a scheme from Excel (modern versions).

Exporting a color scheme from Excel

  • Open any spreadsheet in Excel

  • Navigate to Page Layout > Colors

  • Click on Customize Colors... at bottom of list

  • Use the dialog box to edit your color scheme, enter a Name for it, and click Save

  • Your color scheme will be saved as [Name].xml in C:\Users\[Your User Name]\AppData\Roaming\Microsoft\Templates\Document Themes\Theme Colors

Styles

Styles allow you to select formatting options for certain types of cell in the Excel output that Models produces, such as headings, input cells and calculation cells.

The Themes wizard shows you how each type of cell is currently formatted, and allows you to choose a color and font style.

PreviousExcel FormattingNextLine Formatting

Last updated 10 months ago