How to center a headings Ms excel?

Asked By Alicia Gracee 30 points N/A Posted on - 08/20/2012

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?

• Status: Open
• Question Views: 2212
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 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.

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.

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

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

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/20/2012
• Question Category: MS Excel