Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Merging cells

training microsoft excel - Merging cells

ResolvedVersion Standard

Thu 20 Sep 2007, 09:55 Delegate Natascha said...

Natascha has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course

Merging cells

How can I merge two cells together and then unmerge them??
Please?

Tue 25 Sep 2007, 16:29 Edited on Tue 25 Sep 2007, 16:30 Trainer Anthony said...

RE: Merging cells

Hi Natasha. Select the cells you want to merge and then chose Format - Cells - the Alignment tab and tick the merge cells box.

Alternatively use the icon on your formatting toolbar, it looks like an "a" with two arrows on either side. Clicking the icon again (or unticking the merge cells tick box) splits the cells back in two.

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

training microsoft excel - Merging cells

Merging cells

RE: Merging cells

Excel articles

Excel tip:

Use shortcut keys to select rows or columns