I have a large excel [2007] document that I am constantly cutting,
copying and pasting data in.

When I cut or copy a cell and paste it somewhere else, I have to fill
in the borders of the cell.....sometimes from the cell I removed
information from or the cell I pasted information in to. This is
annoying and time consuming. Is there a way to copy & paste the data
in the cells AND include the formatting, including border lines?

Also, how do I insert more than one line at a time? When I try to
insert more than one row, it pastes on top of the rows already there,
instead of inserting the appropriate number of rows to make room for
the inserted rows. Hard to explain. So I have to insert rows, one at
a time, to make room for the rows I want to paste there. I would
prefer to 'paste 10 rows here' or however many I need instead of one
row at a time.

Thanks for any help.




--
Selahgal