Copy & Paste Visible Cells with Formulas

  • Thread starter Thread starter Ricky
  • Start date Start date
R

Ricky

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!
-------------------------------------------------------------------

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
 
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
 
Ricky said:
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?
Click to expand...

Try Copy > Paste special > formulas > OK
 
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
 
Back
Top