Excel Tips Tutorial: How to Create Your Own New Cell Style in Excel
In Excel you can create your own styles. As mentioned in other tutorials, Excel styles can have up to 6 different attributes, Font, Number Format, Borders, Alignment, Patterns, and Protection. Creating your own style can be very useful and efficient because you will have the option of adding your preferred style to multiple ranges of cells within a workbook simultaneously. This would obviously be much faster than working each cell and each attribute one by one. To create your own style in Excel follow the steps listed below.
Step 1: Activate a cell and add all the different formatting options you want to be included in your new style. Here you can add color fill, font formats, borders etc.
Step 2: Now go to Home, and in the Styles group click on Cell Styles. A drop-down menu will appear showing you a preview off all the pre-formatted cell styles.
Step 3: Click on New Cell Style… which is located at the very bottom of the menu. The style dialog box will appear.
Step 4: In the Style dialog box where it says Style Name, enter the new name of your style and click OK.
Step 5: Now click on the Cell Styles button and in the Custom group of the drop-down menu you will see that your style is now available for you to apply to any range of cells you prefer.
Now if you want to add this cell style you can simply select a range of cells and apply the new cell style. This would obviously be much more efficient than adding each attribute one by one.