Printing certain cells on a page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eppie - 06 Feb 2005 14:01 GMT

I am working in a hospital and am trying to create a spreadsheet into which I
can enter a patients blood results. Each patient will have their own
spreadsheet and everyday an extra column will be added containing that days
test results.

Everyday, I will have to print out an updated sheet of the test results, the
problem is this will amount to a huge wastage of paper (e.g 20 patients, so
printing 20 sheets a day, over 5 days = 100 sheets). To save on A4 paper, it
would be useful to be able to reprint on the same piece of paper, just adding
the column of that days test results (ie. refeed the same piece of paper
through the printer everyday).

If I highlight the column I want to print and specify "Set print area", when
I print the sheet, the column appears on the printed sheet as if it were the
first column of a new table. This therefore makes it impossible to refeed the
same sheeet of paper through the printer. Is it possible to print just a
selection of a spreadsheet, but ensure that the data remains in the same
position on the printed sheet as it does on the spreadsheet?

Any help would be greatly appreciated,

Cheers.

Reply to this Message

Paul Cundle - 06 Feb 2005 16:40 GMT

Interesting question. I can think of several ways, none of which is
particularly friendly. If the columns are all the same width then the
easiest would probably be to hide the columns you don't want and insert an
equal number of columns which are blank. Print the sheet, then revert back.

Another way of achieving the same effect would be to select the columns you
don't want to print, change the font and backgrounds to white, then print
and restore the colours as they were.

Or, you could draw a big white rectangle over the unwanted areas (with no
border) and print with that obscuring the cells underneath.

You could also change the print margins before printing in the way that you
have already tried (selecting the range to print) but this would be quite
tricky.

I can't think of anything better, but if the first option doesn't sound
entirely unreasonable - or the big white rectangle one - then I/we could
guide you in writing a macro which would automate the job. You could then
add a new print button to your toolbar especially for this spreadsheet if
you wanted.

Paul C,

Signature

> I am working in a hospital and am trying to create a spreadsheet into
> which I can enter a patients blood results. Each patient will have
[quoted text clipped - 20 lines]
>
> Cheers.

Reply to this Message

Husky - 24 Mar 2005 01:29 GMT

Same question, different problem.

I've made up a grocery list according to aisle.
columns are

item, on hand, needed, buy, aisle, cost@, total cost

It takes and creates a buy list by subtracting on hand from needed.
The current settings show a few negatives in the needed column and I expect
they will remain negatives for awhile.
To make the list even more readable, I'd like to NOT print those rows-items
that I don't need to pick up.

ie: buy <=0 skip printing this row.

Is this even possible with excel to create a print job with such a formula
built in ?

Signature

more pix @ http://members.toast.net/cbminfo/index.html

Reply to this Message

Gord Dibben - 24 Mar 2005 02:39 GMT

Husky

A better idea is to post your own question under a new subject rather than
piggy-backing on an existing one.

But, while you're here.............

A formula cannot hide rows, it can only return results.

There are a couple of ways you can go.

1. Data>Filter>Autofilter>Custom "greater than or equal to" and enter 0 in
the second box.

Print the visible rows.

2. Use a Before_Print macro in ThisWorkbook that hides the rows with
negatives, prints then unhides.

Gord Dibben Excel MVP

>Same question, different problem.
>
[quoted text clipped - 13 lines]
>Is this even possible with excel to create a print job with such a formula
>built in ?

Reply to this Message

Husky - 24 Mar 2005 04:55 GMT

Simpler to catch those following a similar thread than going off on a tangent
with the same thing. Usually just attracts trolls when they see the same
question 2-3 times in a group.

I tried the filter you posted for same page printing. by modifying A:A to
E2:E45 and the 0 to <=0. But that did nothing that I could see.

>Husky
>
[quoted text clipped - 34 lines]
>>Is this even possible with excel to create a print job with such a formula
>>built in ?

Signature

more pix @ http://members.toast.net/cbminfo/index.html

Reply to this Message

Gord Dibben - 24 Mar 2005 18:31 GMT

>Simpler to catch those following a similar thread than going off on a tangent
>with the same thing. Usually just attracts trolls when they see the same
>question 2-3 times in a group.

>I tried the filter you posted for same page printing. by modifying A:A to
>E2:E45 and the 0 to <=0. But that did nothing that I could see.

First of all, I did not write this, you did.

Second of all, piggy-backing could lead to your post not being bothered with
if posters believe the original post was answered successfully.

Select E2:E45 and then autofilter>custom

<=0 will show the rows with negatives. I thought you wanted them to not
print?

Gord Dibben Excel MVP

>Simpler to catch those following a similar thread than going off on a tangent
>with the same thing. Usually just attracts trolls when they see the same
[quoted text clipped - 41 lines]
>>>Is this even possible with excel to create a print job with such a formula
>>>built in ?

Reply to this Message

Husky - 24 Mar 2005 23:17 GMT

>>I tried the filter you posted for same page printing. by modifying A:A to
>>E2:E45 and the 0 to <=0. But that did nothing that I could see.
[quoted text clipped - 3 lines]
><=0 will show the rows with negatives. I thought you wanted them to not
>print?

Whoever wrote it, the hint worked. I just created a macro using that custom
select >=1.

Signature

more pix @ http://members.toast.net/cbminfo/index.html

Reply to this Message

Rate this thread: