ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   w/excel how can I have half a page width differ from bottom (https://www.excelbanter.com/excel-discussion-misc-queries/265009-w-excel-how-can-i-have-half-page-width-differ-bottom.html)

Deb

w/excel how can I have half a page width differ from bottom
 
w/excel how can I have half a page width differ from bottom

Gord Dibben

w/excel how can I have half a page width differ from bottom
 
Column width is a property of the entire column so you cannot change wdiths
part way down.

You can merge cells if just for display and printing only.

Merged cells can cause no end of problems if you need to sort, copy and
paste, filter or a host of other functions.

BUT if only for print or display..........use them.

Or place bottom half of data on another sheet, adjust width to suit then
take a picture of it and paste to bottom half of first sheet.


Gord Dibben MS Excel MVP

On Tue, 1 Jun 2010 12:01:01 -0700, deb
wrote:

w/excel how can I have half a page width differ from bottom




All times are GMT +1. The time now is 04:29 PM.

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