Of course, there is a way.
select the cell which u want to copy, press ctrl+c
select the cell where u want to copy, press alt+e+s+v OR
select the cell where u want to copy, select edit, paste special & click on
values and complete the rest of the procedure
u r at the end of your requirement




"mtcalvaryumc" wrote:

I have a column total in sheet one that I would like to copy on sheet 2.
However, I only want the "total" to copy over, not the formula. Is there a
way to do that?
--
Admin. Asst.