G Gord Dibben Jun 1, 2010 #2 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
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