Changing Number of Columns in Middle of Page

[GwenJ]

I have a spreadsheet with data set up in two columns - one is about 1" wide, and the second one is about 4" wide. About halfway down the page I need to change the format and have two columns under the 4" wide column. I can do that if I do a page break, but I need it to print all on one page. Is there a way to do this? All of us in our office are stumped on this one. Thanks!

[shg]

All columns in Excel are the same width throughout their extents.

If someone suggests that you merge cells, ignore thir suggestion or prepare for heartache.

[teylyn]

You could lay out the columns side by side and then use the camera tool to place an image of the second set underneath the first set.

You can add the camera tool to the QAT. It is one of the commands not in the ribbon.

See attached.