Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show cells have been read - linked | Excel Discussion (Misc queries) | |||
locking cells | Excel Discussion (Misc queries) | |||
How to keep linked cells blank until information is entered? | Excel Worksheet Functions | |||
Locking Cells | Excel Discussion (Misc queries) | |||
Locking certain cells | Excel Worksheet Functions |