Trying to have Multiple Tables in 1 worksheet with varying column formatting

[fat-tony]

Hi Guys,

I have been trying to play with formatting worksheets in Excel to make a nice report for printing.

I am trying to have 1 WorkSheet only in Excel and create a report for all subjects taught at school.

Using page breaks I have formatted the worksheet so that each subject starts at the top of a new page.

Each subject will have the same structure; First will have the name of the subject as the header of the page. i.e. 'Art & Design'
followed by a description and then followed by 3 different tables.

The problem is that the tables have a different number of columns and widths for their columns.

Is there a way to have multiple tables in 1 worksheet with different column formatting?

Thanks.

 

[VoG]

Hi. All columns on a worksheet have the same width. However you can change the appearance by merging cells horizontally (best avoided if you will be using any VBA) or preferably by selecting two or more cells in a row then setting the horizontal alignment to Center Across Selection.

 

[fat-tony]

Hi. All columns on a worksheet have the same width. However you can change the appearance by merging cells horizontally (best avoided if you will be using any VBA) or preferably by selecting two or more cells in a row then setting the horizontal alignment to Center Across Selection.

Thanks. I was hoping that there was another way but at least now I know not to sit back and wish for a magic button

I was using VBA:

.MergeCells = True

Have you had problems with this in the past?

Cheers

 

[VoG]

That will work. The trouble may come if you try to paste (using VBA) to that cell.