Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Delinking (a large list of) cells?
I want to "de-link" a large list of cells (1000). Each cell in the list
is linked to a cell in an adjacent table and my intention is to "freeze" the values in the list. e.g. L16 = {=TABLE()}, M16 = L16 I know this can be done by selecting each cell (column M) and pressing F9, but I would have to repeat this process 1000 times in the case. Is there an easier way to get round this? THANKS in advance! Note: Copying the cells in the table and pasting their values isn't an option as the table values change randomly, so the pasted values wouldn't match the ones in the table. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Converting a large vertical mailing list into a horizontal format | New Users to Excel | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Data Validation List Option Affecting Other Cells? | Excel Worksheet Functions | |||
make list of information from different cells | Excel Worksheet Functions |