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 + :

excel, how to get the Time value from a Timestamp value

excel, how to get the Time value from a Timestamp value? Or even from NOW() function? 

If we have the C2 cell with Timestame value, Time = C2-INT(C2)
In order to get only the time value from NOW() we have Time =NOW()-INT(NOW())

Excel Keyboard Shortcuts

	NOTE: These key assignments are for standard US-English keyboards. The mappings may be slightly different on non-US-English keyboards.
	Key Alone Shift Ctrl Alt Shift Ctrl F1 Help What's This Help   Insert Chart Sheet   F2 Edit Mode Edit Comment   Save As   F3 Paste Name Formula Paste Function Define Name   Names From Labels F4 Repeat Action Find Again Close Window Quit Excel Find Previous F5 Goto Find Restore Window Size     F6 Next Pane Prev Pane Next Window Previous Window Prev Workbook F7 Spell Check   Move Window     F8 Extend Selection Add To Selection Resize Window Macro List   F9 Calculate All Calculate Worksheet Minimize Workbook     F10 Activate Menu Context Menu Maximize Window     F11 New Chart New Worksheet New Macro Sheet VB Editor   F12 Save As Save Open   Print A     Select All    Formula Arguments B     Bold     C     Copy     D     Fill Down Data Menu   E       Edit Menu   F     Find File Menu Font Name G     Goto     H     Replace Help Menu   I     Italics Insert Menu   J           K     Insert  Hyperlink     L           M           N     New Workbook     O     Open Workbook Format Menu Select Comments P     Print   Font Size Q           R     Fill Right     S     Save     T       Tools Menu   U     Underline     V     Paste     W     Close Workbook Window Menu   X     Cut     Y     Repeat Active     Z     Undo     ` (~)     Toggle Formula View   General Format 1 (!)     Cell Format   Number Format 2 (@)     Toggle Bold   Time Format 3 (#)     Toggle Italics   Date Format 4 ($)     Toggle Underline   Currency Format 5 (%)     Toggle Strikethru   Percent Format 6 (^)     Toggle Object Display   Exponent Format 7 (&)     Show/Hide Standard Toolbar   Apply Border 8 (*)     Outline   Select Region 9 (()     Hide Rows   Unhide Rows 0 ())     Hide Columns   Unhide Columns -     Delete Selection Control Menu No Border = (+) Formula   Calculate All Auto Sum Insert Cells [     Direct Precendents   All Precendents ]     Direct Dependents   All Dependents ; (semicolon)     Insert Date Select Visible Cells Insert Time ' (apostrophe)     Copy Formula From Above Style Copy Value Above : (colon)     Insert Time     /     Select Array   Select Array \     Select Differences   Select Unequal Cells Insert Insert Mode   Copy     Delete Clear   Delete To End Of Line     Home Begin Row   Start Of Worksheet     End End Row   End Of Worksheet     Page Up Page Up   Previous Worksheet Left 1 screen   Page Down Page Down   Next Worksheet Right 1 screen   Left Arrow Move Left Select Left Move Left Area     Right Arrow Move Right Select Right Move Right Area     Up Arrow Move Up Select Up Move Up Area     Down Arrow Move Down Select Down Move Down Area Drop down list   Space Bar Space Select Row Select Column Control Box Select All Tab Move Right Move Left Next Window Next Application Previous Window Enter   Move Up Fill Selection With Active Cell Insert Row   BackSpace   Collapse Selection To Active Cell Goto Active Cell
	You can download this as an Excel workbook here.