 |
 | 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 / May 2005Rows
How do I move a row in a worksheet from say, line 10 to line 1. Thank you. select the row Edit>Delete goto row 10 Insert>Rows  SignatureHTH Bob Phillips > How do I move a row in a worksheet > from say, line 10 to line 1. > Thank you. Select the row, right click and select cut,right click row 1 and select insert cut cells If row 1 is empty you can just select row 10 and drag it to row 1 Regards, Peo Sjoblom > How do I move a row in a worksheet > from say, line 10 to line 1. > Thank you. > If row 1 is empty you can just select row 10 and drag it to row 1 Or you can select the row, shift-click and hold on the selection border, and then drag the selection to where you want. The insertion point will be shown by a 'ghost' image. Bernie > > How do I move a row in a worksheet > > from say, line 10 to line 1. > > Thank you. I have some more items such as Bernie described that are missing or difficult to find in HELP concerning use of the mouse. Use of Mouse and keys to move, and insert rows or columns http://www.mvps.org/dmcritchie/excel/fillhand.htm Mouse operation in Excel and Internet Explorer are very poorly described in HELP. In fact if you want to know about how the mouse works in IE look at the Firefox documentation and they'll tell you how it works in IE, Mozilla, Firefox and Opera. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > > If row 1 is empty you can just select row 10 and drag it to row 1 > [quoted text clipped - 7 lines] > > > from say, line 10 to line 1. > > > Thank you. |
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.