How to keep hyperlink in cells using =

Question

In the example below I am using =CellRowColumn (=b4) to fill in the rows on the next day.,

For example "My Map Contributions" under "Monday, Tuesday, Wednesday" is =B4. 

So whatever I type in B4 is what the cell contains. 

There is a hyperlink in B4 that takes me to that page. 

The same with the other columns.

How do I get the Hyperlink to work in the "Monday, Tuesday, Wednesday" columns?

In other words, the link works in the first column, but not in the column that references it. 

This works fairly easy in Google Sheets, but not in Excel.  

However, it does work in SOME cells.... 

I'm stuck...   thanks

Answer 1

Hi Stan,
Glad to know that you find the solution for your problem.

Could you please share what was the cause of this problem and how did you fix it?

Thanks and Stay safe.

Answer 2

Already resolved on my own. Thanks

Answer 3

Hi STAN,

Thanks for reaching out. My name is Ali. I'm an Independent Advisor and a Microsoft user like you. I'll be happy to help you out today.

Could you please confirm below things to understand your problem?

• Either are you facing problem while assigning hyperlinks or hyperlinks are already there but not working?
• Which kind of hyperlinks you are trying to define cell references or any web links?
• In case your facing any error the please share the details.
• Could you please share the full screenshot along with the row and columns header?

Please reply back with the above so I can help you with this.

Thanks,
Ali