How to convert a Range into a Table | Table Formatting | Excel Tutorial in Hindi - 13

Published: 19 November 2020
on channel: Excel & VBA Expert Online
23
1

Convert your Range into a Table and apply various Table Formatting to make it attractive.

When you convert the Range into a Table then you can apply Table Formatting to your Table. As well as you can apply many functions which are related to a table. There are lot of benefits of using table in excel. For example, you can use predefined table styles and save your time, you can create your own table style, auto filter is automatically applied to a table, functions are automatically inserted in the last row and you can select different types of functions etc.

Excel does not recognize a range as a table. However, the data structure of range and table is same. That is why you need to convert the range into a table to use functionalities of table.

If you watch this video you will be expert to work with the table.

Previous video -    • Conditional Formatting in Excel | Exc...  
(Conditional Formatting in Excel)


Watch video How to convert a Range into a Table | Table Formatting | Excel Tutorial in Hindi - 13 online without registration, duration hours minute second in high quality. This video was added by user Excel & VBA Expert Online 19 November 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 23 once and liked it 1 people.