ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can th same spreadsheet have varying cell sizes top & bottom (https://www.excelbanter.com/excel-discussion-misc-queries/238253-can-th-same-spreadsheet-have-varying-cell-sizes-top-bottom.html)

530i

can th same spreadsheet have varying cell sizes top & bottom
 
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?


Fred Smith[_4_]

can th same spreadsheet have varying cell sizes top & bottom
 
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?



Gord Dibben

can th same spreadsheet have varying cell sizes top & bottom
 
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?




All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com