ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shortcut key - merge cells (https://www.excelbanter.com/excel-discussion-misc-queries/159698-shortcut-key-merge-cells.html)

P Anthony

Shortcut key - merge cells
 
Is there a shortcut key to merge cells in excel.

Dave Peterson

Shortcut key - merge cells
 
There's an icon on the formatting toolbar (xl2003, at least).

But no single shortcut key to do this.

ps. You may find that your worksheet looks prettier with the merged cells, but
there are lots of things that fail with merged cells (sorting, copy|pasting,
....).

You may regret it if you use merged cells.

P Anthony wrote:

Is there a shortcut key to merge cells in excel.


--

Dave Peterson

Ross

Shortcut key - merge cells
 
You can also give the appearance of merged cells by:

1.highlighting the desired number of cells
2.FormatCellsHorizontalCenter Across Selection

I was told that that will avoid possible problems.

--
smither fan


"P Anthony" wrote:

Is there a shortcut key to merge cells in excel.



All times are GMT +1. The time now is 12:43 PM.

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