Shaolin
04-26-2005, 11:38 AM
If I link just one cell that reads "I'm the greatest" from spreadsheet A sheet 1 onto spreadsheet A sheet 2 so that linked cell reads "=Sheet1!$A$2"
But if I want to erase that link and keep the text in display so it still reads "I'm the greatest," how do I do it? I have about 10,000 cells that I want to do like that, is there an easy way to do it?
But if I want to erase that link and keep the text in display so it still reads "I'm the greatest," how do I do it? I have about 10,000 cells that I want to do like that, is there an easy way to do it?