Never under estimate the power of control (CTRL) tab in EXCEL

CTRL+F   (SHIFT+F5)

Displays the Find and Replace dialog box, with the Find tab selected.

CTRL+F1

Displays or hides the ribbon.

CTRL+F10

Maximizes or restores the selected workbook window.

CTRL+F5

Restores the window size of the selected workbook window.

CTRL+F7

Performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.

CTRL+F8

Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.

CTRL+F9

Minimizes a workbook window to an icon.

CTRL+F4

Closes the selected workbook window.

CTRL+K

Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

CTRL+L

Displays the Create Table dialog box.

CTRL+F6

Switches to the next workbook window when more than one workbook window is open.

CTRL+A

Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.

CTRL+SPACEBAR

Selects an entire column in a worksheet.

CTRL+D

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

Copies a formula from the cell above the active cell into the cell or the formula bar

CTRL+:

Enters the current time

CTRL+*

Select the active Data Area

CTRL+N

Creates a new, blank workbook

CTRL+O

Displays the Open dialog box to open or find a file

CTRL+1

Displays the Format Cells dialog box.

CTRL+F2

Displays the print preview area on the Print tab in the Backstage view.

CTRL+G  (F5)

Displays the Go To dialog box.

CTRL+H

Displays the Find and Replace dialog box, with the Replace tab selected.

CTRL+END

Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text.

CTRL+HOME

Moves to the beginning of a worksheet.

CTRL+PAGE DOWN

Moves to the next sheet in a workbook.

CTRL+PAGE UP

Moves to the previous sheet in a workbook.

CTRL+ARROW KEY

Moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.

CTRL+W

Closes the selected workbook window.

CTRL+`

Alternates between displaying cell values and displaying formulas in the worksheet.

CTRL+5

Applies or removes strikethrough.

CTRL+&    (aka CTRL+SHIFT+7)

Applies the outline border to the selected cells.

CTRL+T

Displays the Create Table dialog box.

CTRL+Minus (-)

Displays the Delete dialog box to delete the selected cells.

CTRL+0

Hides the selected columns.

CTRL+9

Hides the selected rows.

CTRL+SHIFT+O

Selects all cells that contain comments.

CTRL+SHIFT+PAGE DOWN

Selects the current and next sheet in a workbook.

CTRL+SHIFT+PAGE UP

Selects the current and previous sheet in a workbook.

CTRL+SHIFT+!

Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

CTRL+SHIFT+#

Applies the Date format with the day, month, and year.

CTRL+SHIFT+$

Applies the Currency format with two decimal places (negative numbers in parentheses).

CTRL+SHIFT+%

Applies the Percentage format with no decimal places.

CTRL+SHIFT+@

Applies the Time format with the hour and minute, and AM or PM.

CTRL+SHIFT+^

Applies the Scientific number format with two decimal places.

CTRL+SHIFT+~

Applies the General number format.

CTRL+SHIFT+( 

Unhides any hidden rows within the selection.

CTRL+SHIFT+U

Switches between expanding and collapsing of the formula bar.

CTRL+SHIFT+END

Extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.

CTRL+SHIFT+HOME

Extends the selection of cells to the beginning of the worksheet.

CTRL+SHIFT+F

Opens the Format Cells dialog box with the Font tab selected.

CTRL+SHIFT+P

Opens the Format Cells dialog box with the Font tab selected.

CTRL+SHIFT+Plus (+)

Displays the Insert dialog box to insert blank cells.

CTRL+SHIFT+ARROW KEY

Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.