Cutting Nonadjacent Rows

Excel 2003

I have a spreadsheet that I need to move rows in.
Just a simple spreadsheet with several rows of data. No formulas
or anything else.
When I select say, row 1 and row 5 in the spreadsheet,
then click Edit, Cut, Excel pops up a window saying I cannot do this.

"The command you chose cannot be perfomed with multiple
selections. Select a single range, and click the command again"

Yet when I go to Excel Help to find out out to move rows, that is
exactly what it tell me to do:

"Nonadjacent rows or columns:
1. Select the first row or column, and then hold down CTRL and select the other rows or columns.
2. Click Cut
3. Select a row or column below or to the right of where you want to move your selection.
4. On the Insert menu, click Cut Cells. "

What am I doing wrong? Why won't Excel let me cut
nonadjacent rows?

Hi RJ

You can manual copy whole rows but not Cut

You can use macro to do it

Select for example A3,A5,A10 and it will copy the rows to Sheet2 and delete the rows after that

Sub test()
With Selection
.EntireRow.Copy Sheets("Sheet2").Range("A1")
.EntireRow.Delete
End With
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"RJ" <[email protected]> wrote in message news:[email protected]...
> Excel 2003
>
> I have a spreadsheet that I need to move rows in.
> Just a simple spreadsheet with several rows of data. No formulas
> or anything else.
> When I select say, row 1 and row 5 in the spreadsheet,
> then click Edit, Cut, Excel pops up a window saying I cannot do this.
>
> "The command you chose cannot be perfomed with multiple
> selections. Select a single range, and click the command again"
>
> Yet when I go to Excel Help to find out out to move rows, that is
> exactly what it tell me to do:
>
> "Nonadjacent rows or columns:
> 1. Select the first row or column, and then hold down CTRL and select the other rows or columns.
> 2. Click Cut
> 3. Select a row or column below or to the right of where you want to move your selection.
> 4. On the Insert menu, click Cut Cells. "
>
> What am I doing wrong? Why won't Excel let me cut
> nonadjacent rows?
>
>

Thanks, but all I want to do is move several nonadjacent
rows around in the same sheet. I find it hard to believe you
cannot do this. It seems like a common task. Not to mention
Excel help tells you how to do it.

I am still confused.



"Ron de Bruin" <[email protected]> wrote in message
news:[email protected]...
> Hi RJ
>
> You can manual copy whole rows but not Cut
>
> You can use macro to do it
>
> Select for example A3,A5,A10 and it will copy the rows to Sheet2 and delete the rows after that
>
> Sub test()
> With Selection
> .EntireRow.Copy Sheets("Sheet2").Range("A1")
> .EntireRow.Delete
> End With
> End Sub
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "RJ" <[email protected]> wrote in message news:[email protected]...
>> Excel 2003
>>
>> I have a spreadsheet that I need to move rows in.
>> Just a simple spreadsheet with several rows of data. No formulas
>> or anything else.
>> When I select say, row 1 and row 5 in the spreadsheet,
>> then click Edit, Cut, Excel pops up a window saying I cannot do this.
>>
>> "The command you chose cannot be perfomed with multiple
>> selections. Select a single range, and click the command again"
>>
>> Yet when I go to Excel Help to find out out to move rows, that is
>> exactly what it tell me to do:
>>
>> "Nonadjacent rows or columns:
>> 1. Select the first row or column, and then hold down CTRL and select the other rows or columns.
>> 2. Click Cut
>> 3. Select a row or column below or to the right of where you want to move your selection.
>> 4. On the Insert menu, click Cut Cells. "
>>
>> What am I doing wrong? Why won't Excel let me cut
>> nonadjacent rows?
>>
>>
>
>