| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I replace the hyperlinks on many cells at once?
I have a spreadsheet of about 4000 rows that I have each row hyperlinked on.
This hyperlink now has an error in it so I was wondering if there is a way to replace the address in all at once as opposed to replacing them one by one. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I replace the hyperlinks on many cells at once?
Say you have cells with something like:
=HYPERLINK("http://www.cnn.com") in them. You can use Find / Replace to change cnn to fox in all of them at once. -- Gary''s Student - gsnu200799 "Kelly" wrote: I have a spreadsheet of about 4000 rows that I have each row hyperlinked on. This hyperlink now has an error in it so I was wondering if there is a way to replace the address in all at once as opposed to replacing them one by one. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
| Replace hyperlinks with actual pictures | Links and Linking in Excel | |||
| How to find multiple cells/replace whole cells w/data | Excel Discussion (Misc queries) | |||
| how to do global replace in hyperlinks for entire excel document? | Excel Discussion (Misc queries) | |||
| Can I use Find and Replace all with Hyperlinks? | Excel Discussion (Misc queries) | |||
Linear Mode
