Printing

beeleesw

New Member
Joined
Mar 3, 2003
Messages
4
Suddenly Excel prints 57 pages...First the active sheets, then blanks. Anyone know how to correct this?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Check for the following:
Formats that extend over entire Columns, (65536 rows) or entire Rows, (256 columns).
Formula that reference entire rows or columns.
These may extend the used range of your worksheet far beyond the data.
If you hit Ctrl-End, what cell is selected?
Is it lower than expected?
Delete the extra Rows and Columns, save your workbook and check again.
 

debooo

Board Regular
Joined
Nov 2, 2006
Messages
86
select view and then page break preview, i bet there are a lot of pages. go to the bottom and drage the blue lines up to where your data ends, it happens to me a lot
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,160
Messages
5,768,530
Members
425,480
Latest member
br400821

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top