 |
 | 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 / March 2008Drag and Drop Rows (not just cells)
Hi. Is it possible to move a row or rows to other places using drag and drop? Right now I insert a new (empty) row in the place or places I want to paste, then I copy the row or rows I want to move, paste it or them in the empty rows and then go back and delete the rows that have just been copied. This is quite tedious, indeed. Is there a faster way to move rows, aside from creating a macro, which I am unable to do? If it is possible, please explain how to do this in simple English, step by step. Thanks. Hi Rebecca, Right click on the row number identifer on the left of the page. This will select the entire row and bring up a menu. Select Cut. Right click on the row where you want to insert. This will select the entire row and display a menu. Select Insert Cut cells. Note when inserting the row, it inserts it above the one that has been selected. In earlier versions of Excel, all the above can be done with the right mouse button although when selecting the menu options you can use either button. In Excel 2007, you still initially use the right mouse button but the menu options have to be selected with the left mouse button. I am not sure if there are any options to modify this.  SignatureRegards, OssieMac > Hi. Is it possible to move a row or rows to other places using drag and drop? > [quoted text clipped - 5 lines] > from creating a macro, which I am unable to do? If it is possible, please > explain how to do this in simple English, step by step. Thanks. Thanks, OssieMac. You are a big help. This is what I need. > Hi Rebecca, > [quoted text clipped - 22 lines] > > from creating a macro, which I am unable to do? If it is possible, please > > explain how to do this in simple English, step by step. Thanks. And you could use the macro recorder whilst doing this. Or is the "unable to do" some kind of IT restriction imposed upon you? Gord Dibben MS Excel MVP >Thanks, OssieMac. You are a big help. This is what I need. > [quoted text clipped - 24 lines] >> > from creating a macro, which I am unable to do? If it is possible, please >> > explain how to do this in simple English, step by step. Thanks. I came to this "new user" forum asking for some help, not sarcastic, demeaning remarks. I don't think this kind of response is becoming of an MS Excel MVP. > And you could use the macro recorder whilst doing this. > [quoted text clipped - 30 lines] > >> > from creating a macro, which I am unable to do? If it is possible, please > >> > explain how to do this in simple English, step by step. Thanks. Hi Rebecca, There is no sarcasm or demeaning remarks in Gord's post. As you said you came to this group looking for help which you recieved and will always recieve in these groups. Gord is one of the most patient and helpful users in these newsgroups that's why he has been awarded the MVP title. Were you to ask Gord about how he feels the Macro recorder could add to the solution you already recieved, you will find that he is (as are many others) more than willing to walk you through the process. You will very rarely find attitude in these newsgroups. Kind Regards Martin >I came to this "new user" forum asking for some help, not sarcastic, > demeaning remarks. I don't think this kind of response is becoming of an [quoted text clipped - 51 lines] >> >> > please >> >> > explain how to do this in simple English, step by step. Thanks. Hi Rebecca There are many people who post in these NG's who are employed by organisations who prohibit the use of macro solutions. Gord was merely enquiring whether you were under that sort of imposition. If you are not, then he was suggesting you could create a macro, by turning on the recorder whilst carrying out the steps that OssieMac proposed. I certainly didn't consider his response to be in any way demeaning, or sarcastic and neither would that be in his nature. SignatureRegards Roger Govier > I came to this "new user" forum asking for some help, not sarcastic, > demeaning remarks. I don't think this kind of response is becoming of an [quoted text clipped - 51 lines] >> >> > please >> >> > explain how to do this in simple English, step by step. Thanks. Others have responded in my defense and have interpreted my response in the vein in which it was intended. You stated "aside from creating a macro, which I am unable to do?" I was merely inquiring if you were restricted from using macros by your IT Dept, which is quite common. If you had stated "I don't know how" then my response would have been to walk you through creating a simple macro using the recorder. Gord >I came to this "new user" forum asking for some help, not sarcastic, >demeaning remarks. I don't think this kind of response is becoming of an MS [quoted text clipped - 34 lines] >> >> > from creating a macro, which I am unable to do? If it is possible, please >> >> > explain how to do this in simple English, step by step. Thanks. I'm sorry for my hasty misunderstanding of Gord's remarks. It's entirely my fault for not reading (or thinking more carefully) about your post. I never assumed some companies would prohibit the creation of macros, but now that your defenders mentioned the reasons, it all makes sense. Again, I apologize for the false accusation. > Others have responded in my defense and have interpreted my response in the vein > in which it was intended. [quoted text clipped - 47 lines] > >> >> > from creating a macro, which I am unable to do? If it is possible, please > >> >> > explain how to do this in simple English, step by step. Thanks. Thank you Rebecca. In your defense, the quotes around "unable to do" look a little sarcastic in light of your not knowing that many companies have restictions on running macros or installing Add-ins. Gord >I'm sorry for my hasty misunderstanding of Gord's remarks. It's entirely my >fault for not reading (or thinking more carefully) about your post. I never [quoted text clipped - 53 lines] >> >> >> > from creating a macro, which I am unable to do? If it is possible, please >> >> >> > explain how to do this in simple English, step by step. Thanks. > Hi. Is it possible to move a row or rows to other places using drag and drop? > [quoted text clipped - 5 lines] > from creating a macro, which I am unable to do? If it is possible, please > explain how to do this in simple English, step by step. Thanks. Click on the the row/column header to highlight the entire row. Hold down the shift key and place your cursor in the heading and you should see a cursor with 4 arrows now just drag the row where you want it. Try this on a test sheet it can be a bit difficult the first couple of times. gls858
|
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.