SOLVED

Spreadsheet layout to include more rows on page

Copper Contributor

A co-worker has sent a spreadsheet that shows a list of sponsors for an event. Each sponsor receives a table of 8 seats for the event's meals. When I look and and then print the sheets, it will show only one "table of eight" on a page, with a large margin of white space at the bottom of the page. I need help in removing that space, so I can get more "tables of 8" on a page. Any help is appreciated, thank you.

2 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

@SKGNDCHF 

On the Layout tab of the ribbon, select Breaks > Reset All Page Breaks to see if that makes a difference.

You may want to set new page breaks to ensure that "tables of eight" remain together.

@Hans Vogelaar 

 

thank you !! -- it worked!!!!!!!!!!!!!

;)

 

Sharon

1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@SKGNDCHF 

On the Layout tab of the ribbon, select Breaks > Reset All Page Breaks to see if that makes a difference.

You may want to set new page breaks to ensure that "tables of eight" remain together.

View solution in original post