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:
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
Leave a Reply