How can I remove Formula across WorkSheets is showing as a "0" (Ze
 

I am creating a form in Excel that can be filled out by any user, and the
data entered by the user on the first page should be automatically shown on
subsequent pages so that the user doesn't have to reenter the data over and
over.

I created this process by going to each subsequent page (other than page
one), typing an = sign where I want to replication, then clicking on the tab
for Worksheet #1 and clicking on the cell I want to replicate. I hit the
ENTER key, a voila, the formula is set.

What I don't want, is to show zeros where I have placed formulas in cells on
the subsequent pages. Because some of the formulated cells require numbers,
or X's in checkboxes, it might get confusing to show on check box with an X
and others with a Zero.

Is there a way to have Excel NOT show the zeros in these cells on subsequent
pages, and just show blank cells?

Oh, I neglected to mention that I am protecting (and locking) the
non-fillable cells in the workbook, including those cells that should be
automatically filled by the formula above. Not sure if this matters, but
thought I should include it nevertheless.

Thanks!!

How can I remove Formula across WorkSheets is showing as a "0" (Ze
 

I do that from time to time and have found that by using the conditonal
format function and setting the the conditions to change the text color to
the background color for a given condition to work well.

"minnie_mo" wrote:

I am creating a form in Excel that can be filled out by any user, and the
data entered by the user on the first page should be automatically shown on
subsequent pages so that the user doesn't have to reenter the data over and
over.

I created this process by going to each subsequent page (other than page
one), typing an = sign where I want to replication, then clicking on the tab
for Worksheet #1 and clicking on the cell I want to replicate. I hit the
ENTER key, a voila, the formula is set.

What I don't want, is to show zeros where I have placed formulas in cells on
the subsequent pages. Because some of the formulated cells require numbers,
or X's in checkboxes, it might get confusing to show on check box with an X
and others with a Zero.

Is there a way to have Excel NOT show the zeros in these cells on subsequent
pages, and just show blank cells?

Oh, I neglected to mention that I am protecting (and locking) the
non-fillable cells in the workbook, including those cells that should be
automatically filled by the formula above. Not sure if this matters, but
thought I should include it nevertheless.

Thanks!!

How can I remove Formula across WorkSheets is showing as a "0"
 

WavMaster

You could gototoolsoptionsview and remove the check mark from "Zero Values"

Mike Rogers

"WavMaster" wrote:

I do that from time to time and have found that by using the conditonal
format function and setting the the conditions to change the text color to
the background color for a given condition to work well.

"minnie_mo" wrote:

I am creating a form in Excel that can be filled out by any user, and the
data entered by the user on the first page should be automatically shown on
subsequent pages so that the user doesn't have to reenter the data over and
over.

I created this process by going to each subsequent page (other than page
one), typing an = sign where I want to replication, then clicking on the tab
for Worksheet #1 and clicking on the cell I want to replicate. I hit the
ENTER key, a voila, the formula is set.

What I don't want, is to show zeros where I have placed formulas in cells on
the subsequent pages. Because some of the formulated cells require numbers,
or X's in checkboxes, it might get confusing to show on check box with an X
and others with a Zero.

Is there a way to have Excel NOT show the zeros in these cells on subsequent
pages, and just show blank cells?

Oh, I neglected to mention that I am protecting (and locking) the
non-fillable cells in the workbook, including those cells that should be
automatically filled by the formula above. Not sure if this matters, but
thought I should include it nevertheless.

Thanks!!

How can I remove Formula across WorkSheets is showing as a "0" (Ze
 

=IF(Sheet1!A1="","",Sheet1!A1)

Or just go to ToolsOptionsView on each sheet and uncheck "Zero Values"


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 20:37:36 -0800, minnie_mo
wrote:

I am creating a form in Excel that can be filled out by any user, and the
data entered by the user on the first page should be automatically shown on
subsequent pages so that the user doesn't have to reenter the data over and
over.

I created this process by going to each subsequent page (other than page
one), typing an = sign where I want to replication, then clicking on the tab
for Worksheet #1 and clicking on the cell I want to replicate. I hit the
ENTER key, a voila, the formula is set.

What I don't want, is to show zeros where I have placed formulas in cells on
the subsequent pages. Because some of the formulated cells require numbers,
or X's in checkboxes, it might get confusing to show on check box with an X
and others with a Zero.

Is there a way to have Excel NOT show the zeros in these cells on subsequent
pages, and just show blank cells?

Oh, I neglected to mention that I am protecting (and locking) the
non-fillable cells in the workbook, including those cells that should be
automatically filled by the formula above. Not sure if this matters, but
thought I should include it nevertheless.

Thanks!!