ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to have result of excell formula remian as if inputed (https://www.excelbanter.com/excel-discussion-misc-queries/144233-how-have-result-excell-formula-remian-if-inputed.html)

jim miller

how to have result of excell formula remian as if inputed
 
having made a spreadwheet with formula. results are reflected. how to kave
the result follow when copying and posting worksheet to another workbook as
if the results was initially inputed.

Dave Peterson

how to have result of excell formula remian as if inputed
 
I _think_ that you'd want to
Edit|Copy the cell
select the new location
Edit|Paste special|Values

But the formula won't be pasted--just the results of the formula.

jim miller wrote:

having made a spreadwheet with formula. results are reflected. how to kave
the result follow when copying and posting worksheet to another workbook as
if the results was initially inputed.


--

Dave Peterson


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com