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 > > >

Solved: Extra Unwanted Pages In Microsoft Excel


(!)

blujein's Avatar
blujein blujein is offline
Member with 158 posts.
THREAD STARTER
 
Join Date: May 2008
Location: Australia
Experience: Advanced
22-Jul-2008, 08:39 AM #1
Question Solved: Extra Unwanted Pages In Microsoft Excel
Hello,

I have a Microsoft Excel workbook with multiple spreadsheets, some of which appear to have more pages than content on them. As an example, I might have two pages of information contained on the spreadsheet, but when I go to print, it prints nine pages rather than just the two - leaving the extra seven blank.

Can someone tell me what is most likely the problem here, or whether there is a way to get Microsoft Excel to automatically get rid of the extra pages?

Thank you in advance!

Last edited by blujein; 22-Jul-2008 at 08:47 AM..
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
22-Jul-2008, 09:29 AM #2
Well, generally I would just say make sure you set the print area.
I haven't tried this, but it seems to apply to what you want
http://www.vbaexpress.com/forum/show...set+print+area
littlrbrain's Avatar
littlrbrain littlrbrain is offline
Computer Specs
Junior Member with 7 posts.
 
Join Date: Sep 2007
Experience: Beginner
22-Jul-2008, 10:34 PM #3
select the print area by holding down left mouse button [or click the first cell and, while holding down shift key, click the last cell of the page to be copied ]. Go to file menu,select print area>set print area. See the pages selected by clicking print preview in menu bar. Delete any
rows unwanted by selecting the row number and pressing
delete key.
blujein's Avatar
blujein blujein is offline
Member with 158 posts.
THREAD STARTER
 
Join Date: May 2008
Location: Australia
Experience: Advanced
23-Jul-2008, 04:23 AM #4
Thank you for your advice! Although that helps when it comes to printing, when I am looking at the spreadsheet on the screen it still shows the extra page and the particularly small scroll-bar (given how long the document is with the additional pages). Is there a a way to stop that?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
23-Jul-2008, 06:21 AM #5
You should find the last line of actual data and highlight (select) all the rows below it to the bottom. On the main menu select Edit>Delete and delete all the rows and then save it.
Close the workbook, reopen and check it.
Aj_old's Avatar
Aj_old Aj_old is offline
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
23-Jul-2008, 06:56 AM #6
Quote:
Originally Posted by OBP View Post
You should find the last line of actual data and highlight (select) all the rows below it to the bottom. On the main menu select Edit>Delete and delete all the rows and then save it.
Close the workbook, reopen and check it.
I think the same should be done for columns too!
blujein's Avatar
blujein blujein is offline
Member with 158 posts.
THREAD STARTER
 
Join Date: May 2008
Location: Australia
Experience: Advanced
23-Jul-2008, 08:07 AM #7
That's actually seemed to make it worse - as there are now more empty pages.

I've uploaded the document (I've had to change it from a Microsoft Excel 2007 to a Microsoft Excel 1997 - 2003 compatible file - so if there are formatting problems, that's why) in the hopes that someone will be able to have a look and tell me how to correct the problem.

In the attached file, you can see the problem within the 'CD (Albums)', 'CD (Singles)' and 'DVD (Music') tabs.
Attached Files
File Type: zip Media Collection (Compatible Version).zip (64.5 KB, 128 views)
jimr381's Avatar
Computer Specs
Member with 4,175 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
23-Jul-2008, 08:17 AM #8
Do CTRL+END on your keyboard. Delete the rows or columns up until you reach your actual data, by right-clicking on the selected rows and selecting delete from the context (right-click) menu. Do not hit delete on your keyboard because this just deletes the data. The errant cells could have formatting or other issues in place and that is why it is trying to print them out.
blujein's Avatar
blujein blujein is offline
Member with 158 posts.
THREAD STARTER
 
Join Date: May 2008
Location: Australia
Experience: Advanced
24-Jul-2008, 05:23 AM #9
Still no luck, unfortunately.

Any other ideas?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
24-Jul-2008, 06:50 AM #10
blujein, as I can't download attachments at the moment, I have private mailed you my email address, can you send me the Workbook please?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
24-Jul-2008, 06:59 AM #11
blujein, the reason that the "Delete" rows was not working for you was because you are not showing Row and Column Headings. So you are not selecting all the "Rows" below your data. I have deleted the extra rows.
Attached Files
File Type: zip Media Collection (Compatible Version).zip (44.0 KB, 308 views)
EAFiedler's Avatar
Moderator with 13,763 posts.
 
Join Date: Apr 2000
Location: Indiana
24-Jul-2008, 07:08 AM #12
Quote:
Originally Posted by OBP View Post
blujein, the reason that the "Delete" rows was not working for you was because you are not showing Row and Column Headings. So you are not selecting all the "Rows" below your data. I have deleted the extra rows.
And notice how removing the extra rows and columns slims down the size of the workbook.
blujein's Avatar
blujein blujein is offline
Member with 158 posts.
THREAD STARTER
 
Join Date: May 2008
Location: Australia
Experience: Advanced
24-Jul-2008, 08:41 AM #13
Oh right - I see what you mean! I think it's all working the way I want it now!

Thank you very much for all of your help!
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 ↑