Search : in
By :

Short cut to merge cells

Last answer on Nov 14, 2009 3:15:20 pm GMT rossdavid, on Jul 10, 2009 7:05:49 pm BST 
 Report this message to moderators

Hello,

If there a short cut on the key board to merge cells in excel?

Configuration: Windows XP
Firefox 3.5

Best answers for « Short cut to merge cells » in :
Creating Shortcut key to merge cells Show Creating Shortcut key to merge cells Issue Solution Note Issue If there a shortcut to be pressed on the keyboard to merge cells in excel? I was trying to find a code or any macro which will allow me to do this! Thanks for your...
How do I find Word's keyboard shortcuts? ShowHow do I find Word's keyboard shortcuts? To deal with shotcuts you have several possibilities. 1- Some keyboard shortcuts are listed next to the items in the main menu (just open menu list and check out). 2- You can also find...
Create a shortcut to activate or deactivate the screen saver ShowCreate a shortcut to activate or deactivate the screen saver The screensaver may sometimes disrupt or halt certain applications on your computer, such as burning a CD, viewing a video, etc.. To avoid a manual activation or deactivation...
Using Safari in full screen ShowUsing Safari in full screen A small tip allowing you to use Safari in full screen, for a better browsing experience. The shortcut is as follows: apple + Enter for the apple macbook is the key cmd + Enter
Download Shortcut Key Explorer ShowOn any Windows user wants to create shortcut keys corresponding to their activities. But by dint of creating keystroke on eventually become confused and completely forget the shortcuts to be set by itself. Shortcut Key Explorer is a program to...
Download PDF SaM (Split and Merge) ShowPDFsam is a tool to merge and cut PDF files. It is an open source application to treat PDF files. It requires Virtual Java machine 1.4.2 or superior version. With a simple and intuitive interface, you can: - split documents PDF into chapters, into...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...

1

Excelguru, on Jul 12, 2009 5:38:27 am BST
  • +1

Hello Rossdavid

Make a macro with your own shortcut key and with code

sub macroMergeCells()
Selection.MergeCells = True
End sub
Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

Reply to Excelguru

2

Kat Zap, on Nov 14, 2009 12:07:58 am GMT

I know little about excel and I have to merge columns labeled : Name - . - Last Name - @csan.com
into one column so I can create an email group for Outlook 2007.

Is there An easy way for a NOVICE like me to do this? There are 3k rows on this Excel sheet. I use Excel 2007

Thank you so much!!!

Kat

Reply to Kat Zap

3

pro-genius, on Nov 14, 2009 9:20:05 am GMT

There is a short cut for this in the tab menu, it's call merge and center, select the cells you want to merge and just click on it :)

Reply to pro-genius

4

 Kat Zap, on Nov 14, 2009 3:15:20 pm GMT

When I do that only the upper left cell appears?

Reply to Kat Zap