Office 2007: I want to include information from one excel sheet into another
and keep the formatting for both. The information at the top of the original
excel sheet will remain the same and the information copied from the other
excel sheet and placed at the bottom will also keep it's formatting. Is this
possible?

Each cell can be individually formatted. But the size (width) of all cells
in a column must be the same.

Regards,
Fred

"530i" wrote in message
...
Office 2007: I want to include information from one excel sheet into
another
and keep the formatting for both. The information at the top of the
original
excel sheet will remain the same and the information copied from the other
excel sheet and placed at the bottom will also keep it's formatting. Is
this
possible?

Column width and row height are properties of the column and row.

I hesitate to mention "merged cells" due to the many problems they can
cause.

If for presentation only they have their place.

Alternative.................use the Camera Tool to take a picture of the
other sheet range and paste below the top part.


Gord Dibben MS Excel MVP

On Tue, 28 Jul 2009 15:57:01 -0700, 530i
wrote:

Office 2007: I want to include information from one excel sheet into another
and keep the formatting for both. The information at the top of the original
excel sheet will remain the same and the information copied from the other
excel sheet and placed at the bottom will also keep it's formatting. Is this
possible?