Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rows
How do I move a row in a worksheet
from say, line 10 to line 1. Thank you. |
#2
|
|||
|
|||
select the row
EditDelete goto row 10 InsertRows -- HTH Bob Phillips "David" wrote in message ... How do I move a row in a worksheet from say, line 10 to line 1. Thank you. |
#3
|
|||
|
|||
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 "David" wrote: How do I move a row in a worksheet from say, line 10 to line 1. Thank you. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |