Excel XP
I have a complicated spreadsheet that has many formulas on it. I only want
the values of those formulas to appear. I do not want to click in the cell
and have the formula appear at any time.
Thank you.
Excel XP
I have a complicated spreadsheet that has many formulas on it. I only want
the values of those formulas to appear. I do not want to click in the cell
and have the formula appear at any time.
Thank you.
format cells>protection>locked and hidden checked
then
tools>protection>sheet>protect
--
Don Guillett
SalesAid Software
[email protected]
"HT" <[email protected]> wrote in message
news:OY7pT5x%[email protected]...
> Excel XP
>
> I have a complicated spreadsheet that has many formulas on it. I only want
> the values of those formulas to appear. I do not want to click in the cell
> and have the formula appear at any time.
>
> Thank you.
>
>
You have the choice to hide the formulas, or delete the formulas, leaving
the data behind.
If the formulas are hidden, there is always the possibility that the
protection will be by-passed, and the formulas would be viewable.
If the formulas are deleted, there will be no possibility to calculate or
re-calculate the sheet.
To start either procedure, click in the square to the left of the ColumnA
header and above the Row 1 label.
This selects the entire sheet.
Then,
TO HIDE:
<Format> <Cells> <Protection> tab,
And make sure "Locked" and "Hidden" are *both* checked.
Then,
<Tools> <Protection> <ProtectSheet>,
Enter a password if you wish, then <OK>.
Now, clicking in the cell will *not* reveal the formulas in the
"FormulaBar".
TO DELETE:
After selecting the entire sheet, right click in the selection and choose
"Copy".
Right click again and choose "PasteSpecial".
Click on "Values", then <OK>.
Now, al your formulas are deleted, and the data remains behind>
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"HT" <[email protected]> wrote in message
news:OY7pT5x%[email protected]...
Excel XP
I have a complicated spreadsheet that has many formulas on it. I only want
the values of those formulas to appear. I do not want to click in the cell
and have the formula appear at any time.
Thank you.
Thank you Don and Rag.
"RagDyeR" <[email protected]> wrote in message
news:usmwaJy%[email protected]...
> You have the choice to hide the formulas, or delete the formulas, leaving
> the data behind.
>
> If the formulas are hidden, there is always the possibility that the
> protection will be by-passed, and the formulas would be viewable.
>
> If the formulas are deleted, there will be no possibility to calculate or
> re-calculate the sheet.
>
> To start either procedure, click in the square to the left of the ColumnA
> header and above the Row 1 label.
> This selects the entire sheet.
>
> Then,
> TO HIDE:
> <Format> <Cells> <Protection> tab,
> And make sure "Locked" and "Hidden" are *both* checked.
> Then,
> <Tools> <Protection> <ProtectSheet>,
> Enter a password if you wish, then <OK>.
>
> Now, clicking in the cell will *not* reveal the formulas in the
> "FormulaBar".
>
>
> TO DELETE:
> After selecting the entire sheet, right click in the selection and choose
> "Copy".
> Right click again and choose "PasteSpecial".
> Click on "Values", then <OK>.
>
> Now, al your formulas are deleted, and the data remains behind>
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
> "HT" <[email protected]> wrote in message
> news:OY7pT5x%[email protected]...
> Excel XP
>
> I have a complicated spreadsheet that has many formulas on it. I only want
> the values of those formulas to appear. I do not want to click in the cell
> and have the formula appear at any time.
>
> Thank you.
>
>
>
we're glad to help
--
Don Guillett
SalesAid Software
[email protected]
"HT" <[email protected]> wrote in message
news:eP1nYjz%[email protected]...
> Thank you Don and Rag.
>
>
> "RagDyeR" <[email protected]> wrote in message
> news:usmwaJy%[email protected]...
> > You have the choice to hide the formulas, or delete the formulas,
leaving
> > the data behind.
> >
> > If the formulas are hidden, there is always the possibility that the
> > protection will be by-passed, and the formulas would be viewable.
> >
> > If the formulas are deleted, there will be no possibility to calculate
or
> > re-calculate the sheet.
> >
> > To start either procedure, click in the square to the left of the
ColumnA
> > header and above the Row 1 label.
> > This selects the entire sheet.
> >
> > Then,
> > TO HIDE:
> > <Format> <Cells> <Protection> tab,
> > And make sure "Locked" and "Hidden" are *both* checked.
> > Then,
> > <Tools> <Protection> <ProtectSheet>,
> > Enter a password if you wish, then <OK>.
> >
> > Now, clicking in the cell will *not* reveal the formulas in the
> > "FormulaBar".
> >
> >
> > TO DELETE:
> > After selecting the entire sheet, right click in the selection and
choose
> > "Copy".
> > Right click again and choose "PasteSpecial".
> > Click on "Values", then <OK>.
> >
> > Now, al your formulas are deleted, and the data remains behind>
> > --
> >
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> > "HT" <[email protected]> wrote in message
> > news:OY7pT5x%[email protected]...
> > Excel XP
> >
> > I have a complicated spreadsheet that has many formulas on it. I only
want
> > the values of those formulas to appear. I do not want to click in the
cell
> > and have the formula appear at any time.
> >
> > Thank you.
> >
> >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks