Monday 6 June 2016

Excel - reset the last cell on a worksheet

  • To select all columns to the right of the last column that contains data, click the first column heading, press <ctrl><shift><right>
  • To select all rows below the last row that contains data, click the first row heading, press <ctrl><shift><down>
  • On the Home tab, in the Editing group, click the arrow next to the Clear button, and then click Clear All
  • Click the Microsoft Office Button , and then click Save
  • Click the Microsoft Office Button , and then click Close
  • When you open the workbook again, the last cell of the data should be the last cell on the worksheet

Sunday 5 June 2016

多種事 多種説

急事,慢慢的説
大事,清楚的説
小事,幽默的説
沒把握事,謹慎的説
沒發生事,不要胡説
做不到事,別亂説
傷害人的事,不能説

討厭的事,對事不對人説
開心的事,看場合説
傷心的事,不要見人就説
別人的事,小心的説
自己的事,聽聽自己的心怎麼説
現在的事,做了再説
未來的事,未來再説





Friday 6 May 2016

Macbook Air Enable closed-display mode

  • connect to an external monitor and using the AC power adapter or 
  • having an external mouse or keyboard attached...

more info

Friday 1 April 2016

Print to Google Cloud Printer on Mac

Assume the Google Cloud Printers have been setup...

Download Cloud Printer for Mac from here:
http://www.macupdate.com/app/mac/40510/cloud-printer

Add the Print Plugin
https://www.youtube.com/watch?v=FuPQGD5z9IE



Monday 28 March 2016

Export Word Doc to PDF with Word for iPad

In the Word document:
  • Click the Share (right) icon (the one with a person and a + sign)
  • Select "Send Attachment"
  • Select "PDF"
  • Select "Send a Copy"
  • Here I found a few useful options, send to Google Drive (may need to click "More" to enable it), Gmail and "Save to Dropobox", etc.

Friday 18 March 2016

iPad connects to weak WiFi network

I found one very interesting fact... my work place has a very weak public WiFi.  My iPad normally doesn't able to see and connect to it.  But once I connect a Bluetooth device (either my MacBook Air or even just a bluetooth keyboard), I am able to connect to this WiFi network.

Thursday 25 February 2016

Uninstall / Remove FxFactory Product

  • Start FxFactory (5.0.9)
  • Actions >> Show Products in Finder
  • It will show two windows
    • Users>'user name'>Library>Application Support>FxFactory
    • Library>Application Support>FxFactory
  • Move the product to the Trash (type in your password)
    • Normally, it will have more than one files
  • It will disappear right away in the Installed tab

Thursday 18 February 2016

How to Use Exposure Compensation to Take Control of Your Exposure

http://digital-photography-school.com/how-to-use-exposure-compensation-to-take-control-of-your-exposure/

  • Aperture Priority Mode – In Aperture Priority mode, exposure compensation changes the shutter speed. Remember that in this mode, you set the aperture and the camera sets a corresponding shutter speed. If you change the Aperture, your camera just sets another corresponding shutter speed, and there is no change in the exposure level. Exposure compensation gives you the ability to change the shutter speed (and the overall exposure value) while staying at the same aperture you originally set.
  • Shutter Priority – In Shutter Priority mode, exposure compensation changes the size of your aperture. It is basically the reverse of Aperture Priority mode. You set a shutter speed, and the camera sets a corresponding aperture. Exposure compensation therefore changes the exposure by allowing you to change that aperture size.

Thursday 11 February 2016

Intro to Unreal Engine for VR

https://channel9.msdn.com/blogs/misslivirose/Intro-to-Unreal-Engine-for-VR