This week’s blog is a quick tip on Grid formatting options. Did you know that XLCubed comes with ten pre-formatted grid styles which you can easily switch between?
These are available from the Workbook Format button on the XLCubed ribbon (the option remains greyed out until an XLCubed grid is added).
Grid styles allow for different fonts and colour schemes in your grids:
You can easily change from one grid style to another. The style also includes formatting for slicers.
Here’s my grid formatted using one of the pre-defined styles:
The XLCubedFormats sheet displays this default grid and slicer style:
You can set any one of these pre-defined formats (or a custom version of your own) as your default style so that all new grids are formatted in this way.
To do that you will need to make changes to your default format sheet. You can check its location by going to Options > XLCubed Options > Workbook Defaults:
You then need to navigate to that Windows folder location, and edit the file. Select the required the grid style from the sheet tabs and copy the whole sheet to the StyleDefault sheet before saving back to the same location.
You could make this grid style your company default so that all users use the same formatting when creating new grids. To do that, follow the same instructions as above before saving and copying the updated file to that same folder location for all users.
You can of course fully customise the content of the StyleDefault sheet to closely match your company standard colour scheme and fonts if needed. To do that simply use Excel formatting to overwrite the existing formats used on the StyleDefault sheet before saving the file to that same location.
Been working with XLCubed for a while now. Small multiple styling is really something needed to add to the stylesheet.
Hi, please check out this link which explains how you can format small multiple series from the format sheet!
Thanks! This is helpfull for the series. Wouldn’t be able to set margins and fonts also by the format sheet?
Hi, this is not possible via the format sheet. If you would like any more help with formatting small multiples check out our help site or email us at support@xlcubed.com. Thanks!