Sunday, February 26, 2012

Automatically Show and Hide Dock Bar on MacBook Pro

By default, the dock bar always show on MacBook Pro. It consume a lot of space on screen. To make it automatically hide and show:

1. Right click the middle space between icon, go to dock preferences.

2. Check automatically hide and show the Dock

or
Click on the Apple icon on the top left screen to access Dock preferences
or really quick: Press <option><command><command>D keys at the same time to turn on/off the automatically hide and show the Dock

Sunday, February 12, 2012

How to Open Two Excel Files Side by Side in Two Monitors?

The best solution is using LibreOffice. With LibreOffice Calc, you can open one Excel spreadsheet in one monitor and another speadsheet in other monitor to compare, view or edit.

Change the configuration in Excel 2007 or 2010 is another solution by check the check box 'Ignore other application that use Dynamic Data Exchange'. You may encounter with the run-time error when you attempt to close or open again.

References:

Sunday, February 5, 2012

Troubleshoot Internet Connection

  1. Make sure you can connect to your router by ping to your router IP (for example: 192.168.1.1) from command line (Windows) or terminal (Mac or Linux) or access to the router web page using the browser. If you cannot ping or see the router web page, check your network configuration on your computer.
  2. Are you using the wireless? If yes, connect the CAT 5 Ethernet cable connect to your computer.
  3. Is the wired connection working? If yes, your wireless has issue.
  4. If the wired connection is not working, is other computer in your home, your office or your LAN can access to the Internet? If just only your computer, check your network configuration.
  5. If all computers in your LAN could not access to the Internet, power down both the router and cable modem.
  6. Wait for 15 seconds, and turn them on.
  7. If you still not connect, check to see there is outage in your area. If not, verify your router is working.
  8. To verify your router is in good condition, hook up another spare router or your computer directly to the cable modem. Note: If you hook up your computer directly to the cable modem, make sure the firewall on computer enable and all ports other than 80 are closed. Connect computer with open ports: 20, 21, 139, 3389 directly to cable modem or Internet is dangerous and not recommend. Here, I'm using my test computer running GNU Linux with all closed ports to connect directly to the router.
  9. If you can connect to the Internet without router or with another router for an hour or more, your existing router is bad. It need a replacement.
  10. If you cannot connect to the internet, chance is your cable modem or the link from cable modem to your internet service provider have issue, call your internet service provide technical support.