Table Formatting Trick: Wrapping Long Table Headers in Hindi

Table formatting in Excel

In this Excel tutorial, we will learn, Table formatting in Excel Many times you need to take a printout or need to create a table and you want to give a heading to the table such as name, place, animal and thing. Many of the time it is being noticed that people have Long table header and they struggle with the length of the text and try to make it short so that it should take a minimum space. If you are using large space for the header then, you need to extend the size of the column. But by extending it, your printout will get divided into two pages.

So, let’s see how we can solve this problem by the amazing Table formatting in Excel where you with the genius expertise of Excel Superstar. In this tutorial, Table Formatting in Excel, our expert will guide you how to wrap a long table header or text in a single cell.

  • Select the cell
  • Click on the home button
  • Click on the “wrap text”

By this cool and simple process, text in a cell will be wrapping up that means the whole thing will get fit into the single cell and automatically text will adjust itself to the size of the cell. Further, if we increase the column height the whole text will be shifted to the bottom of the cell. So, for the alignment again there is a simple step.

  • Select the cell
  • Click on the home button
  • Choose the alignment combination of vertical and horizontal alignment i.e. (Top align, Middle align, Bottom align) and (Left align, Middle align, Right align) respectively.

With these artful steps you can wrap up the text and while taking a print whole matter will be groomed in an A4 size paper – Table Formatting in Excel

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.