Excel Tip: Set up the format templates for cells

You have the option of assigning multiple formats to selected cells at once with Excel’s cell format templates. These formats include font, number format, background, text color, border, and orientation. This gives you a professional and consistent formatting. You first select the cells to which you want to assign a format template.


Then, on the Start tab, click the Cell Style Templates icon in the Format Templates group. The format templates are displayed. Touching with the mouse pointer displays a preview of how the result would look. Once you have found a template and click on it, the formatting for the selected area will be applied.