seemingly simple problem...copy/paste

NuWest

Board Regular
Joined
Oct 24, 2002
Messages
95
i am trying to copy an entire spreadsheet's formulas, formatting, etc., everything but the current values that are in each cell, into a new spreadsheet for the new quarter. but everytime i go to copy and paste special and select to paste only formulas, it still pastes, the old values. can anyone help!?!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Ivan F Moala

MrExcel MVP
Joined
Feb 10, 2002
Messages
4,209
I'm assuming you have selected ALL CELLS then
Copy > Pastesspecial > Formulas ?

OK, after this select

Edit > Goto > Special
Select Constants then Press OK
Now hit delete Key
 

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
consider copying the whole sheet in it's entirety by using the menu available when you right clicking on its tab. Then highlight the relevent sections and use control G - special constants to isolate your constants and hit delete.
 

Forum statistics

Threads
1,144,436
Messages
5,724,343
Members
422,545
Latest member
zillafreak

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top