How to merge two or more cells in a Microsoft Excel 2007 sheet?

I have read the Terms & Conditions

Login with:

Already a Member? Sign In

email address

Password

Remember Me

Forgot your password?

New to Ask iYogi
Sign Up!

Enter your OpenID URL

http://

Proceed

Enter your WordPress.com blog URL

http://.wordpress.com

Proceed

I have read the Terms & Conditions

Login with:

Sign Up



E-mail
Password
ReType Password

By clicking on "I Accept. Sign Me Up" button below, you would agree to our Terms & Conditions.

Enter your OpenID URL

http://

Proceed

Enter your WordPress.com blog URL

http://.wordpress.com

Proceed

iYogi, Inc. BBB Business Review

Welcome Guest !
Sign up
|
Sign in

julio-elie

How to merge two or more cells in a Microsoft Excel 2007 sheet?

asked on 20th Sep 2011 | 1 Answers | Answer It!

sajeesh

answered on 20th Sep 2011 | |

You can follow these steps to merge two or more cells in Microsoft Excel 2007:

• Copy the text you want the merged cell to show and paste it in the upper left cell unless it already contains it.
• Select the cells you want to merge (they must be adjacent).
• Click Merge and Center‘ on the ‘Formatting’ toolbar.
• You can align the text to the left or right accordingly.

Here’s to Good Karma

Log in to reply

More Q & A, Solutions and Videos

I am using the trial version of an antivirus on my Windows 7-based laptop. Will this be enough to secure my computer, or a full version of an antivirus is required?

asked on 9th Sep 2011 | 1 Answer

For how many days is the free trial version of Norton 360 valid?

asked on 20th Sep 2011 | 1 Answer

In Microsoft Excel 2007, how can I insert a drop down list in the cells of a column so that a value from that list can be selected?

asked on 1st Sep 2011 | 1 Answer

Whenever I open a document in Microsoft Word 2007, it opens only in safe mode. I can't figure out the reason for this.

asked on 31st Aug 2011 | 1 Answer

I am not able to open .doc files that I get in emails or in my folders. When I try, it pops up the message 'This file does not have a program associated with it for performing this action. Create an association in the Set Associations'. BTW I am able to open Word from programs and access those files from there and I am able to create new word documents. Thanks in advance.

asked on 20th Jul 2011 | 1 Answer

When I type in a document in Microsoft Word 2007, there is time lag as the characters are typed and they appear on the screen. Why is this happening?

asked on 31st Aug 2011 | 1 Answer

My Mcafee total security is not working and I can’t scan my computer now. How can I get it fixed?

asked on 21st Aug 2011 | 1 Answer

How can the mail merge function be used in Microsoft Word 2007?

asked on 5th Sep 2011 | 1 Answer

I am maintaining some blogs on a ‘notepad’ file. Is there a way I can put a password on it?

asked on 1st Aug 2011 | 1 Answer

When I try to sync, add or delete any music file from iTunes I am getting this error "You do not have enough access privileges for this operation. iTunes could save your music library" what is this and why is this coming. I am the administrator of this computer. I am using windows 7 utlimate.

asked on 17th Jun 2011 | 1 Answer

will answer your tech questions for FREE
Here's to Good Karma