Non printing text

Mocha Bill

New Member
Joined
Oct 16, 2002
Messages
5
Is there a way to format a cell so data can be entered in it but the entry won't be printed?

Yes I'd like to keep the cell in an area that would normally be printed. And I'd want to do it without having to protect the worksheet.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
You can enter a value in a cell, but, if you set the font to white (Or your background color) it won't show... that should meet all your conditions.
 
Upvote 0
This line of code prints out every Cell but Cell "B2" in Range("A1:H22").

ActiveSheet.PageSetup.PrintArea = "$A$1:$H$1,$A$2,$C$2:$H$2,$A$3:$H$22"

In Case Juan´s thing didn´t satisfy you . . .
 
Upvote 0
That most certianly will not print but it does make it hard to know which cell in which to enter data.

A better why to explain this is a MS Word format example: With Word you can enter a piece of text then go to the font format and choose the hidden option. This leaves the text visible but it won't print.
 
Upvote 0
On 2002-10-17 00:32, Mocha Bill wrote:
....A better why to explain this is a MS Word format example: With Word you can enter a piece of text then go to the font format and choose the hidden option. This leaves the text visible but it won't print.

Actually, the text on screen will also be hidden (Well, ok, you can check the "Hidden text" option in Tools | Option, but, the text should not display by default)
 
Upvote 0
To hide zero values or other data in selected cells

1 Select the cells that contain zeros (0's) or other values that you want to hide.
2 On the Format menu, click Cells, and then click the Number tab.
3 In the Category box, click Custom.
4 To hide zero values, type 0;-0;;@ in the Type box.

To hide all values, type ;;; (three semicolons) in the Type box.

The hidden values appear only in the formula bar, or in the cell if you edit within the cell. The values will not be printed.

Tip To display hidden values again, select the cells, click the Cells command on the Format menu, and then click the Number tab. In the Category box, click General to apply the default number format. To redisplay a date, a time, or values that have a specific number format, select the appropriate date, time, or number format on the Number tab.

HTH
BigC
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top