ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Independent column widths (https://www.excelbanter.com/excel-worksheet-functions/106478-independent-column-widths.html)

Kathleen

Independent column widths
 
I am making a report template and would like the top 10 rows to contain some
standard information (customer, date, contact info, etc.). Below Row 10,
analytical test results will be entered which will vary with each report. I
would like to be able to adjust the column width in the lower section without
changing the upper section. Is there a way to adjust the column widths
independently in an upper vs. a lower section of a worksheet?

Don Guillett

Independent column widths
 
Not without using merged cells which is not recommended.

--
Don Guillett
SalesAid Software

"Kathleen" wrote in message
...
I am making a report template and would like the top 10 rows to contain
some
standard information (customer, date, contact info, etc.). Below Row 10,
analytical test results will be entered which will vary with each report.
I
would like to be able to adjust the column width in the lower section
without
changing the upper section. Is there a way to adjust the column widths
independently in an upper vs. a lower section of a worksheet?




CLR

Independent column widths
 
Not as such.........but for reporting purposes, you can take a picture of
your data located elsewhere and paste it into place below your
header.........(Ctrl-Shift-Edit CopyPicture)........

hth
Vaya con Dios,
Chuck, CABGx3



"Kathleen" wrote:

I am making a report template and would like the top 10 rows to contain some
standard information (customer, date, contact info, etc.). Below Row 10,
analytical test results will be entered which will vary with each report. I
would like to be able to adjust the column width in the lower section without
changing the upper section. Is there a way to adjust the column widths
independently in an upper vs. a lower section of a worksheet?



All times are GMT +1. The time now is 09:44 AM.

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