I have a user that recently switched from Excel 2011 on a Mac to Excel 2010 on a PC. I'm pulling my hair out trying to figure this out.
Imagine a single spreadsheet with 5 months worth of scheduling on it. Depending on the month, you have 31 or 30 rows. Depending on the data in each row and column, some rows have multiple lines due to the way the text wraps.
Now, we want 1 page per month. I move the page breaks right under May 31st, June 30th, July 31st, etc. One page, one month.
Problem is, June has too many rows so it "spills over" onto the next page. I can fix this on Mac Excel 2011 by dragging June's page break up from June 17th (approximately where they auto page break is made) down to June 30th. When I print this document, all the other months that already fit onto their pages print out at say, a 12 point font. June on the other hand, shrinks itself down slightly and prints at a 10 point font.
On Exel 2010, I can't seem to get this to work. I want Excel to "fit to page" for ONLY the month of June. I can't drag the page break like I can in Excel 2011 - it drags but simply reverts back down to June 17th. If I use any of the Fit to Page options in the Page Layout or Print boxes, it Fits to Page for the entire document, basically making it tiny.
Any ideas on how to get Excel 2010 to "fit to page" for only 1 page in a multi-page spreadsheet? Thanks!
Imagine a single spreadsheet with 5 months worth of scheduling on it. Depending on the month, you have 31 or 30 rows. Depending on the data in each row and column, some rows have multiple lines due to the way the text wraps.
Now, we want 1 page per month. I move the page breaks right under May 31st, June 30th, July 31st, etc. One page, one month.
Problem is, June has too many rows so it "spills over" onto the next page. I can fix this on Mac Excel 2011 by dragging June's page break up from June 17th (approximately where they auto page break is made) down to June 30th. When I print this document, all the other months that already fit onto their pages print out at say, a 12 point font. June on the other hand, shrinks itself down slightly and prints at a 10 point font.
On Exel 2010, I can't seem to get this to work. I want Excel to "fit to page" for ONLY the month of June. I can't drag the page break like I can in Excel 2011 - it drags but simply reverts back down to June 17th. If I use any of the Fit to Page options in the Page Layout or Print boxes, it Fits to Page for the entire document, basically making it tiny.
Any ideas on how to get Excel 2010 to "fit to page" for only 1 page in a multi-page spreadsheet? Thanks!
