Email:      Pass:    Pass?

Free Excel Forum

Cant Delete Blank Pages

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have a spreadsheet that when I go into print preview there are 59 pages. I
did not create the spreadsheet. However, there is only something on 3 of
those pages. How to I delete all of these extra pages.

Thanks very much for any help. I am using Excel 2003


Similar Excel Video Tutorials

Helpful Excel Macros

Print Specific Pages in Excel
- This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 pag
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Print all Embedded Charts in the Entire Workbook
- This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within
Delete Rows in Excel if Completely Empty
- This macro will delete only completely blank rows in an excel spreadsheet. It allows you to make a selection of rows, ru
Delete Blank Rows in Excel
- This is a macro which will delete blank rows in excel. This version will delete an entire row if there is a blank cell

Similar Topics

i have created some graphs and when i 'page break preview' them they fit nicely on 3 pages. However when i print it / print preview it, 2 blank pages appear.

Im usually quite good with excel but this is really puzzleing me and my colleagues. I have check for hidden rows, pages breaks but nothing seems to delete the blank pages.

Can anyone help? Thanks

I'm kind of new to Excel and what i do know is self taught. I've created a spreadsheet of several pages which is a price list. I've split the pages (so it's A4 size but split into two so when it's printed it will be folded in half to create an A5 size booklet). My problem is i want to number the pages so a contents page can be include. When i go to print preview it shows 55 pages. How do i delete the blank pages i don't want. I tried just deleting rows but that doesn't seem to work. Can anyone help?

Hello all!

Please see the attached .xls file, I need to get rid of the extra blank pages where there is only the vertical page break... when I go on print preview I get 4 pages but I just need the 2 pages where there is the actual data... I know it appears trivial but I didn't manage to find a solution.

Please help!


I am trying to work out why when I print the attached excel spreadsheet it prints two extra blank pages.

I have done a print preview on the file and it print previews two extra blank pages.

When I print to paper or PDF it also adds two extra pages - see the attached PDF... half way through the last page there is some some of cursor on the screen.

Is anyone able to help me with this?

I have a price list that is 24 pages.. but when someone prints it there are
extra balnk pages at the end (total of 48 pages). What do I need to do to
eliminate those blank pages?

I would like to remove only the text from the following cells.
Any idea on how i would do that without getting rid of the first 8 numbers. After the first 8 the rest of that data is junk.

Thanks for all the help this site is awesome.

78352248 9 PAGES
78352251 11PAGES
78354122, 21 PAGES
78354127, 41 PAGES
78498235, 8 PAGES
78498382, 29PAGES
78498533, 44 PAGES
78498781, 50PAGES
78498791, 39 PAGES
78498962, 7 PAGES
78499079, 48 PAGES
78499235, 43 PAGES
78499530, 41 PAGES
78499885, 36 PAGES
78500048, 31 PAGES
78500154, 23 PAGES
78501535 6 PAGES
78501551 3PAGES
78501552 8 PAGES
78501553 4 PAGES
78501555 2 PAGES
78520946, 31 PAGES
78522488, 32 PAGES
78522900, 31 PAGES
78523229, 20 PAGES
78523542, 30 PAGES
78523826, 30 PAGES
78524363, 42 PAGES
78525490, 21 PAGES
78525690, 29 PAGES
78526551, 29 PAGES

I have an Excel document that I use each month. The data covers about 10
pages each month but somehow along the way thhe document has grown to be
about 300 pages. That is, there's nothing on about 290 pages but if someone
starts to print the whole document, 300 pages begins to print.

How can I delete these excess blank pages?

Thanks, Richard

I keep having to format reports for my boss in excel and when I go in to page setup and change certain things, such as margins etc.. It creates extra pages and when I go to print preview I have to scroll up to get it to pull it to the appropriate number of pages. For example: I had a document that I changed to Landscape and changed the margins. When I did that it created like 20 extra pages and I had to hold the left pointer down at the bottom of the pages and scroll all the way up (very slowly I might add) to get it to show only the couple of pages I needed. The question is: Is there any easier way to do this?? HELP !!

Dear Excel Users,

First of all I am not sure whether should I put this thread under the programming section because I feel that it has got nothing to do with programming. Mods: Feel free to move this thread if it is not in the appropriate section, thank you.

Computer configuration:
Office 2003 SP2

I have a 3 pages template, the first 2 pages consist of only words while the third one has a chart in it. After running through my java program, it will create X number of pages and each pages will have a chart. When I opened the file and look at it, there are only 14 pages (the side scrollbar stopped at pg 14). However, when I tried the Print Preview, it showed 22 pages. Pages after 14 just consist of blank page.

After trying a lot of things I found out that it's the problem with the charts generated by the codes. Because after I removed all of them, the Print Preview showed the correct pages (14). According to my knowledge, adding a chart will not automatically add rows right?

FYI, the chart is 17 rows high and 10 columns wide. Adding a chart will add in additional 2 blank pages when I did a Print Preview.

Any ideas what's wrong or is there any settings that I can set to prevent this? Thanx in advance!


I have a workbook with six sheets. Four of these sheets behave quite

However, one sheet, which should print on onto two pages, shows four pages
in Print Preview. The extra (unwanted) two pages have a continuous line down
the left hand side. No matter what I do I cannot get rid of this line. It
appears like a border but deleting all borders, highlighting all the cells
and deleting them and checking in Format/Cells/Borders shows nothing.

The other rogue sheet should should print on only two pages but shows six
pages in Print Preview. The last four are completely blank except for one
(Page 5) which has a couple of entries that mean nothing. No matter what I
do I cannot delete these rogue entries. I have unlocked all cells and the
sheet is Unprotected. The last sheet of these six shows nothing.

