L
ls9811
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?
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?