Excel Table Formatting Trick for Lengthy Table Headings

In this blog, we will learn about Table Formatting Trick for Lengthy Table Headings in Excel

Example:

Full Excel Course in Hindi

  • Get 2-Year Access with unlimited views of 220+ videos
  • Get Course Completion Certificate & Excel Mastery eBooks

Many people struggle because their Table Header statement is lengthy to present. So how they should present so that it takes less space to get the work completed

So to present the statement and get the work done we will be applying 2 Table Formatting Trick for Lengthy Table Headings in Excel

Trick 1

1. Choose the cell

2. Go to Home Tab

3. Click on Wrap Text

Note – If you decrease the column width then also it will fit into one column, although Wrap Text is kept on

Trick 2

If you increase the column height then you will see the text is lying at the bottom of the column, but you want to align it in middle.

So to align the text in middle all you have to do is:

1. Go to Home Tab

2. Click on the center button to center your text in the column