Select all the linked cells then EditCopy.
In place, EditPaste SpecialValuesOKEsc.
Gord Dibben Excel MVP
On Wed, 22 Jun 2005 12:44:03 -0700, "Cesar_us"
wrote:
I have downloaded information from the web in a multiple of cells.
I know that by going to each cell and clicking on the formula bar and then
pressing F9 in can covert that link to a value for that cell.
But I have a row of 50 cells. I have been doing the above process
individually for each cell.
Is there a way I can do it for all 50 cells at one time. I used the Shift
key to highlight all 50 cells, but I still have to click on the formula bar
to activate each cell and then press F9 for each cell.
Wondering if there is a quicker way to complete this process.
Thanks.
Cesar.
|