Is there a way to cut a line and insert the line on another sheet without
leaving the blank line on the sheet that you cut the line from?

All in two steps--I know that I could go back and delete the blank line but
wondered if I could do it in only two steps

Sherry

"shertone" wrote:

Is there a way to cut a line and insert the line on another sheet without
leaving the blank line on the sheet that you cut the line from?

All in two steps--I know that I could go back and delete the blank line but
wondered if I could do it in only two steps

Sherry

My guess is you are selecting and highlighting the data that you want to
CUT. This will empty the cells and leave the row in place.

What you should do is highlight the ROW by clicking on the row number at the
left side of the window, and then CUT. This will copy the content to the
clipboard and remove the row from the source sheet.

When you go to the destination sheet, you want to highlight the row where
you want to place the data and then INSERT CUT CELLS or INSERT ROW (depending
on version). This will push the lower rows down to make room for the new row
and enter the cut data into the empty cells.

TRY THIS ON A TEST SPREADSHEET BEFORE YOU DO IT WITH LIVE DATA.
If you've never done these things before, they can seem tricky. So make up
some stuff you can experiment with until you are comfortable doing this.

B+
HALinNY

HAL

Which version of Excel removes the row when row is cut and pasted elsewhere?

None that I have ever used from 5.0 through 11 will delete a cut row without the
going-back-and-deleting step.


Gord Dibben MS Excel MVP

On Fri, 1 Dec 2006 10:01:00 -0800, HALinNY
wrote:



"shertone" wrote:

Is there a way to cut a line and insert the line on another sheet without
leaving the blank line on the sheet that you cut the line from?

All in two steps--I know that I could go back and delete the blank line but
wondered if I could do it in only two steps

Sherry

My guess is you are selecting and highlighting the data that you want to
CUT. This will empty the cells and leave the row in place.

What you should do is highlight the ROW by clicking on the row number at the
left side of the window, and then CUT. This will copy the content to the
clipboard and remove the row from the source sheet.

When you go to the destination sheet, you want to highlight the row where
you want to place the data and then INSERT CUT CELLS or INSERT ROW (depending
on version). This will push the lower rows down to make room for the new row
and enter the cut data into the empty cells.

TRY THIS ON A TEST SPREADSHEET BEFORE YOU DO IT WITH LIVE DATA.
If you've never done these things before, they can seem tricky. So make up
some stuff you can experiment with until you are comfortable doing this.

B+
HALinNY

"Gord Dibben" wrote:

HAL

Which version of Excel removes the row when row is cut and pasted elsewhere?

None that I have ever used from 5.0 through 11 will delete a cut row without the
going-back-and-deleting step.



By golly, you are right, Gord. It works on the same sheet but not on a
different sheet.

My apologies for not testing what I described before offering it.

B+
HALinNY

so, are you both thinking there is no way to do this between sheets?

Sherry

"HALinNY" wrote:



"Gord Dibben" wrote:

HAL

Which version of Excel removes the row when row is cut and pasted elsewhere?

None that I have ever used from 5.0 through 11 will delete a cut row without the
going-back-and-deleting step.



By golly, you are right, Gord. It works on the same sheet but not on a
different sheet.

My apologies for not testing what I described before offering it.

B+
HALinNY

"shertone" wrote:

so, are you both thinking there is no way to do this between sheets?

Sherry


It's looking that way to me, shertone, but I will defer to Gord, the MVP.

B+
HALinNY

Not without some sort of VBA code/macro.

Sub cutanddelete()
With ActiveSheet
ActiveCell.EntireRow.cut Destination:= _
Sheets("Sheet2").Range("A1")
ActiveCell.EntireRow.Delete
End With
End Sub


Gord

On Fri, 1 Dec 2006 11:14:01 -0800, shertone
wrote:

so, are you both thinking there is no way to do this between sheets?

Sherry

"HALinNY" wrote:



"Gord Dibben" wrote:

HAL

Which version of Excel removes the row when row is cut and pasted elsewhere?

None that I have ever used from 5.0 through 11 will delete a cut row without the
going-back-and-deleting step.



By golly, you are right, Gord. It works on the same sheet but not on a
different sheet.

My apologies for not testing what I described before offering it.

B+
HALinNY


Gord Dibben MS Excel MVP