How to remove hyperlinks from multiple cells in Excel?

It is a nightmare that Excel is trying to open a new web page for all the sells that you kust need to see or copy as a plain text!
I found a very simple solution for that and want to share it with you:

What you need to do is simple multiply the cells with 1 that you want to remove the hyperlinks:)
Select an empty cell and type 1, then select all cells that you need to remove hyperlinks, via pressing shift key, then right click and select paste special. There click the option multiply and it is done!
Nice, jaa??

How to keep 2 excel sheets open side by side?

For the project I have been working nowadays, I need to work with Excel frequently.
I need to compare two excel sheets so I need to keep them open side by side. since they are both excel documents, MS tried to save the memory for that and does not allow me to do so, unless you follow these simple steps:

1) Click on the office icon and select excel options.
2)Go to the Advanced tab and scroll down to general section to click ignoring other applications.

That is all!!!