shifting rows up or down

[Paul_B]

I'm new to Excel, so please excuse a basic question.

Is there any way to shift rows without first creating blank rows
for them to land on? When I attempt to drag and drop, it asks me
if I intend on overwriting.

In Word there's a function to shift rows or paragraphs, and it
can be attached to a key command.

I also don't see any way to customize keyboard hotkeys.

Thanks for any insight.

p.

 

[Gord Dibben]

Paul

Not truly drag and drop but..............cut or copy and Insert>Cut or copied
cells.


Gord Dibben MS Excel MVP

 

[Jim Cone]

You can also press the Shift key while dragging the row.
Excel will move the row you drop it on either up or down.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Paul_B" <[email protected]>
wrote in message
I'm new to Excel, so please excuse a basic question.
Is there any way to shift rows without first creating blank rows
for them to land on? When I attempt to drag and drop, it asks me
if I intend on overwriting.
In Word there's a function to shift rows or paragraphs, and it
can be attached to a key command.
I also don't see any way to customize keyboard hotkeys.
Thanks for any insight.
p.

 

[Paul B]

Thought for a moment I posted a question I forgot about

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul_B]

Thought for a moment I posted a question I forgot about

Haha...

from now on I'll have to be known as "Paul <Underscore> B"

p.

 

[Paul_B]

You can also press the Shift key while dragging the row.
Excel will move the row you drop it on either up or down.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Paul_B" <[email protected]>
wrote in message
I'm new to Excel, so please excuse a basic question.
Is there any way to shift rows without first creating blank rows
for them to land on? When I attempt to drag and drop, it asks me
if I intend on overwriting.
In Word there's a function to shift rows or paragraphs, and it
can be attached to a key command.
I also don't see any way to customize keyboard hotkeys.
Thanks for any insight.
p.

Jim, that works great. Thanks much.

p.

 

[Paul_B]

Gord, Jim's nearby Shift-d&d solution works great.

But while I have you, if I may, is there any way to customize the
keyboard? I'd like to hotkey macros and formats.

Thanks,
p.

 

[Gord Dibben]

Most formatting operations already have hot keys assigned.

See Help "keyboard shortcuts" and "Format Data" section.

As far as macros go...you can assign short key combos to them.

Tools>Macro>Macros>Options


Gord

 

[Paul_B]

Most formatting operations already have hot keys assigned.

See Help "keyboard shortcuts" and "Format Data" section.

As far as macros go...you can assign short key combos to them.

Tools>Macro>Macros>Options

Gord

Great. Thanks very much!

p.