Excel97: printing too many pages

Topic

New Reply

Hi all,

I’ve recently altered a workbook that we use to record statistics. The main office changed their form, so we, of course, have to follow along.

Anyway, I have some worksheets that are formatted to be printed as reports. Each report fits on just one page. Now, however, the Excel wants to print *8* pages — the report page itself, and then seven blank (other than the header) pages after that. I don’t understand why it’s doing this. The report fits in the print area for one page — so why does it want to print eight?

Any insights gratefully accepted.

Reply | Quote

Replies

Anthony,

Your problem is probably caused by the inadvertent insertion of a character in a cell outside the work area. Even a blank space can cause this problem.

You can do 2 things, either of which should help :

1. Set the Print Area to include only the area you want printed.

2. Select all Cells beneath the Print area and clear them and then repeat for all cells to the right.

Hope that works for you,

Andrew C

Reply | Quote

Just like to point out that if you select the row beneath the last row, then press Shift-End then still holding Shift press the cursor down (down arrow) and all the rows to the last are selected, so you simply press delete (or right click, Delete). The same operation can be performed on columns, repalcing the down arrow with the right arrow (or left).

I think both procedures are the same, unless I am missing something.

AC

Reply | Quote

My thanks to both of you — it worked!
Though how I wound up with an active cell in IU 41 –this is a small report– I have no idea.

Thanks again,

Reply | Quote

We have a similar problem in that Excel seems to think the worksheet is full. We wanted to insert a row, but got a message saying “cannot shift non-blank cells off the worksheet”. When we try to delete even one row (either the first supposed-to-be empty row or the last one), we get an hour glass for many minutes. We think the highest cell is K200. There are 5 sheets, all with links to this sheet.

The last person who worked in the spreadsheet does not know Excel very well and does not know what he’d have done to cause this problem. Would clicking the inside border button cause all the cells to be occupied? I suggested he do that when he wanted cell borders. I hope that didn’t cause this.

We tried copying the cells we wanted to a new sheet, but all the references screwed up.

Reply | Quote