Excel table formatting in A4 printable format

Arafat

Board Regular
Joined
May 3, 2011
Messages
61
Hello Folks,

I am trying to create a table format where i have setup the page layout to A4 size. I populate the table with data that is received from the server and that is only single column,everything works fine. What i want is when the data is inserted into Col A i want the data to fill the Col B and so on when the page break occurs and then if that page has no space left it should start filling the data in the next page. when the data move to col b and so on it should also have headers.

I am looking for something like this https://stackoverflow.com/questions/22785823/how-to-repeat-table-in-one-report-side

As i was googling for this i found pointers to Tablix data regions but i am not sure how to use that on Excel.

Any guidance is appreciated.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,099,156
Messages
5,466,983
Members
406,513
Latest member
t0ny84

This Week's Hot Topics

Top