hidden data keeps printing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mina - 05 Aug 2004 21:02 GMT

I have a table that was created by someone else in the office. Instead of
deleting rows not needed anymore, they just hid them. When I want to print
the table all the hidden rows get printed, and there's no way I can manually
unhide them again (nor tell which ones were hidden), they're scattered all
over the table, and there's more than a thousand of them!
I'm creating a completely new table, but it takes a lot of time to enter all
that information again, in the meanwhile I have to manage with this one, and
it happens to be one of the most important ones in the office.
thanks,
mina

Reply to this Message

Paul Cundle - 05 Aug 2004 23:49 GMT

Pure guess (because it all sounds a bit weird): have you looked in the VB
Editor to see if there are any macros doing stuff in the background? Look in
"ThisWorkbook" for something along the lines of "Workbook_BeforePrint()"

If you're not sure what I mean, ask again. If you know that this isn't the
problem then I don't think I can help. I'm guessing you've already asked the
creator of the file if there is anything working in the background, but it's
worth a try.

Paul C,

Signature

> I have a table that was created by someone else in the office.
> Instead of deleting rows not needed anymore, they just hid them. When
[quoted text clipped - 8 lines]
> thanks,
> mina

Reply to this Message

Gord Dibben - 06 Aug 2004 00:33 GMT

mina

First of all, hidden rows should not show up when printing.

Second, have you tried Edit>Go To>Special>Visible cells>OK.

Then copying those cells(rows) to another worksheet for printing?

BTW, to unhide all rows just hit CRTL + A and right-click "Unhide"

Gord Dibben Excel MVP

>I have a table that was created by someone else in the office. Instead of
>deleting rows not needed anymore, they just hid them. When I want to print
[quoted text clipped - 6 lines]
>thanks,
>mina

Reply to this Message

mina - 06 Aug 2004 14:15 GMT

just wanted to say thanks for the replies.

there are no macros in the sheet, and i have copied the visible cells to a
different worksheet,
and i can't wait for the new workbook to be ready!

but i'm still curious... why did it happen?
thanks once again
mina

> I have a table that was created by someone else in the office. Instead of
> deleting rows not needed anymore, they just hid them. When I want to print
[quoted text clipped - 6 lines]
> thanks,
> mina

Reply to this Message