Centering a title over several columns in Microsoft Excel


When you start creating a worksheet you may not be sure how many columns you are going to use, so may just type a title or heading in row 1; once you have got your data into the worksheet, you may well decide that it would look better if your title was centred across the columns containing the main portion of your data.

To achieve this, in whichever version of Excel you are using, click in the first cell of the columns that you want to have text centred in, then drag with the mouse until you reach the last cell. Release the mouse.

If using Excel 2003 or earlier, now click the Merge and Center  button on the Formatting toolbar. Your text will be centred across the columns.

If using Excel 2007, Excel 2010 or Microsoft Excel 2013, from the Home tab, in the Alignment group, click the

View original post 30 more words

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s