excel shortcuts - 98 shortcuts

problem
	excel shortcuts - 98 shortcuts Hidden and usefull --- See the link also
difficulty level
	0/10 :))
compatibility
	MSOffice 2010 - Excel (and previous also some of them)
solution
	Selection - Select the whole column => CTRL + SPACE Selection - Select the whole row => SHIFT + SPACE Selection - Select table => SHIFT + CTRL + SPACE bar Selection - Save => CTRL + s Selection - Select visible cells only => ALT + ; Selection - Select entire region => CTRL + A Selection - Select range from start cell to far left => SHIFT + Home Selection - Select range from start cell to end in direction of arrow => SHIFT + End + arrow Selection - Select a continuous range of data (e.g. pivot), no matter where your cursor is. => CTRL + * Selection - Select blank cells => F5 + ALT + S + K + ENTER Selection - Select all cells with comments => CTRL + SHIFT + O Selection - Select all cells that are directly or indirectly referred to by formulas in the selection => CTRL + SHIFT + { Selection - Select all cells with formulas that refer directly or indirectly to the active cell => CTRL + SHIFT + } Selection - Selects all the way to a1 from cursor position => CTRL + SHIFT + HOME Selection - Select cells in the direction of arrow => CTRL + SHIFT + Arrow Navigation - Previous sheet => CTRL + Page Up Navigation - Next sheet => CTRL + Page Down Navigation - Launch GO TO Dialog (from here you can select special or jump to a cell or range) => F5 Navigation - Go to top left (will go to top left of freezed pane if set) => CTRL + Home Navigation - Go to last non-blank cell => CTRL + end Navigation - Go to previous sheet => CTRL + PgUp Navigation - Go to next sheet => CTRL + PgDn Navigation - Print => CTRL + p Navigation - Toggle between workbooks in a given session of excel. => CTRL + TAB Formulas - Change the type of cell reference from relative to absolute or semi-absolute => F4 Formulas - Repeat whatever you did last => F4 Formulas - Debug portions of a formula (select and press) => F9 Formulas - Sum range => ALT + = Formulas - Enter array formula => CTRL + SHIFT + Enter Formulas - Select array formula range => CTRL + / Formulas - Display range names (can be used when typing formulas) => F3 Formulas - Evaluate formulas. (its easy to remember when working with some “tuf” formulas!) => ALT + TUF Formulas - Copy a formula from above cell and edit => CTRL + ' Formulas - Display the formula palette after you type a valid function name in a formula => CTRL + A (while writing a formula) Formulas - Alternate between displaying cell values and displaying cell formulas => CTRL + ` (Single Left Quotation Mark) Formulas - Calculate formulas => F9 Formulas - Select all precedent cells => CTRL + [ Formulas - Select all dependent cells => CTRL + ] Formatting - Format Selection (cells, objects, charts) => CTRL + 1 Formatting - Bold a cell’s content => CTRL + B Formatting - Format Painter – Paste formats from selection => ALT + EST Formatting - Format as number with 2 dp => CTRL + SHIFT + 1 Formatting - Format as local currency => CTRL + SHIFT + 4 Formatting - Format as percentage with 0 dp => CTRL + SHIFT + 5 Formatting - Hide row => CTRL + 9 Formatting - Hide column => CTRL + 0 Formatting - Unhide row => CTRL + SHIFT + 9 Formatting - Unhide column => CTRL + SHIFT + 0 Formatting - Display the style command format menu => ALT + ' Formatting - Sets/removes strikeout in current cell => CTRL + 5 Formatting - Show/hide the top bar when you have a group => Crtl + 8 Formatting - Single border around selected cells => CTRL + SHIFT + 7 Formatting - Sort => ALT + DS Formatting - Insert hyperlink => CTRL + K Formatting - Freeze panes => ALT + WFF Formatting - Remove grid lines or (alt+t)ov(alt+g)[enter] => ALT + WVG (2007+) Formatting - To wrap lines => ALT + HW (2007+) Excel Options - Save as => F12 Excel Options - Collapse the ribbon (press again to expand) => CTRL + F1 Excel Options - Opens print preview => CTRL + F2 Excel Options - Maximize the current window => ALT + SPACE X Excel Options - Activate next window => ALT + TAB Excel Options - Activate previous window => ALT + SHIFT + TAB Excel Options - Close an excel workbook => crtl + F4 Excel Options - Split screens => ALT + W + S Everything Else - Create a pivot table in new sheet (of course after selecting the range) => ALT + DPF Everything Else - Create a pivot table in the same sheet. => ALT + DPN Everything Else - Show visual basic editor => ALT + F11 Everything Else - Macro dialog => ALT + F8 Everything Else - Apply/remove filter => ALT + DFF Everything Else - Keep filter on columns, but show all rows => ALT + DFS Everything Else - Insert pivot table => ALT + NVT Everything Else - Turn filter on or off => CTRL + SHIFT + L Editing - Paste values only => ALT + ESV Editing - Edit a cell, place cursor at the end => F2 Editing - Show in-cell drop down with previously entered values => ALT + Down arrow Editing - Fills down value from cell above => CTRL + D Editing - Add a comment or Edit comment => SHIFT + F2 Editing - Insert new sheet => SHIFT + F11 Editing - Insert row => CTRL + + Editing - Delete row => CTRL + Editing - -Copy => CTRL + C Editing - Paste => CTRL + V Editing - Cut => CTRL + X Editing - Undo => CTRL + Z Editing - Get a line break inside the cell => ALT + Enter (while editing the cell) Editing - Clear all contents => ALT + EAA Editing - Copy => CTRL + insert Editing - Paste => SHIFT + Insert Editing - Make chart/pivot chart => F11 Editing - Edit a cell in Apple Macs => CTRL + U Editing - Copy the value from the cell above the active cell into the cell or the formula bar => CTRL + SHIFT + " Editing - Copies whatever is in the cell to the left of it. => CTRL + R Editing - Delete box (cell, row, column) => ALT + ED Editing - Insert box (cell, row, column) => ALT + IE Auto Complete - Enter current date => CTRL + ; Auto Complete - Enter current time => CTRL + :