This can be useful for splitting long tables into two separate tables-mostly in hopes of dealing with formatting issues that multi-page tables can sometimes cause. You can get just about as complicated with your table layout as you’d want. When we hit “OK” the table turns out just like you’d expect.Īnd obviously, this is just a quick look. We also want those cells merged before being split, so make sure that option is selected. In the Split Cells window, we’d select three columns and two rows. We’d head to Table Tools > Layout > Split Cells (a lot of times the Split Cells command doesn’t show up on the context menu when you have multiple cells selected, so it’s easier to use the Ribbon button). And we want to take those selected cells (the ones in gray under the second column header) and turn them into two big rows of three columns each. Let’s say we had a table like the one shown below. I had to reposition the table and your headings because it was hanging off the left side of the first page, maybe because of all the nested divs with in-line styles?, I do not know, like I said this worked with your html.As you probably guessed from the options in that Split Cells window, you can also get a little more complex with cell splitting. The print preview will show all the pages turned 90 degrees, that's what you want, then select A4 as the paper size in the print dialog. But if you are posting all the printed pages up on a wall side-by-side it will be readable. Unfortunately I could not get the page to break between columns. The key is rotating the content for print so it overflows "down" to the next page, then set size to landscape to rotate the paper, so you end up with left to right portrait oriented pages. It worked with the html you provided in your link, add this to your stylesheet (I only tested in Chrome) This appears to do what you want, if that is to place the printed pages side-by-side and read the entire table as it is on screen. Scroll down the list of commands and select ‘Form’.
In the ‘Excel Options’ dialog box that opens, select the ‘All Commands’ option from the drop-down. Click on ‘Customize Quick Access Toolbar’. You may convert your html with to using table-to-divs Right-click on any of the existing icons in the Quick Access Toolbar. Width:100px // set to a fixed value so as to get the table in the ordered manner. With we have better control of the way its displayed. You should try to use divs rather than tables if you want to get good printable sheets.
0 kommentar(er)
