How to center a headings Ms excel?

Asked By 30 points N/A Posted on -

I prepare financial reports from Microsoft excel. There are many headings in those reports. My problem is it is very difficult to place these headings in the center of the page. Can somebody give me a solution for this?

Answered By 0 points N/A #144370

How to center a headings Ms excel?


At Microsoft excel it is somewhat difficult to center and statement or headings compared to the Microsoft word. However, I will give you a way to center headings in excel. Please refer the following example.

MIcrosoft Word

In the above image we will learn how we can center the heading on the page.

First click on the cell which include the heading and select the next cells on right up to the end of details as follows.

select the cells

Then click on the merge cell icon on the alignment section. (It is in home tab).

merge cells

Now you can see that the heading is centered in the page as follows.

Setting the header

Related Questions