MrTed46 Posted December 10, 2008 Share Posted December 10, 2008 I copied and pasted something from MFL.com, and it has hyperlinks on every player (trying to organize stats myself in excel). Is there anyway to remove ALL hyperlinks at once? Quote Link to comment Share on other sites More sharing options...
BiggieFries Posted December 10, 2008 Share Posted December 10, 2008 I copied and pasted something from MFL.com, and it has hyperlinks on every player (trying to organize stats myself in excel). Is there anyway to remove ALL hyperlinks at once? Give this a shot. Scroll down to the excel instructions. Quote Link to comment Share on other sites More sharing options...
Big Country Posted December 10, 2008 Share Posted December 10, 2008 instruction from Excel help on how to deactivate multiple hyperlinks: Type the number 1 in a blank cell, and right-click the cell. Click Copy on the shortcut menu. While pressing CTRL, select each hyperlink you want to deactivate. How? To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross , then release the mouse button. Click Paste Special on the Edit menu. Under Operation, click Multiply and then click OK. I did this at the beginning of the season and it worked. I can;t remember if I was able to use the method of selecting the first cell and then the last one while pressing shift or if I actually went through each cell with control, but it worked. Quote Link to comment Share on other sites More sharing options...
MrTed46 Posted December 10, 2008 Author Share Posted December 10, 2008 instruction from Excel help on how to deactivate multiple hyperlinks: Type the number 1 in a blank cell, and right-click the cell. Click Copy on the shortcut menu. While pressing CTRL, select each hyperlink you want to deactivate. How? To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross , then release the mouse button. Click Paste Special on the Edit menu. Under Operation, click Multiply and then click OK. I did this at the beginning of the season and it worked. I can;t remember if I was able to use the method of selecting the first cell and then the last one while pressing shift or if I actually went through each cell with control, but it worked. Worked like a charm TY Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.