Excel only prints part of page 1

[stevemalee]

When I print a new excel sheet Excel only prints about 3-4 rows.

I have reset the page breaks, etc. and it still prints only 3-4 rows.

This does not happen in Word or in printing old Excel sheets.

Does anyone know why this happens?

Thanks for any help possible.

 

[Gavona]

Perhaps you have set a print area?
Excel 2003: File, PrintArea, Clear Print Area

Gavin

 

[stevemalee]

Thanks Gavona, but I have already done that and it didn't help.

 

[xlbo]

How are you printing?

How many rows would you expect to see?

Does this happebn on all excel files or just the one?

Check your File > PageSetup to see if you have set anything in there

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Gavona]

I used to get that sort of issue printing a complex spreadsheet onto a printer without sufficient memory... but that was years ago.
Does it look ok in print preview?

Gavin

 

[JPaules]

Have you looked at the pages in Page View? Do all of your rows appear in the white area and are your page breaks where you expect them to be? Have you asked anyone else to try printing them?

--
JP

 

[stevemalee]

Thanks Geoff, Gavona and JPaules,

Geoff, when you say how am I printing, what do you mean?
It is printing 5 rows out of 32.
This happens on any new Excel file and just started happening. Old spreadsheets will print even if I change the data.
Paage setup looks OK. It is set at fit to: 1 page wide by 1 tall. I tried to use adjust to: at 100% of normal size and it still didn't print.

Gavona, print preview shows up fine. That is what is so odd about this.

JPaules, yes, the white area and page breaks are as I set them. Will ask someone else to print. I could upload the sheet if you would like.

Thanks for more ideas to troubleshoot.

 

[JPaules]

If you can upload it, that would be great. Which version of Excel are you using?

--
JP

 

[Gavona]

The possibilities seem to me to be related to(in increasing order of likliehood):
Printer Driver
Excel Application
Blank workbook corrupt

Is the problem associated with a single PC?
A single user?
Is the correct printer specified in page setup?


Maybe there is some corruption associated with a particular cell/row in your new files. That could either be in the blank workbook or associated with how you are getting data into your workbook.

Open a new workbook.
Type (don't copy / paste from elsewhere) some data into cells A1 through A20.
One way to do this: Select cells A1 through20, type =row(A1)
Hold [Ctrl] while you press [Enter]

Do you have the problem?
Assuming that the last row that printed was row 5 then:
copy rows 1:4
Select Row 1, Right click, Insert copied cells.
Does printing stop at the same row?
If you do have the problem then tell us exactly what you are doing to create your new blank workbook.

When you create a new sheet or workbook it may* be based on a template file. I wonder if that is in some way corrupt. The templates would have a file extension of xlt. Normally sheet.xlt and workbook.xlt.
If you move any such files from your startup folders then see if the problem persists.

*Whether the new workbook is based on a template depends on exactly how you create it and on what template files you have in several different locations on your pc.


Gavin

 

[stevemalee]

It is a single PC, single user, and correct printer.

I created a new book/sheet as you suggested. It prints the same. When I copy rows 1-4 and insert as you suggested, it still prints only rows 1-5.

I created the new workbook by clicking "Control N."
When I "save as" to find the template, the type is "Microsoft excel workbook." I don't know how to find the *.xlt.

HP digital imaging monitor is only program that I really don’t want in my startup folder.
But, I can never tell which HP programs are required to startup, etc.

Thanks

 

[JPaules]

Upload that file. This is the kind of poser I enjoy playing with\.

--
JP

 

[stevemalee]

It turns out that the sheet prints on another printer so it must be a glitch between Excel and my printer.

Do you still want the upload ?

Or should I contact HP to solve?

Thanks

 

[Gavona]

Re-install the printer driver before spending time with HP. Sounds like we won't be able to replicate the issue so no point in a copy.

Gavin