ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Shortcut Key for Merging Cells (https://www.excelbanter.com/excel-worksheet-functions/244766-shortcut-key-merging-cells.html)

Chelle19

Shortcut Key for Merging Cells
 
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!


Mike H

Shortcut Key for Merging Cells
 
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!



Glenn

Shortcut Key for Merging Cells
 
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.

ryguy7272

Shortcut Key for Merging Cells
 
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.


Ashish Mathur[_2_]

Shortcut Key for Merging Cells
 
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!



All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com