Ctrl + A – Select All Ctrl + B – Bold Ctrl + C – Copy Ctrl + D – Fill Ctrl + F – Find Ctrl + G – Bold Ctrl + H – Replace Ctrl + I – Italic Ctrl + K – Insert a hyperlink Ctrl + N – New workbook Ctrl + O – Open Ctrl + P – Print Ctrl + R – Nothing right Ctrl + S – Save Ctrl + U – Underlined Ctrl + V – Paste Ctrl + W – Close Ctrl + X – Cup Ctrl + Y – Repeat Ctrl + Z – Cancel F1 – Help F2 – Edition F3 – Paste the name F4 – Repeat the last action F4 – When entering a formula, switch between absolute / relative references F5 – Goto F6 – Next Pane F7 – Spell Check F8 – Extension of the mode F9 – Recalculate all workbooks F10 – Activate Menubar F11 – New graph F12 – Save As Ctrl +: – Insert the current time Ctrl +; – Insert the current date Ctrl + “– Copy the value of the cell above Ctrl + ‘– Copy the formula from the cell above Shift – Offset Adjustment for Additional Functions in the Excel Menu Shift + F1 – What is it? Shift + F2 – Edit cell comment Shift + F3 – Paste the function into the formula Shift + F4 – Search Next Shift + F5 – Find Shift + F6 – Previous Panel Shift + F8 – Add to the selection Shift + F9 – Calculate the active worksheet Shift + F10 – Popup menu display Shift + F11 – New spreadsheet Shift + F12 – Save Ctrl + F3 – Set name Ctrl + F4 – Close Ctrl + F5 – XL, size of the restore window Ctrl + F6 – Next Workbook Window Shift + Ctrl + F6 – Previous Workbook Window Ctrl + F7 – Move window Ctrl + F8 – Resize Window Ctrl + F9 – Minimize the workbook Ctrl + F10 – Maximize or Restore Window Ctrl + F11 – Inset 4.0 Macro sheet Ctrl + F1 – Open File Alt + F1 – Insert a graph Alt + F4 – Output Alt + F8 – Macro dialog Alt + F11 – Visual Basic Editor Ctrl + Shift + F3 – Create a name using the names of row and column labels Ctrl + Shift + F6 – Previous Window Ctrl + Shift + F12 – Printing Alt + Shift + F1 – New spreadsheet Alt + Shift + F2 – Save Alt + = – AutoSum Ctrl + ` – Toggle value / display of the formula Ctrl + Shift + A – Insert the argument names in the formula Alt + down arrow – automatic view list Alt + ‘ – Format Style Dialog Ctrl + Shift + ~ – General Format Ctrl + Shift +! – Comma format Ctrl + Shift + @ – Time Format Ctrl + Shift + # – Date Format Ctrl + Shift + $ – Currency Format Ctrl + Shift +% – Percentage Format Ctrl + Shift + ^ – Exponential Format Ctrl + Shift + & – Place the border of the outline around the selected cells Ctrl + Shift + _ – Delete the border of the contour Ctrl + Shift + * – Select the current region Ctrl ++ – Insert Ctrl + – – Delete Ctrl + 1 – Format of the cell dialog Ctrl + 2 – Bold Ctrl + 3 – Italic Ctrl + 4 – Underlined Ctrl + 5 – Strikethrough Ctrl + 6 – Show / Hide Objects Ctrl + 7 – Show / Hide Standard Toolbar Ctrl + 8 – Toggle Outline symbols Ctrl + 9 – Hide lines Ctrl + 0 – Hide columns Ctrl + Shift + ( – Show lines Ctrl + Shift +) – Show columns Alt or F10 – Activate the menu Ctrl + Tab – In the toolbar: Next toolbar Shift + Ctrl + Tab – In the toolbar: Previous toolbar Ctrl + Tab – In a workbook: activate the next workbook Shift + Ctrl + Tab – In a Binder: Activate Previous Binder Tab – Next tool Shift + Tab – Previous tool Enter – Make the order Shift + Ctrl + F – Font drop-down list Shift + Ctrl + F + F – Format Cell Dialog Box Font Tab Shift + Ctrl + P – Point Size Drop-down list