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