Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
I'm having printing problems with excel 2007??
I am trying to print an entire workbook with sheets 1-15 in excel. When I do I print it prints a blank paper between every sheet. I am not sure what to click when printing so that this doesn't happen. I select all sheets to print but it doesn't happen in every workbook i have, not sure what I did or how to stop it. Thanks for your help. I will pick a best answer.
1 Answer
- Timothy SLv 68 years agoFavorite Answer
Analyze this way:
Click File | Print preview. Then go back to the actual sheets and look for the dotted lines. These are how Excel is breaking up the pages. There may be some data overhanging a cell which is triggering a new page. There could also be invisible data or formatting somewhere adjacent, eg a cell "cleared" with space bar.
If you have to you can go in and manually Set Print Area for each sheet.