Excel - shifting rows up or down

Asked By Paul_B on 22-Jan-07 09:18 PM
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.
--
MS Office '03 Basic on Win XP




Gord Dibben replied on 23-Jan-07 12:03 AM
Paul

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


Gord Dibben  MS Excel MVP
Jim Cone replied on 23-Jan-07 12:26 AM
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



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.
--
MS Office '03 Basic on Win XP
Paul B replied on 23-Jan-07 06:56 AM
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 replied on 23-Jan-07 10:13 AM
Haha...

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

p.
--
MS Office '03 Basic on Win XP
Paul_B replied on 23-Jan-07 10:14 AM
Jim, that works great. Thanks much.

p.
--
MS Office '03 Basic on Win XP
Paul_B replied on 23-Jan-07 10:16 AM
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.





--
MS Office '03 Basic on Win XP
Gord Dibben replied on 23-Jan-07 12:26 PM
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

On Tue, 23 Jan 2007 10:16:10 -0500, Paul_B <pb_public-SeeHeaders@operamail.com>
Paul_B replied on 23-Jan-07 03:11 PM
Great. Thanks very much!

p.
--
MS Office '03 Basic on Win XP