ExcelBanter - Reduce # of pages

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Reduce # of pages (https://www.excelbanter.com/excel-discussion-misc-queries/31072-reduce-pages.html)

CDAK

Reduce # of pages

Currently when I click print preview, it says page 1 out of 10000000. It is
just trying to print a million blank rows after my rows that actually contain
data. I know I can just select the pages I want to print but is there a way
to fix this so it only tries to print the rows with data and not 60 million
blank rows after my rows, that contain data?

Ron de Bruin

Hi CDAK

See
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards Ron de Bruin
http://www.rondebruin.nl

"CDAK" wrote in message ...
Currently when I click print preview, it says page 1 out of 10000000. It is
just trying to print a million blank rows after my rows that actually contain
data. I know I can just select the pages I want to print but is there a way
to fix this so it only tries to print the rows with data and not 60 million
blank rows after my rows, that contain data?

All times are GMT +1. The time now is 05:51 PM.