Formatting Cell To Display Value Instead Of Formula

D

derek_m_taylor

The worksheet I am working on is actually used to input required data into
another worksheet. I don't want to just simply copy and paste the cells that
are needed because they contain a formula. Is there a way to format the
cells so the total is displayed vice the formula?
 
R

Richard O. Neville

In Tools-Options View tab, there is a checkbox for formulas. You can create
a copy of the sheet you are working on, and check this box to show the
formulas, or clear it to show values.
 
D

derek_m_taylor

I figured it out shortly after I posted, all I did was right click and select
paste special, choosing show value under the options.
 
Top