Shortcuts of Excel 2010 (Manage Active Selections - Select inside cells ) Page - 3

Manage Active Selections
F8	Turn on extension of selection with arrow keys without having to keep pressing shift.
Shift+F8	Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection.
Shift+Backspace	Select only the active cell when multiple cells are selected.
Ctrl+Backspace	Show active cell within selection.
Ctrl+. (period)	Move clockwise to the next corner of the selection.
Enter/Shift+Enter	Move active cell down / up in a selection.
Tab/Shift+Tab	Move active cell right / left in a selection.
Ctrl+Alt+Arrow Right/Ctrl+Alt+Arrow Left	Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
Esc	Cancel Selection.

Select inside cells
Shift+Arrow Left/Shift+Arrow Right	Select or unselect one character to the left / to the right.
Ctrl+Shift+Arrow Left/Ctrl+Shift+Arrow Right	Select or unselect one word to the left / to the right.
Shift+Home/Shift+End	Select from the insertion point to the beginning / to the end of the cell.

Read More

Shortcuts of Excel 2010 (Work with Data Selections) Page-2

Select Cells
Shift+Space	Select the entire row.
Ctrl+Space	Select the entire column.
Ctrl+Shift+* (asterisk)	Select the current region around the active cell.
Ctrl+a (or ctrl+Shift+spacebar)	Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet.
Ctrl+Shift+Page Up	Select the current and previous sheet in a workbook.
Ctrl+Shift+o	Select all cells with comments.
Shift+Arrow Keys	Extend the selection by one cell.
Ctrl+Shift+Arrow Key	Extend the selection to the last cell with content in row or column.
Shift+Page Down/Shift+Page Up	Extend the selection down one screen /up one screen.
Shift+Home	Extend the selection to the beginning of the row.
Ctrl+Shift+Home	Extend the selection to the beginning of the worksheet.
Ctrl+Shift+End	Extend the selection to the last used cell on the worksheet (lower-right corner).

Read More

Shortcuts of Excel 2010 (Navigate Inside Worksheets) Page-1

Arrow Keys	Move one cell up, down, left, or right in a worksheet.
Page Down/Page Up	Move one screen down / one screen up in a worksheet.
Alt+Page Down/Alt+Page Up	Move one screen to the right / to the left in a worksheet.
Tab/Shift+Tab	Move one cell to the right / to the left in a worksheet.
Ctrl+Arrow Keys	Move to the edge of next data region (cells that contains data)
Home	Move to the beginning of a row in a worksheet.
Ctrl+Home	Move to the beginning of a worksheet.
Ctrl+End	Move to the last cell with content on a worksheet.
Ctrl+f	Display the Find and Replace dialog box (with Find selected).
Ctrl+h	Display the Find and Replace dialog box (with Replace selected).
Shift+F4	Repeat last find.
Ctrl+g (or f5)	Display the 'Go To' dialog box.
Ctrl+Arrow Left/Ctrl+Arrow Right	Inside a cell: Move one word to the left / to the right.
Home/End	Inside a cell: Move to the beginning / to the end of a cell entry.
Alt+Arrow Down	Display the AutoComplete list e.g. in cell with dropdowns or autofilter.
End	Turn 'End' mode on. In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell. From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right.

Read More

Excel Tips & Tricks (Excel ~ substitute Formula)

Let’s say, for example, you need to substitute something within a cell. The immediate example that comes to mind for me is a to replace a space with an underscore (you can see them in the highlighted box below if you look closely). In case you don’t want to use the good old-fashioned find/replace, you can use the substitute formula (found up in the function bar). Or, for simplicity, start typing =substitute. Then, throw on an open parenthesis and select the cell where the offending material lives. Next, add in a comma, quotation marks containing the material one wants to replace, another comma, the material one will be replacing the offending material with, and a closed parenthesis. A visual probably makes this explanation much more bearable:

Read More