Excel Table Formatting Trick for Lengthy Table Headings

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