Thread
:
how do i copy just the data and not the formula in a cell?
View Single Post
#
10
Posted to microsoft.public.excel.misc
Doug Kanter
Posts: n/a
how do i copy just the data and not the formula in a cell?
"Holden Caulfield" <Holden
wrote in
message ...
I want to copy just the results of formulas in a series of cells and not
the
formulas. that is i want to copy the values in cells.
Instead of Paste, go to the menu & click Edit, Paste Special, and select
Values. Lots of other interesting options there, too, like Formats, which is
especially handy sometimes.
Reply With Quote