Merged cells are evil - fact.



Not sure if this is exactly what you are after, but maybe linked Picture is the answer? I have added another sheet called View.

I then copied rows 1 to 19 from Multi Columns, clicked on view sheet, right click paste special > linked picture and then copied rows 19 to 40 from Min Columns clicked on view sheet, right click paste special > linked picture.

The view page then gives you the print view in 1 sheet and as they are linked Pictures then will update, so it might be possible to set this up to be a standard template

Attached Files

Floating Table_Purfleet.xlsx (45.0 KB, 10 views)