Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

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


View Answers     

Similar Excel Tutorials

Delete All Empty Rows or Blank Cells from a Range in Excel
How to quickly delete all empty cells or rows from a range in Excel.  This allows you to quickly clean your data to ...
How to Add, Remove, and Rearrange Columns and Rows in Excel
Adding, removing and rearranging columns is as easy as resizing. You just select your columns or rows, right click ...
Delete All Rows that Contain a Specific Value in Excel
Quickly find all rows in Excel that contain a certain value and then delete those rows. This is a simple technique ...
Find the Next Blank Row with VBA Macros in Excel
Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This method will skip any blanks ...

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

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 ?

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.


I have an Excel 2007 file that should be around 8 pages long. When I go into Page break mode it is broken in 72 pages. I have inserted NO page breaks. I have used reset all page breaks, that has not helped. It will not allowe me to manually adjust or delete these breaks. When I view the document in Print Preview it shows a modified version of page 1 on all 72 pages and no other information.

I have never seen this before..... HELP??

I am trying to print an excel workbook and it keeps printing blank pages between certain worksheets. I have checked all the formatting to see if what is causing this issue and I can't see why it is doing this.The blank pages all have a 1/2" line on the left hand top corner of the page.

I have a spreadsheet where I have unit sizes in place based on page sizes. eg. 48 pages, 24 pages, 12 pages, 8 pages located in cells A2, B2, C2 and D2. I want to be able to sum the total of these columns based on the number of units in each column. So if 48 pages has 1 unit, 24 pages has 0 units, 12 pages has 0 units and 8 pages has 2 units the sum would be 48x1 +24x0 + 12x0 + 8x2 = 64.
I have worked this out for each row as =SUM(A3*A2,B3*B2,C3*C2,D3*D2) but there are 80 rows and I was wondering if there was a simpler method. I have embedded an image to help illustrate the spreadsheet.


Kindest regards