Sunday, November 24, 2013

Disable "Reopen Windows When Restart" in Mac OS X

In Mavericks,
System Preferences, in General , click the "Close windows when quitting an application" option.

Show Hidden Files in Mac OS

Show Hidden Files

For OS X Mavericks 10.9 there is a very slight difference in casing:
defaults write com.apple.finder AppleShowAllFiles TRUE
For Mac OS X 10.8 Mountain Lion, 10.7 Lion, 10.6 Snow Leopard the setting remains the following:

defaults write com.apple.Finder AppleShowAllFiles TRUE

Restart Finder by the following
killall Finder


Reverse to Default & Make Files Hidden Again

defaults write com.apple.Finder AppleShowAllFiles FALSE
There is little difference in OS X Mavericks has to do with capitalisation:
defaults write com.apple.finder AppleShowAllFiles FALSE

Restart Finder by the following
killall Finder

Saturday, October 26, 2013

Where is the network utility in Mavericks?

Network utility is moved after upgrade from Mountain Lion to Mavericks.

Here is the new way to open it.
1. Go to Application and utilities and open "system information".
2. In the system information window, move the mouse to the menu and window.
3. Then you will see "network utility" below "About this Mac".
4. Click "network utility" and then keep it in Dock.


Enjoy! :D

Wednesday, October 16, 2013

Change Dictionary in MacBook Air or Mac in OS X 10.8

Go to Dictionary.app --> Preferences , you will see different dictionaries and select & priority your own!

Friday, June 14, 2013

Excel in Mac 2011 for Mac -- Comparing Two Spread Sheet in one Window

Need to compare two spreadsheets ?
You can use Excel 2011 for Mac by displaying spreadsheets side by side.
  • Open any spreadsheets that you want to view side by side
  • Then go to "Layout" tab






  • Look under "Window" group and select "Arrange"
  • In there, you can display spreadsheets vertically or cascade the windows
  • Select "Arrange Windows ... " for the full range of options









  • Choose the way you want your windows to display, and select OK to apply your change

Monday, May 27, 2013

Microsoft Excel Shortcut Mac vs Windows -- Part 1 (Function Keys)

Action Windows      Mac
Undo ctrl + z F1 / Command + z
Cut text from the active cell ctrl + x F2 / Command + c
Edit a cell comment SHIFT + F2 Shift + F2
Copy text from the active cell ctrl + c F3
Open the Formula Builder SHIFT + F3 Shift + F3
Paste text into the active cell ctrl + v F4
Repeat the last Find (Find Next) Shift + F4
Close the window ctrl + F4 Command + q / Command + F4
Display the "Go To" dialog box F5 F5
Display the "Finddialog box ctrl + f Command + f / Shift + F5
Restore the window size. ctrl + F5 Command + F5
Move to the next pane in a workbook that has been split F6 F6
Move to the previous pane in a workbook that has been split SHIFT + F6 Shift + F6
Move to the next workbook window ctrl + F6 command + F6
Move to the previous workbook window ctrl + Shift + F6 comand + Shift + F6
Check spelling F7 F7
Turn on extend selection mode F8 F8
Add to the selection Shift+ F8 Shift+ F8
Display the "Macro" dialog box Alt + F8 Option + F8
Calculate all sheets in all open workbooks F9 F9
Calculate the active sheet. Shift + F9 SHIFT + F9
Display a contextual(right-click) menu. Shift + F10 SHIFT + F10
Maximize or restore the workbook window Ctrl + F10 Command + F10
Make the first button on a floating toolbar active OPTION + F10
Insert a new chart sheet. F11 F11
Insert a new sheet. Shift + F11 Shift + F11
Insert an Excel 4.0 macro sheet Command + F11
Display the "Save As" dialog box F12 F12
Display the "Open" dialog box Command + F12
Display the "Print" dialog box CONTROL + SHIFT + F12

MS Excel: Freeze Panes in Excel 2011 for Mac

In the "Layout Ribbon" , on the left-hand side, in "Window" click the panes icon like the following: