How can I keep my cell borders permanent?

[karstens]

How do you keep the cell borders from changing when you move an item from one cell to another? I use excel to reconcile our company's many bank accounts. The columns are set up to hold the outstanding checks. As some of those checks are cashed, and I clear the contents, it leaves gaps. I move data up to fill in the gaps, but then I lose all the borders and need to fix them. Is there a way I can just pick up and move data from one cell to another without doing the copy and paste special function?
Thanks for any help.

[jahoobob]

Select all the cells that you want to move up. Cut. Move to the cell
with the check that has been cashed and paste.
An alternative, if you are deleteing the entire row of info is to
delete the row by selecting the row and using Edit, Delete. All the
rows move up.
karstens Wrote:
> How do you keep the cell borders from changing when you move an item
> from one cell to another? I use excel to reconcile our company's many
> bank accounts. The columns are set up to hold the outstanding checks.
> As some of those checks are cashed, and I clear the contents, it
> leaves
> gaps. I move data up to fill in the gaps, but then I lose all the
> borders and need to fix them. Is there a way I can just pick up and
> move data from one cell to another without doing the copy and paste
> special function?
> Thanks for any help.
>
>
> --
> karstens
> ------------------------------------------------------------------------
> karstens's Profile:
> http://www.excelforum.com/member.php...o&userid=17657
> View this thread:
> http://www.excelforum.com/showthread...hreadid=477507


--
jahoobob