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".

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

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

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!

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

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 "Find" dialog 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.

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

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"

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.

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.

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

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 on 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.

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