Printing too much!

  • Thread starter Thread starter Tavish Muldoon
  • Start date Start date
T

Tavish Muldoon

Hello,

I printed a spread sheet - it came out to 40 pages, but only 20 of the
40 pages had data.

How do I set Excel to only print rows and columns with data - not the
empty cells?

I just hit the print button and it did it all.

Thanks,

Tmuld.
 
Either set the print area or delete (not clear-DELETE) the un-needed rows
and SAVE. Try again.
 
Tmuld

Always a good idea to set your Print Range, Margins and Scaling.

File>Set Print Area

File>Page Setup>Page and Margins tabs.

If your "empty cells" are complete rows, you can hide these or filter them out
before printing

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel, how do I print the cell blocks as well as the data? 2
Big print job created 1
I trying to develop a macro to print my worksheets 1
Blank Sheet with Gridlines 11
Printing 1
Excel VBA - Problem with Closing Print Preview 0
not printing grouped columns 2
Printing multiple sheets... 1

Back
Top