Locking linked cells
How can I lock the links between worksheets? I have a Excel
spreadsheet that contains seveal worksheets and these sheets have links between cells. My plan is to paste my raw data in to a specific sheet and perform necessary sorting and calculations in other sheets. Unfortunately, my data files don't all have the same number of lines and when I insert a line in the raw data worksheet to compensate for the difference, my linked cell change by the number of lines I insert. I've thought of changing the references from relative to absolute, but that would require the selection of several hundred indivial cell and several hundred F4's (I can't find a way to F4 a large group of cells). |
All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com