|
|
Excel wants to print too many copies of one sheet
|
|
|
|
Forum Regular
Join Date: Jun 2008
Location: Los Angeles
Status:
Offline
|
|
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?
|
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status:
Offline
|
|
Check the page preview.
You might have accidentally entered something in a cell way to the bottom.
-t
|
|
|
|
|
|
|
|
|
Forum Regular
Join Date: Jun 2008
Location: Los Angeles
Status:
Offline
|
|
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.
|
|
|
|
|
|
|
|
|
Senior User
Join Date: Dec 2005
Status:
Offline
|
|
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.
|
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status:
Offline
|
|
Originally Posted by EndlessMac
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
|
|
|
|
|
|
|
|
|
Senior User
Join Date: Dec 2005
Status:
Offline
|
|
Originally Posted by turtle777
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...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|