Select entire worksheet.
Copy.
Right click - paste special - values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ls9811" wrote:

I use Excel for my budget. Each month has its own worksheet. I have a
overview sheet that is linked to key days of the month so I can see balance
trends on a single page. Also on this page is a list of all the constant
expences and then each sheet is linked that those cells so if my payment
amount for something changes I only have to change 1 cell. The problem comes
when I want to archive a worksheet. I have to go through it one cell at a
time and type in the values so the worksheet won't be linked to other pages
when I move it to my archive file. Is there a simple command I can type
while a cell or cells are selected that would keep the value of that cell the
same but remove the formula that links it to other places?