In both cases I have highlighted all cells below the legitimate entries
across double the width of the page and below by at least ten pages before
hitting "Delete".

Has anyone had this experience and resolved it that can help me?



Simple question..... with mazbe a possible answer.

At my internship they have an excel spreadsheet that will print as 56 pages. They want it to print in 8 pages. Preferably in 2 pages high 4 wide. I tried to specify it in the print setup... but it only makes the printed part of the pages smaller, therefor making it 117 printited pages, then alot of cutting, taping and puzzling.

Is there any way I can specify this without having to reformat the whole spreadsheet.

I know you probably will not be able to read it but this is how they want it.

I have a long spreadsheet with lots of tables and charts in it.

I am in Page Break Preview, and it wont let me drag the blue bar any further down!
It apparently stops at 25 pages.

What is going on? Cant I print more than 26 pages high?

I am using Excel 2003.


I have a spreadsheet that has 50 named ranges on a workskeet. Each range equates to a printed A4 page. All these sit vertically down the page. I have the print areas set-up for each "page" so when you print, great, you get 50 pages.

Now then. I now need to be able to show and hide ranges, hence "pages". I have created a quick index page, with checkboxes, so the user checks or unchecks the pages required, and the corresponding range is shown or hidden.

This works well. Problem is when I go to print, I still get a blank page for all the hidden pages. If the users have selected say pages 4, 15 and 25... the pages are still labeled as this in the print preview.

How can I control this.


Is there a way to send a print job for an entire workbook without any blank pages coming out of the printer?

For instance, suppose my pages numbers are labeled from top to bottom and then from left to right. Suppose also that I have text on pages 1, 3 and 4, and that page 2 is blank and is below page 1, and pages 3 and 4 are to the right of pages 1 and 2 respectively. If I just go to File, print, and hit enter, all 4 pages are printed, including the blank page #2.

Thanks for any help.


I've never encountered this before. Let me preface that I am a 20+ year user of Excel. Currently using Excel 2007.

I have 43 pages set up to print which encompasses 75 rows and 271 columns (I am using Page Break Preview when viewing the spreadsheet). Whenever I attempt to print, or review with Print Preview, only 37 pages are generated (through column #244).

There is no print area defined (only print titles). Any ideas? Thanks.

I have a 2 page excel document but when I check the print preview it shows 5 pages. How do i delete a blank page 2, 4 & 5?

I have a excel sheet that i use to enter data into, however when it goes over 5 pages it won't print those pages e.g.

I start with maybe 250 rows over 5 pages and then if i need more i insert new ones to accommodate the extra data maybe going up to 400 rows and 8 pages. However when i go to print it, the extra 3 pages don't print. I have to go into the page break view and drag it down to get the next few. Is there anyway to set it so it does it automatically. Help please!!!

I have VBA code which sets a print area but for some reason the printpreview tacks a couple more pages on the bottom (Ive tried palying with the pages breaks and it still does it).

Is there a way , apart from setting a print area, to limit the printed pages to, say,only pages 1-5 of the 10 shown on the print preview ?


I have made up a spreadsheet on Excel and I have added a dotted line down the middle to seperate 2 different parts. However, when I have added the line, it has increased my number of pages from 1 of 1 to 1 of 1726.

I know I can overcome this when printing by just selecting print page 1 of 1, but is there a simple way I can delete the 1725 extra pages from my sheet?

Thanks in advance

On my worksheet when I Print Preview there are currently 10 pages of output.
Rows to repeat (at top) are set as $2:$4.

In Pages 1 to 3 I'de like cell B2 to be 1; On Pages 4 to 6 I'de like cell B2 to become 2; then Pages 7 to 9 B2 to become 3; Finally on Page 10 B2 = 4.

How can I recalculate cell B2 after every 3 pages so the printout reflects this change? I know this can only be done in VBA. Anyone ever done anything like this?

There may be a simple explanation for this, but I have had this problem repeatedly over the years:

I create a worksheet, and only 4 pages have anything on them, but if I print it, it prints 8 pages! I can use Edit\Clear\All for nearby columns, etc, and it STILL prints 8 pages!

It seems that there is something in Excel that tacks on adjoining pages. I can CLOSE the Excel application, re-open the file, and THEN it prints 4 pages. This annoys the cr*p out of me.

Anyone know why this happens, and why I cannot get it to print properly without closing the application? Any help is most welcome. Thanks!


How to print odd pages and even pages seperately. For ex I have 100 pages
with page numbers customized to read "001" upto "100" and I want to print all
"Even pages" first then at the reverse side I want to print all "odd pages".

How to complete this task in two setp printing.

In Excel 2003, I have a file that has 3 pages. When I print the pages the header shows up on all three pages.

Is there a way to make the header only print on the first two pages and not on the third page?


I am a new excel user and have vista. I am not able to figure out how to delete excess pages that have appeared in my document. I have a document that has a header & footer, and the document is 1 page. Yet when I go to print it says I have 16 pages and the header & footer print on the other 15 pages. Any clues or ideas please??


I'm sorry you to trouble you all with a novice question but...

I have a worksheet that has 1254 pages. I will rarely be needing to print all of the pages. When I do print a range of pages, I need the footer to say "Page 1 of (how many pages I choose to print)".

For instance, if I print 515 pages, I will need the footer to read "Page 1 of 515, Page 2 of 515, Page 3 of 515, and so on".

So far, I've only been able to get Excel 2003 to say "Page 1 of 1254, etc..."

Any suggestions would be greatly appreciated.