Copy/Paste Doesn't Carry Formats

[Selahgal]

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.

 

[Sheeloo]

Normally if you cut/copy and paste, formatting is also applied to the
destination cells..

However if you are using Paste Special | Values then you need to do a Paste
Special | Format first...(You have to cut/copy only once but do Paste Special
twice, once choosing Formats and then choosing Values)

To insert multiple rows at the destination - choose your starting
destination cell, right-click and choose 'insert copied cells'...

 

[Archimedes' Lever]

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.

Develop a blank line mark and paste macro then and use it before you
insert to mark a certain number of blank lines above your cursor
location. Hell, there is probably a function for it.