How To Create Custom Style in Excel | Excel Tutorial in Hindi - 14
You can create a Style to apply several formats at once to many cells or ranges.
Sometimes you need to apply same format groups to many cells or ranges. In this case you can create a Style and put all required formats into it. When you apply a particular Style then all the formats of Style will applied to selected range at once. So, you can save your time which you spend in formatting.
There are two types of Styles -
1. Predefined
These are provided by excel. You don't need to create it. You can apply these styles by just clicking on it. You can also modify these predefined styles as per your requirements.
2. Custom Styles -
If your requirements do not fulfill by predefined styles then you can create your own Styles. These are called Custom Styles. You can choose different formats in your custom style.
What is Merge Styles -
You can import Custom Styles from different files. So, you don't need to create same styles again. You can do it by using Merge Styles option from Style section of Home tab (Ribbon).
Previous video - • How to convert a Range into a Table |...
(How to convert a Range into a Table | Table Formatting)
Watch video How To Create Custom Style in Excel | Excel Tutorial in Hindi - 14 online without registration, duration hours minute second in high quality. This video was added by user Excel & VBA Expert Online 21 November 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 61 once and liked it 3 people.