Monday, December 23, 2013

Remove Duplicate Apps in Mac's Right Click -- "Open With"


  1. Open "Terminal" app.
  2. Enter the following command in "Terminal"
/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/LaunchServices.framework/Versions/A/Support/lsregister -kill -r -domain local -domain system -domain user

  3. After that, relaunch Finder by holding down the "Alt" key and right click the finder icon in the Dock, then click "Relaunch".

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:

My Mac Keyboard Function Key Shortcut Doesn't Work

The keyboard shortcut conflicts with a default Mac OS X key assignment.

Turn off the Mac OS  keyboard shortcut.
For OS X 10.8 (Mountain Lion)
  1. Click "system preferences".
  2. Under Hardware, click Keyboard
  3. Tick "Use all F1, F2, etc. keys as standard function keys.

Tuesday, May 14, 2013

Change Landscape to Portrait in Excel or Word in Mac

Word
In the layout tab, click orientation


Then, you will see the selection of "Portrait" and "Landscape"

Excel

Tuesday, April 2, 2013

Filling the Cells for Mac Excel (Useful Shortcuts, Filling down)

Fill Down -- copies the content of a cell to all highlighted below
Shortcut: Control + d



















Then, press "control" + "d".



















Fill Right - copies the content of a cell to all highlighted to the right.
The procedure is similar to fill down.
Shortcut: Control + r

Fill up a selected range of cells 
Copy content of a cell after you enter to a selected range of cells.
Shortcut: Control + Return
1. Highlight a range of cells



















2. Enter the content



















3. press "control" + "return"



Monday, March 25, 2013

Where is the location of Word for Mac and Powerpoint for Mac store user templates?


For Word and PowerPoint 2011, templates are stored inside your home folder in ~/Library/Application Support/Microsoft/Office/User Templates/My Templates.

How to get there ????
Since "Library" folder is hidden in Lion, you can go there by the following
1. Click "go" from the menu in Finder
2. Select "go to Folder ... "
3. Enter "~/Library" 
4. Click "go" by holding down "Opt/Alt" key.


Then the "Library" folder will show in the Finder window.

Tuesday, January 29, 2013

Type a Tick in Mac

Hold down the left "alt" button and press "v"


It will show the follow




Although it is not exactly a tick, it is ok to use.

Remove Not Use Applications under "Open With"


The list of programs for Open with… is maintained in the Launch Services database.
You can rebuild the database by the following command

he lsregister command, found at System/Library/Frameworks/CoreServices.framework/Frameworks/LaunchServices.framework/Support/lsregister, can tell the database to reset.

/System/Library/Frameworks/CoreServices.framework/Frameworks/LaunchServices.framework/Support/lsregister -kill -r -domain local -domain system -domain user

Note that utilities like Onyx or Cocktail can also reset this database for you.



Sunday, January 27, 2013

Where is the Backup Location of iDevice in Mac


in Mac OS X your iPhone files are backed up at the following location:
~/Library/Application Support/MobileSync/Backup/
The (~) symbol signifies your home directory, which is the same place all your other personal documents are stored.


Phone Backup Location for Windows 7, XP, and Vista
Windows XP stores all of your iPhone backup files in this location:
C:\Documents and Settings\user\Application Data\Apple Computer\MobileSync\Backup
Windows Vista and Windows 7 backs up the iPhone files to here:
C:\Users\user\AppData\Roaming\Apple Computer\MobileSync\Backup
Obviously if your main drive is not C: then you’ll have to change that, same goes for ‘user’

How Show Hidden Files in Mac


Launch the Terminal and enter these commands exactly as shown. The first command activates the ability to see the hidden files:
defaults write com.apple.Finder AppleShowAllFiles TRUE
Now you must relaunch the Finder by killing it, this is how the changes take effect:
killall Finder
If you want to hide hidden files again (those preceded with a .) and go back to the default Mac settings, you can just type the following:
defaults write com.apple.Finder AppleShowAllFiles FALSE
Again you will need to kill the Finder so that it can relaunch for changes to take effect:
killall Finder

Saturday, January 26, 2013

Save Settings and Preferences of CyberDuck


Where are preferences and application settings saved to
Mac OS X
In ~/Library/Preferences/ch.sudo.cyberduck.plist. Bookmarks, History and Workspace information is saved in ~/Library/Application Support/Cyberduck/.
Windows
  • Windows 7. C:\Users\[username]\AppData\Roaming\Cyberduck
  • Windows Vista. C:\Users\[username]\AppData\Roaming\Cyberduck
  • Windows XP: C:\Documents and Settings\[username]\Local Settings\Application Data\Cyberduck
Preferences are stored relative to the folders above in Cyberduck.exe_Url_[id]\[version]\user.config.

Backup Saved Severs in CoRD app


If you need to back up your Saved Servers, to take to another machine, etc., you can find them in:
~/Library/Application Support/CoRD/Servers/
They will be saved individually as .RDP files, and are interoperable with Microsoft's Remote Desktop Client, on both Macs and PCs.
Alternatively if you want a faster way to get there, you can right click (control click) on any server in your list, and click "Show in Finder," or use the options under the Servers menu item.

Import & Export Bookmark Browsers


Safari

Import bookmarks into Safari

  1. Open Safari if it is not already open.
  2. Choose File > Import Bookmarks.
  3. Browse to find the file that contains the bookmarks you want to import, and then click Import (on Windows computers, click Open). Normally the file has “.html” or “.plist” at the end of its name.

Export bookmarks from Safari

  1. Open Safari if it is not already open.
  2. Choose File > Export Bookmarks.
  3. Specify a location for the exported file. The file’s name is “Safari bookmarks.html.” Most browsers are able to import this type of file.

Chrome

  1. Click the Chrome menu Chrome menuon the browser toolbar /bookmark in the menu.
  2. Select Bookmark manager.
  3. Click the Organize menu in the manager.
  4. Select Export bookmarks to HTML File.

Firefox

  1. Click on the "Bookmarks" menu and select "Manage Bookmarks..." In case of Firefox 3.6.2 select "Organize Bookmarks..."/ "unsorted Bookmarks"
  2. Click on the "Backup" in the prompt up "Library window. / Export to HTML.
  3. Give your bookmarks whatever title you like and choose a location to save them in the save window that comes up.

Wednesday, January 23, 2013

Re-buid my iMac


I have my iMac for 4 years and have updated from Leopard --> Snow Leopard --> Lion --> Mountain Lion. 

I , finally, feel that he is not that responsive ...... so I decide to re-install the Mountain Lion from sketch.... as I  hear that the re-install of the OS would result to be massively fast.


Will tell the result after that ........


And write down some tips or experiences of this operation.


First.... it will be how to make the bootable USB drive. :D