Copying and moving cells

  • Thread starter Thread starter Tim Vice
  • Start date Start date
T

Tim Vice

I have a spread sheet that looks something like this:

1
this is a







2
test







3
to







4
see









The numbers are keying off the first number with this code
=IF(ISNUMBER(A15),A15+1,"--"), so if I delete a number the number column has
"--" and the next number is in sequence.

Now for the question, How can I automatically move a line up into a cell?

For example if I remove "test" from the 2nd line how can I automatically
move everything below it up to fill the empty position.
So "test"would be gone and "to" would be in the 2nd line and "see" in the
3rd.

Any ideas would be appreciated.

Thanks for your help.
Tim
 
I must have a cranial air pocket this morning. What exactly are you trying
to do? Although I do not havea spreadsheet that looks like the example you
posted, I suppose I could if I skipped rows.
 
Tim,
Couldn't you just select the row and delete it, instead of just deleting the text inside the cell? You could change your numbering formula to some form of =ROW(A6)-5. If this were entered in A6 it would return a 1. Then when you delete rows the number updates automatically.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Tim Vice wrote: -----

didn't post quite right should look like this:

1 this is a
2 test
3 to
4 see

Sorry
 
I have several number lines in the first column (A)
then in the next column over (B) there is a cell to write in.

There are times when we are using the sheet that we don't need all of the
write-up in the second column (B), when we delete them it leaves a blank
cell,(with the number still in the first cell( A)
I would like for all the other write-up to move up to the blank cell
automatically after the one above has been deleted. Is that possible?

The workbook has 3 pages and deleting the entire row would disrupt the
layout of each sheet.

I hope this helps.
Thanks
 
Wouldn't that disrupt the layout of the sheet when I print it

Mark Graesser said:
Tim,
Couldn't you just select the row and delete it, instead of just deleting
Click to expand...
the text inside the cell? You could change your numbering formula to some
form of =ROW(A6)-5. If this were entered in A6 it would return a 1. Then
when you delete rows the number updates automatically.
 
I assume you are using the Delete key on the keyboard. This deletes (i.e.
clears) the contents of the cell. What you want is to delete the cell
itself. You can do this by selecting the cell and using Edit > Delete (or
right-clicking the cell and using Delete on the pop-up menu, as that's the
same thing). A dialog box will open with "Shift Cells Up" already selected,
which is what you want, so click OK.
 
It depends on how complicated the layout of the sheet is. If you have manually created headers or footers, or if you have set up page breaks, then it will definitly mess up your print.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Tim Vice wrote: -----

Wouldn't that disrupt the layout of the sheet when I print it

Mark Graesser said:
Tim,
Couldn't you just select the row and delete it, instead of just deleting
Click to expand...
the text inside the cell? You could change your numbering formula to some
form of =ROW(A6)-5. If this were entered in A6 it would return a 1. Then
when you delete rows the number updates automatically.
 
Back
Top