Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
HT
 
Posts: n/a
Default Formula values only

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.


  #3   Report Post  
RagDyeR
 
Posts: n/a
Default

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" wrote in message
...
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.



  #4   Report Post  
HT
 
Posts: n/a
Default

Thank you Don and Rag. :)


"RagDyeR" wrote in message
...
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" wrote in message
...
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.





  #5   Report Post  
Don Guillett
 
Posts: n/a
Default

we're glad to help

--
Don Guillett
SalesAid Software

"HT" wrote in message
...
Thank you Don and Rag. :)


"RagDyeR" wrote in message
...
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" wrote in message
...
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.







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating an EXCEL COUNTIF formula for a range of values Pat Walsh Excel Discussion (Misc queries) 5 January 21st 05 03:57 PM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 02:04 AM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 10:04 PM
Generating Correlated Random Values in Excel Randy Excel Discussion (Misc queries) 2 January 16th 05 10:50 PM
Formula for Searching & matching two values in excel Chris Excel Discussion (Misc queries) 1 January 7th 05 05:34 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"