ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Borders and "Columns to Repeat at Left" (https://www.excelbanter.com/excel-discussion-misc-queries/37538-cell-borders-%22columns-repeat-left%22.html)

DeLeo

Cell Borders and "Columns to Repeat at Left"
 
I have some sheets that extend multiple print pages to the right. I need to
repeat some of the columns on the left. I also need to set cell borders with
various type lines (double, thin, single, etc) to emphasize various parts of
the sheet.

I have not been able to figure out the logic of setting cell borders to come
out correctly when you have columns repeated at the left. All I see is
inconsistency, so I must not understanding the right approach, or order of
operations to get the sheet to print correctly. The best I have been able to
come up with (and this doesn't seem to always work right either) is that
there is some difference between the right side of A1 and the left side of B1.

Does anyone have a resource that will clearly explain this?


All times are GMT +1. The time now is 09:05 PM.

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