Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
Hi
I am using Excel 2000 SP3 is there a shortcut for mrerging cells in a column? thanks Daniel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
Select the cells to merge and then hit the Merge and Center icon on the
formatting toolbar. (Then hit the justification icon to make it the way you want.) Daniel - Sydney wrote: Hi I am using Excel 2000 SP3 is there a shortcut for mrerging cells in a column? thanks Daniel -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
Thanks for your help,
I was hoping there was a Keyboard Shortcut. obvioulsy not Daniel "Dave Peterson" wrote: Select the cells to merge and then hit the Merge and Center icon on the formatting toolbar. (Then hit the justification icon to make it the way you want.) Daniel - Sydney wrote: Hi I am using Excel 2000 SP3 is there a shortcut for mrerging cells in a column? thanks Daniel -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
Once you do it, you can use F4 to repeat the last action (don't do anything
important in between). Daniel - Sydney wrote: Thanks for your help, I was hoping there was a Keyboard Shortcut. obvioulsy not Daniel "Dave Peterson" wrote: Select the cells to merge and then hit the Merge and Center icon on the formatting toolbar. (Then hit the justification icon to make it the way you want.) Daniel - Sydney wrote: Hi I am using Excel 2000 SP3 is there a shortcut for mrerging cells in a column? thanks Daniel -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
ps.
If you wanted to merge (row by row) say A1:G99, you can add an icon to a toolbar. Tools|Customize|Commands tab|format category look for Merge Across and drag it to your favorite toolbar. Daniel - Sydney wrote: Thanks for your help, I was hoping there was a Keyboard Shortcut. obvioulsy not Daniel "Dave Peterson" wrote: Select the cells to merge and then hit the Merge and Center icon on the formatting toolbar. (Then hit the justification icon to make it the way you want.) Daniel - Sydney wrote: Hi I am using Excel 2000 SP3 is there a shortcut for mrerging cells in a column? thanks Daniel -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut Keys -- quick find | Excel Discussion (Misc queries) | |||
Deactivate shortcut keys in excel.. | Excel Discussion (Misc queries) | |||
Isolating a Keyboard Shortcut | Setting up and Configuration of Excel | |||
how can you customize a shortcut menu in excel? | Excel Discussion (Misc queries) | |||
How to make [toggling] shortcut keys to superscript and subscript, respectively? | Excel Discussion (Misc queries) |