Thread: Copy & Paste Visible Cells with Formulas

Hello Experts,
When I paste the visible cells, all of my numbers are pasted as values. How
do I paste visible cells and keep the formulas?

Thanks in advance,
Ricky

Exactly what procedures are you using?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Ricky" <rpang@westingrandvancouver.com> wrote in message
news:%23NwGYozAFHA.1292@TK2MSFTNGP10.phx.gbl...
Hello Experts,
When I paste the visible cells, all of my numbers are pasted as values. How
do I paste visible cells and keep the formulas?

Thanks in advance,
Ricky

Try:

Select the filtered range

Press F5 > Special > Visible cells only > OK
(this'll select the visible cells only)

then

Right-click to copy > paste special > formulas > OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Ricky" <rpang@westingrandvancouver.com> wrote in message
news:#NwGYozAFHA.1292@TK2MSFTNGP10.phx.gbl...
> Hello Experts,
> When I paste the visible cells, all of my numbers are pasted as values.
How
> do I paste visible cells and keep the formulas?
>
> Thanks in advance,
> Ricky
>
>

My procedures are GoTo Special, Visible Cells Only, Select; then, paste.
The trouble is that it's pasting the numbers are values. How do you get it
to paste with the formulas intact?

Thanks again.
Ricky

"RagDyer" <ragdyer@cutoutmsn.com> wrote in message
news:%23yhMhl0AFHA.1404@TK2MSFTNGP11.phx.gbl...
> Exactly what procedures are you using?
> --
>
>
> Regards,
>
> RD
> --------------------------------------------------------------------
> Please keep all correspondence within the Group, so all may benefit!
> -------------------------------------------------------------------
>
> "Ricky" <rpang@westingrandvancouver.com> wrote in message
> news:%23NwGYozAFHA.1292@TK2MSFTNGP10.phx.gbl...
> Hello Experts,
> When I paste the visible cells, all of my numbers are pasted as values.
How
> do I paste visible cells and keep the formulas?
>
> Thanks in advance,
> Ricky
>
>

"Ricky" <rpang@westingrandvancouver.com> wrote
> My procedures are GoTo Special, Visible Cells Only, Select; then, paste.
> The trouble is that it's pasting the numbers are values. How do you get
it
> to paste with the formulas intact?

Try Copy > Paste special > formulas > OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

You might also be interested in Past special > Paste Link.
This will create links (=$K$25) to your visible cells. It can be useful when you want to compare several filtered cases:

Case A with Case B
=$K$25.......=$K$26
=$K$29.......=$K$52

Ola Sandstrom

My procedures are GoTo Special, Visible Cells Only, Select; then, paste.
The trouble is that it's pasting the numbers are values. How do you get it
to paste with the formulas intact?

Thanks again.
Ricky

"RagDyer" <ragdyer@cutoutmsn.com> wrote in message
news:%23yhMhl0AFHA.1404@TK2MSFTNGP11.phx.gbl...
> Exactly what procedures are you using?
> --
>
>
> Regards,
>
> RD
> --------------------------------------------------------------------
> Please keep all correspondence within the Group, so all may benefit!
> -------------------------------------------------------------------
>
> "Ricky" <rpang@westingrandvancouver.com> wrote in message
> news:%23NwGYozAFHA.1292@TK2MSFTNGP10.phx.gbl...
> Hello Experts,
> When I paste the visible cells, all of my numbers are pasted as values.
How
> do I paste visible cells and keep the formulas?
>
> Thanks in advance,
> Ricky
>
>