Wednesday, August 29, 2018

how to adjust iphone text sizes

settings -> general -> accessibility ->  larger text -> move the bar at the bottom part

Tuesday, August 28, 2018

how to erase iphone content and settings

1. make sure you back up everything.
2. General -> Reset -> erase contents and settings , follow instructions

Sunday, August 26, 2018

how to remove Chinese Theme fonts in Word

go to system preference -> language and region -> remove Chinese language

Restart word.

This is a partial solution. Reference is here:
https://answers.microsoft.com/en-us/office/forum/office_2010-word/fonts-in-word-2010-default-to-asian-typography/b31bb4ac-cd7c-e011-9b4b-68b599b31bf5?db=5

Friday, August 24, 2018

how to print cell arrays without quotes on Matlab

sprintf('%s\n',string(Your_array))

how to sort excel columns by color

There are two ways:
1. Use Sort & Filter -> Custom Sort -> set sort on... font color

2. highlight the header row and Sort & Filter -> Filter -> then specify font color you want to keep

Tuesday, August 14, 2018

Saturday, August 11, 2018

How to fix a mini-fan

I got a mini-fan like this : https://www.amazon.com/dp/B07352KD2Y?aaxitk=AHuL4w0q-7Bw5FRugmht0A&pd_rd_i=B07352KD2Y&pf_rd_m=ATVPDKIKX0DER&pf_rd_p=3930100107420870094&pf_rd_s=desktop-sx-top-slot&pf_rd_t=301&pf_rd_i=mini+fan&hsa_cr_id=2787314300101&sb-ci-n=asinImage&sb-ci-v=https%3A%2F%2Fimages-na.ssl-images-amazon.com%2Fimages%2FI%2F51t34taCUIL.jpg&sb-ci-a=B07352KD2Y

But after accumulating too much dirt, it is sometimes stuck. Here's how I managed to fix it:

1. Use an old toothbrush to insert into its inner space and brush off the dust. When you do this, you'd better do it next to a running air purifier or vaccum to reduce flying dust
2. Then put the fan face-down and hit it onto the ground to make sure dust trapped in the center is coming off. Flip it and do again.

Finally the fan should be able to run again.

Friday, August 10, 2018

How to rotate/flip an image in powerpoint on Mac

1.Click on the image
2. Picture Format panel -> Arrange -> Rotate ---> select how you want to rotate

Thursday, August 9, 2018

Google Calendar only shows "busy" when you import another user / team's calendar

If an event shows "busy" while it actually has content when viewed from the creator, you have to ask the creator to do the following things:

Stop searching for answers if you are not an admin --- i.e. if you don't have a G suite account or a domain to yourself.

You just simply can't do it.
(I've searched through google and stackexchange, no solutions)

Wednesday, August 8, 2018

shortcut to switch between windows in the same app say Word, on a Mac

we all know that cmd + tab lets you switch between different programs / apps.
What if you have multiple files opened in Word?

The answer is:


cmd + ` (the key above tab)

[Word] add automatic numbering to figures using caption

If you want to do numbering for figure, click on the figure, references -> insert caption
select the right type or define a new label, write additional information in the caption box.

more guidance:
https://support.office.com/en-us/article/add-format-or-delete-captions-in-word-82fa82a4-f0f3-438f-a422-34bb5cef9c81

How to print oxps documents on a Mac


You have to convert it to pdf to print:
use this website
http://online.b1.org/online

Tuesday, August 7, 2018

how to show multiple pages tiled in Office Word on Mac

In the Word Window , click View(not the one on the very top of your screen) -> Multiple pages
Make sure you are using Print layout instead of web layout

how to let Gmail show Sent mails in Inbox/ prevent Gmail from hiding Sent mails

"You can set up a filter for messages sent from: [yourself], and check Never send it to spam. This will put all sent emails in your inbox automatically."

This answer is from https://webapps.stackexchange.com/questions/27269/get-sent-emails-copy-in-inbox

Friday, August 3, 2018

How to cancel Google Drive storage plan / membership

The old protocol no long works because Google drive has been migrated to Google One.

Therefore, what you should do is:
  1. On your computer, go to Google One.
  2. At the top, click Settings Settings and then Cancel membership.
  3. In Google Play, next to "Google One," click Manage and then Cancel subscription.
  4. Follow the steps on the screen.

how to manage Gmail storage: delete large emails

In the search box just type:
size:5242880 

It will show you all the emails that have sizes larger than 5M
Then you can selectively delete them