Chris Johnson wrote:
Using the simplest case as an example:
If you start with adjacent cells containing ABCDEF then Shift+Drag&Drop B to between D&E you get ACDBEF in one go.
Without Shift, you would end up with A_CBEF or A_CDBF unless you inserted a blank cell between D&E first.
It's the equivalent of OO's Paste Special with cells shifted, but with OO you have to do it thru the Edit > Paste Special > Shift Cells dialogue.
I know of no shortcut key or mouse shortcut to do it in as few keystrokes as Excel.
Brian
-- OpenOffice office suite : Thunderbird email : Firefox browser
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
