Is there any shortcut key to merge cells in MS Excel 2007?
Yes, there is a Shortcut key to make your office much easier to work. You can’t split an individual cell, but you can make it appear as if a cell has been split by merging the cells above it. Generally we will select the cells which needs to be merged and click “Merge & Center” option.
It’s a waste of time each time selecting the cells and clicking on “Merge & Center” option. Instead we can use a Shortcut key feature 😉 Just do the following things in MS Excel,
- Just select the cells
- Press Alt + Enter key
- Now the cells will be merged 🙂
3 Most Wanted MS Office Tips
- How To Enable No Subject Warning In Microsoft Outlook 2007
- How to Enable or Disable Cell Drag and Drop Editing Option in Ms Excel?
- How To Edit MS Access Database(MDB File Format) Without Having MS Access?
See the below example I merged the cells in MS Excel 2007,
Though this is a simple post, I think this simple tip will make your work much easier in MS Excel:)
Things happen and we don’t know how to do simple things in fact. Thank you so much!
trick is not working pls input a solution for merge cell shotcut
Its working. Pls recheck again
If its working WHY to recheck……???
In Excel 2010 (and maybe other versions), you can’t just simply do Alt + Enter. That shortcut repeats the last action you, e.g. you pasted text, Alt+Enter will paste that exact text again.
So…go up to the HOME toolbar and find the merge option you want. Do that as your first action. Afterwards, you can simply hit Alt+Enter for the remaining cells.
THANK YOU SOOO Much for the shortcut! You saved a lot of my time! 😀
Shortcut for merge and venter is:
Alt + H + M + C
Then you may use Alt + Enter for repeating action or continue to use the above shortcut!
This is what I was looking for!!!!!! 🙂
This shortcut works only in column
A) manually marge 3, 4 cells and marge it
B) on the same column select other 3, 4 cells, press F4 than space bar
C) selected cells are marged