Office – Excel

Tips and Tricks:

1.       Split screen (for when you want to read online text and work on project at the same time!)

2.       Select Column in Excel  – Ctrl+Space Bar; Select Row in Excel  – Shift+Space Bar

In Excel, hit Ctrl plus the Space Bar to select the entire column of your active or selected cells. (Then you can delete all the cell contents with the delete key, or copy with Ctrl+C or whatever you like.)

Similarly, Shift plus the Space Bar selects the entire row of cells.

For example, suppose you want to move a column. Follow these steps:

1. Move      your cursor to some cell in the column you want to move. (Remember you can      press F5 to instantly go anywhere.)
2. Press      Ctrl+Space Bar. The entire column is selected.
3. Press      Ctrl+X to Cut the column.
4. Move      your cursor to the location right where you want the column inserted.
5. Press      Shift+F10 to display the shortcut menu.
6. Using      the arrow keys and Enter, select the Insert Cut Cells command.

3.       Display active cell in Excel  – Ctrl+Backspace

Suppose you’ve used the mouse to scroll too far in Excel. You’re lost. The cells are zooming by at a million miles an hour. You just want to get back to see the cell where your cursor is. Help! Scrolling around to find the active cell will take forever! Ctrl+Backspace moves the visible area of the spreadsheet back to whereever your cursor is (the so-called active cell).

4.       Move left and right one screen in Excel  – Alt+Page Down, Alt+Page Up

To move to the right in Excel to see your next group of columns, you could scroll. Or you could press the Right Arrow key a bunch of times.

Or, press Alt+Page Up. You immediately find yourself one screen to the right looking at your next batch of columns.

Conversely, Alt+Page Down moves you to the left.

(Compare to the regular Page Up and Page Down, which you already know moves you up and down a screen.)

5.       Insert New Worksheet in Excel  – Shift+F11

Don’t click on the Insert menu and then the Worksheet command. Don’t even press Alt+I, W. Just press Shift+F11 and a brand new worksheet is created for you in Excel.

Source: http://www.zeigen.com/shortcuts/