Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > Excel wants to print too many copies of one sheet

Excel wants to print too many copies of one sheet
Thread Tools
jretzner
Forum Regular
Join Date: Jun 2008
Location: Los Angeles
Status: Offline
Reply With Quote
Nov 26, 2008, 03:48 PM
 
Using Excel 2008 with my iMac using 10.5.5 I have a problem I've not seen before. When I press Command-P the Print box pops up. It tells me it will print 1 of 1821 pages. What command might have been accidentally activated by me to ask for 1821 pages? How might I correct it so only 1 page will be printed?
     
turtle777
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status: Offline
Reply With Quote
Nov 26, 2008, 03:55 PM
 
Check the page preview.

You might have accidentally entered something in a cell way to the bottom.

-t
     
jretzner  (op)
Forum Regular
Join Date: Jun 2008
Location: Los Angeles
Status: Offline
Reply With Quote
Nov 26, 2008, 04:06 PM
 
Thanks! You were right on, but in the other direction. I scanned across to cell XDF-5. For some reason it had a frame around it. I have no idea how I did that, but it was there.
     
EndlessMac
Senior User
Join Date: Dec 2005
Status: Offline
Reply With Quote
Nov 26, 2008, 05:40 PM
 
There should also be an option to not print empty rows. It's actually a common problem for people to accidentally enter something or forget to delete some cell that is way further down or across the page.

You would still have to delete the problem but at least you won't print all those empty rows if you pressed the print button by accident.
     
turtle777
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status: Offline
Reply With Quote
Nov 26, 2008, 06:25 PM
 
Originally Posted by EndlessMac View Post
There should also be an option to not print empty rows.
I never seen this.

The only solutions I have heard about are VBA macros.

-t
     
EndlessMac
Senior User
Join Date: Dec 2005
Status: Offline
Reply With Quote
Nov 27, 2008, 12:42 AM
 
Originally Posted by turtle777 View Post
I never seen this.

The only solutions I have heard about are VBA macros.

-t
You are probably right. I thought I remember seeing the feature I mentioned...
     
   
Thread Tools
 
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Top
Privacy Policy
All times are GMT -4. The time now is 11:32 PM.
All contents of these forums © 1995-2017 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2017, Jelsoft Enterprises Ltd.,