 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007shifting rows up or down
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.  SignatureMS Office '03 Basic on Win XP Paul Not truly drag and drop but..............cut or copy and Insert>Cut or copied cells. Gord Dibben MS Excel MVP >I'm new to Excel, so please excuse a basic question. > [quoted text clipped - 10 lines] > >p. 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. > Paul > [quoted text clipped - 17 lines] >> >>p. SignatureMS Office '03 Basic on Win XP 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 >Gord, Jim's nearby Shift-d&d solution works great. > [quoted text clipped - 25 lines] >>> >>>p. > Most formatting operations already have hot keys assigned. > [quoted text clipped - 5 lines] > > Gord Great. Thanks very much! p. SignatureMS Office '03 Basic on Win XP You can also press the Shift key while dragging the row. Excel will move the row you drop it on either up or down. SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Paul_B" <pb_public-SeeHeaders@operamail.com> 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. -- MS Office '03 Basic on Win XP > 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, that works great. Thanks much. p. SignatureMS Office '03 Basic on Win XP Thought for a moment I posted a question I forgot about :) SignaturePaul 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 > I'm new to Excel, so please excuse a basic question. > [quoted text clipped - 10 lines] > > p. > 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. SignatureMS Office '03 Basic on Win XP
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.