Hi All -

In my everyday work life I often have to build plans in an excel sheet and I
need to merge or unmerge cells. Is there a shortcut key to merge and unmerge
cells without having to go to format cell and select the align tab, and then
click or unclick the merge option?

Thanks!

Here's the full list

http://office.microsoft.com/en-us/ex...116591033.aspx

Mike

"Chelle19" wrote:

Hi All -

In my everyday work life I often have to build plans in an excel sheet and I
need to merge or unmerge cells. Is there a shortcut key to merge and unmerge
cells without having to go to format cell and select the align tab, and then
click or unclick the merge option?

Thanks!

Chelle19 wrote:
Hi All -

In my everyday work life I often have to build plans in an excel sheet and I
need to merge or unmerge cells. Is there a shortcut key to merge and unmerge
cells without having to go to format cell and select the align tab, and then
click or unclick the merge option?

Thanks!


You could also just click the "Merge and Center" button on the Formatting toolbar.

Be careful of merging cells. It's not common to see this in practice. I
almost never do this. I'd certainly never do it for people who are not very
Excel savvy because it causes many more problems than it fixes.

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Glenn" wrote:

Chelle19 wrote:
Hi All -

In my everyday work life I often have to build plans in an excel sheet and I
need to merge or unmerge cells. Is there a shortcut key to merge and unmerge
cells without having to go to format cell and select the align tab, and then
click or unclick the merge option?

Thanks!


You could also just click the "Merge and Center" button on the Formatting toolbar.

Hi,

Instead of merging cells across columns, use Format cells Alignment
Horizontal Centre across selection

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Chelle19" <u55271@uwe wrote in message news:9d333b53bb5c9@uwe...
Hi All -

In my everyday work life I often have to build plans in an excel sheet and
I
need to merge or unmerge cells. Is there a shortcut key to merge and
unmerge
cells without having to go to format cell and select the align tab, and
then
click or unclick the merge option?

Thanks!