F2-------------------------------> Edit the selected cell. F5-------------------------------> Go to a specific cell. For example, C6. F7-------------------------------> Spell check selected text and/or document. F11-------------------------------> Create chart. Ctrl + Shift + ;----------------> Enter the current time. Ctrl + ;-------------------------> Enter the current date. Alt + Shift + F1----------------> Insert New Worksheet. Shift + F3-----------------------> Open the Excel formula window. Shift + F5-----------------------> Bring up search box. Ctrl + A--------------------------> Select all contents of the worksheet. Ctrl + B--------------------------> Bold highlighted selection. Ctrl + I---------------------------> Italic highlighted selection. Ctrl + K--------------------------> Insert link. Ctrl + U--------------------------> Underline highlighted selection. Ctrl + 5---------------------------> Strikethrough highlighted selection. Ctrl + P---------------------------> Bring up the print dialog box to begin printing. Ctrl + Z---------------------------> Undo last action. Ctrl + F9-------------------------> Minimize current window. Ctrl + F10------------------------> Maximize currently selected window. Ctrl + F6-------------------------> Switch between open workbooks / windows. Ctrl + Page up------------------> Move between Excel work sheets in the same Excel document. Ctrl + Page down---------------> Move between Excel work sheets in the same Excel document. Ctrl + Tab-------------------------> Move between Two or more open Excel files. Alt + =-----------------------------> Create a formula to sum all of the above cells Ctrl + '-----------------------------> Insert the value of the above cell into cell currently selected. Ctrl + Shift + !-------------------> Format number in comma format. Ctrl + Shift + $------------------> Format number in currency format. Ctrl + Shift + #------------------> Format number in date format. Ctrl + Shift + %------------------> Format number in percentage format. Ctrl + Shift + ^------------------> Format number in scientific format. Ctrl + Shift + @ ------------------> Format number in time format. Ctrl + Arrow key-----------------> Move to next section of text. Ctrl + Space----------------------> Select entire column. Shift + Space --------------------> Select entire row.
Post a Comment