Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel 2010, every cell has a page break


(!)

holymoly's Avatar
holymoly holymoly is offline
Member with 635 posts.
THREAD STARTER
 
Join Date: Jun 2003
Location: Mississauga, ON
Experience: Intermediate
30-May-2012, 03:59 PM #1
Excel 2010, every cell has a page break
When doing a Page Break Preview, there a a page break for all cells, so the print option is set to print a page per cell.

Using Page Layout --> Remove Page Break (or alternatively Reset All Page Breaks) does not solve the issue.

One solution is to change the Size from 8.5 X 11 to 8.5 X 14, but I do not wish to print legal size.

A Google search, typically returned the Remove Page Break solution.


Any solutions?
WendyM's Avatar
Trusted Advisor with 3,997 posts.
 
Join Date: Jun 2003
Location: Northern California
31-May-2012, 11:47 AM #2
Is a print area set? Try going to the Page Layout tab and clearing the print area.
holymoly's Avatar
holymoly holymoly is offline
Member with 635 posts.
THREAD STARTER
 
Join Date: Jun 2003
Location: Mississauga, ON
Experience: Intermediate
31-May-2012, 11:58 AM #3
Thanks Wendy,

I tinkered around with the Clear print area and it cleared all the page breaks for all the cells
and I can now print on letter size.
WendyM's Avatar
Trusted Advisor with 3,997 posts.
 
Join Date: Jun 2003
Location: Northern California
31-May-2012, 12:03 PM #4
Great, glad it worked.
holymoly's Avatar
holymoly holymoly is offline
Member with 635 posts.
THREAD STARTER
 
Join Date: Jun 2003
Location: Mississauga, ON
Experience: Intermediate
31-May-2012, 02:45 PM #5
It did clear all the page breaks, but upon Print Preview or printing, all the page breaks reverted,

Back to the drawing board.
WendyM's Avatar
Trusted Advisor with 3,997 posts.
 
Join Date: Jun 2003
Location: Northern California
31-May-2012, 05:26 PM #6
Do you have more than one printer installed? If so, try switching to another printer and then look at it again. Does it still have the page breaks?
Garf13LD's Avatar
Garf13LD Garf13LD is offline
Member with 455 posts.
 
Join Date: Apr 2012
Experience: Intermediate
31-May-2012, 09:54 PM #7
1. Page Layout > Breaks > Reset All Page Breaks
2. Clear all print areas
3. Check your margins
4. All else fails, upload the file.
holymoly's Avatar
holymoly holymoly is offline
Member with 635 posts.
THREAD STARTER
 
Join Date: Jun 2003
Location: Mississauga, ON
Experience: Intermediate
02-Jun-2012, 04:44 PM #8
I remember someone had a page break issue and resolved when in page setup, the print was set to fit page.

Checking my settings, it was to fit one page vertically and horizontally. Trying to uncheck the fit one page, returned an error.

Bizarre.
WendyM's Avatar
Trusted Advisor with 3,997 posts.
 
Join Date: Jun 2003
Location: Northern California
03-Jun-2012, 11:52 PM #9
What error do you get? Have you tried changing to a different printer if you have one available?
holymoly's Avatar
holymoly holymoly is offline
Member with 635 posts.
THREAD STARTER
 
Join Date: Jun 2003
Location: Mississauga, ON
Experience: Intermediate
11-Jun-2012, 04:37 PM #10
Looks like its a printer issue, driver problem?

I did a preview in another printer, and the range displayed was correct.

Then I reverted to the preview with the problem printer, and the range stayed the same, no separate page for each cell in the range, or 3817 pages to print.

Strange
WendyM's Avatar
Trusted Advisor with 3,997 posts.
 
Join Date: Jun 2003
Location: Northern California
11-Jun-2012, 05:15 PM #11
Yep, that's my suspicion. I wouldn't be surprised if once you reboot, you're back to the same problem on the original printer. I'd try updating your drivers for the problem printer and printing to the alternate one in the meantime.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