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?