If the Format as Table option formats the entire data and does not suits your requirement to only format the heading row leaving the data intact, follow these steps to quickly format only the heading rows.
E.g. this is your data
Select the heading row and click on the Cell Styles drop down (available on Styles group of the Home tab).
Now select the format which looks presentable to you.
And that is it!!!
E.g. this is your data
Select the heading row and click on the Cell Styles drop down (available on Styles group of the Home tab).
Now select the format which looks presentable to you.
And that is it!!!
