Can I remove formula but keep value with a simple command?
 

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?

Can I remove formula but keep value with a simple command?
 

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?

Can I remove formula but keep value with a simple command?
 

In the same way as you can move cells you can replace formulas with values.
Highlight the cells you want to modify. Move your cursor to the edge of the
selection to get the 4 pointed North South cursor. Instead of left clicking
Right click and drag the cells to a different spot but don't let go of the
button. Now drag the cells back. Release the button dropping the cells back
in their original position. A menu will appear. One of the options is paste
values. Select that and you are done...
--
HTH...

Jim Thomlinson


"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?