Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-27-2022, 02:03 AM
Joanne Joanne is offline Excel printing blank pages Windows 7 32bit Excel printing blank pages Office 2010 32bit
Advanced Beginner
Excel printing blank pages
 
Join Date: Jul 2013
Posts: 58
Joanne is on a distinguished road
Default Excel printing blank pages

Good morning



I have a 34-page spreadsheet I am trying to print. Print preview shows 68 pages, 34 of which are blank. I have deleted all the blank rows beneath and columns to the right but it still shows 34 blanks. When I press CTRL + END the cursor does go to the correct cell, the last one on my spreadsheet. How do I correct this, please?

Thank you.
Reply With Quote
  #2  
Old 04-27-2022, 03:25 AM
ArviLaanemets ArviLaanemets is offline Excel printing blank pages Windows 8 Excel printing blank pages Office 2016
Expert
 
Join Date: May 2017
Posts: 703
ArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to allArviLaanemets is a name known to all
Default

It looks like you have those 34 pages either vertically or horizontally, and for some reason the printing range has either additional column or row included. There may be several reasons for this:
a) You have additional column/row immediately at right/below of your table formatted with some format;
b) You have set a border for column/row immediately at right/below of your table;
c) You have a space entered into some cell immediately at right/below of your table;
d) In case you pages are placed horizontally and you use a footer, the height of footer is too much, and it doesn't fit into page;
e) ... (I'm sure there will be more!)

To check, you can use print preview. after you used it, the page breaks are displayed in Excel sheet as dashed lines.

To remove formatting of space issues, select a block of rows/columns adjacent to your datarange on sheet, and delete selection(s). When you use footer, you can try to make it's height lesser.
Reply With Quote
  #3  
Old 04-27-2022, 07:03 AM
rollis13's Avatar
rollis13 rollis13 is offline Excel printing blank pages Windows 10 Excel printing blank pages Office 2016
Advanced Beginner
 
Join Date: Jan 2021
Location: Cordenons
Posts: 89
rollis13 is on a distinguished road
Default

Hi to all.

e) Maybe you have set a PrintArea bigger than needed.
Reply With Quote
  #4  
Old 05-03-2022, 05:24 AM
Joanne Joanne is offline Excel printing blank pages Windows 7 32bit Excel printing blank pages Office 2010 32bit
Advanced Beginner
Excel printing blank pages
 
Join Date: Jul 2013
Posts: 58
Joanne is on a distinguished road
Default Excel printing blank pages

Thank you both, but nothing worked. It is part of a larger file that I save under another name, amend and print. In the end I deleted it, tried again and the extra pages had disappeared. Bizarre!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting or Printing from MS Word to PDF - adds blank pages Swarup Word 10 11-08-2018 12:37 PM
Layout issue with Excel, creating blank pages ShankedS Excel 4 04-10-2017 04:37 PM
Excel printing blank pages Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
Added page numbers and now printing unwanted blank pages. galvax Word 2 12-18-2013 08:41 PM
hidden blank pages mljm Word 3 06-19-2009 03:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft