How do I prevent a text box from printing in XL2007?

A

AndrewR

In XL2003 I could put a text box on a chart and mark it to NOT print with the
chart. Having upgraded to XL2007 I can't find how to do that and previous
(2003) spreadsheets that had non-printable text boxes now print those boxes
in XL2007.

Can anyone help, please?
 
B

Bernard Liengme

Right click the txt box; select fro popup menu "Format Shape"
In left hand panel; select "Properties"
In lower half of dialog, uncheck "Print Object"
best wishes
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
 
A

AndrewR

Bernard,

Thank you for your reply. That is certainly true when I place a text box on
a worksheet but when it is on a chart the "Print Object" option is not
available; not greyed out, just not there.

Andrew
 
B

Bernard Liengme

Is the text box 'grouped' to the chart?
If so, it is treated as part of the chart
best wishes
 
A

AndrewR

Bernard,

It is not grouped to the chart. If I create a text box on a worksheet I see
the "Print Object" checkbox; if I cut it and paste it to the chart that
option is gone. Put it back on the sheet and it's there. It certainly appears
that this functionality has been removed in going from XL2003 to XL2007.
 
B

Bernard Liengme

I followed what you did: cut and paste a text box to a chart
I agree that the Print boxes have disappeared in the Properties dialog of
Format Shape
However, this method also groups the box and the chart - if I move the chart
the box moves with it so they are grouped
If I use the command Insert | Text box and draw the box over the chart, then
I get a box that is not grouped and I can set the print properties. Note
that the chart must NOT be selected before you draw the box as this will
group the two.
best wishes
 
B

Bernard Liengme

I should also have said: rather than cut & paste the text box into chart,
you can also drag the box over the chart, and the two will not be grouped.
best wishes
 
A

AndrewR

Bernard,

Thanks for your help. I think I see my problem; I have created the chart on
a separate sheet, rather than on the data sheet. I copied my chart to the
data sheet and, sure enough, I can put a text box on it. However, I still
can't move the chart AND the text box to a new sheet, so I will have to find
out how to work with it on the data sheet. Probably not a problem but it's
annoying that I could do this in 2003 but not now. Oh well, never mind.

Again, thanks.
 
Joined
Mar 25, 2015
Messages
1
Reaction score
0
Don't know how many hours I used up trying to find the answer to the one Andrew asked in 2010, thought I was onto a winner with Bernies answer? that option is not available in XL2007.
This is where I eventually found the answer which is probably somewhere else online but hey, I ended up here as well so here goes for someone else like me who couldn't find the answer either.
Right click on the text object box, then click on size and properties, then click on properties tab then uncheck the print object check box.
When I print preview it doesn't show. Yay :)
Note: I just did a double check and noticed that when I right clicked inside the text box again the selection wasn't there, so I moved my cursor around the check box and kind of on the edge until the 4 arrows show on your cursor then right clicked and hooray there it was.
 

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

Top