how to copy-paste/insert a table in outlook 2018 email new message on Mac

While composing a new email
1. click the Options tab
2. switch on the Format Text
3. Copy-paste your table from Excel

How to remove watermark for your graduation photos

I'll take gradimages.com as an example

1. Go to the page that contains your graduation photos. Mine is:
    www.gradimages.com/XXXXX
2. Pick the image you want to download for free, zoom in and find its photo ID
3. If you are using Google Chrome, press fn + F12 or F12 to turn on developer mode (other browsers should be similar)
4. After the browser codes are loaded, click on it and press cmd + F to search
5. Search that image ID, you will find an url that links to your photo!!! Mine is:
     isc01.gradimages.com/******/***.jpg?preset=p
6. remove that preset=p you will get a small image without water mark

7.Play with that URL to find out more!

Illustrator textbox contains red highlights/fills

Solution:

If the original font is missing, they are going to show red highlights. You can change the font to those you own for the current version of illustrator.

Cambridge University iDiscover cannot log in although password correct

When you realize that the webpage freezes without logging you in and that your password isn't wrong, that may be a browser issue for the login page:

http://idiscover.lib.cam.ac.uk/primo-explore/login?vid=44CAM_PROD&lang=en_US

To fix it, click on the top left "Not secure" text in the browser and choose "allow"

Then you will reload the page and it will log you in

Excel plot stacked bar plots with connecting lines for the same categories

Stacked column charts in Excel offer a feature called “Series Lines”.

Detailed procedures can be found here: https://peltiertech.com/series-lines-useful-or-chart-junk/

Excel copy paste gene names converted to a date and corrupted

Sept7 is converted to September 7th

To fix this:
1. Type something on an excel file
2. Then select all
3. Command + 1 (Mac) or control +1 (windows), choose Text as the type
4. Delete what you typed
5. copy paste gene names into your formatted excel

Azure notebook cannot run any jupyter notebook

I encountered an error about running jupyter notebook files on Azure.
I selected a file and ran it. But it directed me to the folder page, without connecting to the notebook.

Solution: log out and log in again

Python edit categorical data

Packages like scanpy uses categorical data to store information. To manipulate it, you need to convert it to string format first

thing = [str(i) for i in thing]

How to save images from word with high resolution/ without decreasing quality

Save as is a bad method to save images stored in a word file. An easy way is:

Save as a webpage
And then look for your picture in the companion folder

Team viewer Stuck at initializing display parameters

When I tried to remote-control my other computer, the connection was established but the pop-up screen was stuck with the pending message "initializing display parameters". This didn't occur earlier. So it must have been runtime errors instead of wrong settings.

The solution:
Use task manager on PC or Activity Monitor(search that app and open it) on Mac and stop all the TeamViewer processes on the computer you are using to control other computers. Restart the software, wait till it's ready, connet, and it might work.


This solution is actually Method 6 of an article. More scenarios can be find there:
https://appuals.com/fix-teamviewer-stuck-on-initializing-display-parameters/

how to install different versions of the same R package

Use devtools:

devtools::dev_mode(path='~/tools/Seurat3/')
devtools::install_github(repo = "satijalab/seurat", ref = "release/3.0")