How to Create and Modify Cell Styles in Excel
If you find that you keep applying the same formatting over and over, create a style with that formatting so you can apply those formatting settings with one click.
The easiest way to create a style is to do so from a cell that already has the formatting you want to capture.
The Style dialog box opens and the formatting from the selected cell is captured.
The style is now saved and can be used in any Excel worksheet.
Cell styles are associated with the theme that is being used for the workbook. If you switch to a new theme, the cell styles will update to match it.
If you decide you need to change an existing style, you can easily make modifications. Any updates you make will automatically be reflected in any cells that have the style applied.
To duplicate a style before making changes, select Duplicate from the menu instead.
The style is updated and any cells with the style applied are automatically updated.
To remove a cell style from all cells and delete the cell style itself, click the Cell Styles button on the Home tab. Then right-click the style and select Delete.
Free to distribute with our compliments; we hope you will consider our paid training.