"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