Macabacus and Microsoft (for the most part) no longer support Internet Explorer 10 and prior versions. Please consider upgrading your browser.

Custom Styles

You may already be familiar with Excel's native styles, accessible from the Home tab, that are used to format one or more cell properties (e.g., fonts, colors, number formats). These styles are workbook properties, rather than Excel properties, making them unsuitable for use in organizations where consistency in the appearance of spreadsheets is required.

Macabacus lets you create your own styles that combine multiple cell formatting properties, similar to native styles. Unlike native styles, however, Macabacus styles are always available in Excel, regardless of the workbook you have open, and can be applied using keyboard shortcuts. Macabacus styles include all of the important formatting possibilities of native Excel styles, and allow you to additionally specify:

  • Cell width and/or height;
  • Text case (e.g., sentence, title, upper, or lower case);
  • A default cell value;
  • A default cell comment.

Macabacus styles are added to one of eight Custom Style Cycles. For example, you might name one of these cycles "Header Cycle" and populate it with frequently used table header formats. Your Custom Style Cycles appear on the Macabacus > Format menu, and can be triggered using a keyboard shortcut.

Custom Style Cycles can be managed on the Styles tab of the Application Settings dialog, accessed from the Macabacus > Settings menu. Here, you can create new styles from scratch, capture the formatting of the selected cell in a new style, or create a new style using an existing Macabacus style or native Excel style as a starting point. You can also edit existing styles, reorder styles within cycles, add or remove styles from cycles.

When ordering the custom styles in a cycle, consideration should be given to each style's expected frequency of use and the number of formatting properties that each style modifies. In general, styles that are used more frequently should appear early in the cycle and styles used less frequently should appear later in the cycle to reduce the number of shortcut keystrokes required to apply styles, on average. In addition, you should generally arrange styles that modify fewer cell formatting properties early in the cycle and those that modify more formatting properties later in the cycle.

Custom Style Cycle 1-8

Cycle through customizable cell styles.

Ctrl
Shift
1-8

This documentation refers to Macabacus version 8.8.11, and may differ from the PDF documentation
on your computer that installed with your version of Macabacus.