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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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.
 

Sbirro Cornuto

Board Regular
Joined
Mar 18, 2002
Messages
93
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 . . .
 

Mocha Bill

New Member
Joined
Oct 16, 2002
Messages
5
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.
 

Sbirro Cornuto

Board Regular
Joined
Mar 18, 2002
Messages
93

ADVERTISEMENT

Wouldn´t you know the Cell, if you´re the one Settin up the PrintArea?
 

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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)
 

BigC

Well-known Member
Joined
Aug 4, 2002
Messages
851
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
 

Forum statistics

Threads
1,144,061
Messages
5,722,287
Members
422,420
Latest member
losc

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
Top