• Breaking News

    List of Excel formulas and functions

    List of Excel formulas and functions

    Functions Keys in Microsoft Excel

    Excel Shortcut The Definition of the shortcut
    F1 Opens the Help menu.
    F2 Edits the selected cell.
    F3 After a name has been created, F3 will paste names.
    F4 Repeats the last action. For example, if you changed the color of the text in another cell, pressing F4 will change the text in the cell to the same color.
    F5 Goes to a specific cell. For example, C6.
    F6 Move to the next pane.
    F7 Spell check selected text or document.
    F8 Enters Extend Mode.
    F9 Recalculates every workbook.
    F10 Activates the menu bar.
    F11 Creates a chart from selected data.
    F12 Save as.

    Excel Shortcut keys for Ctrl + Alphabet

    Ctrl+A Select all contents of a worksheet.
    Ctrl+B Bold all cells in the highlighted section.
    Ctrl+D Fill Content of the selected cell from top to bottom. CTRL + D (i.e. Ctrl+ Down)
    Ctrl+F Search current sheet.
    Ctrl+G Go to a certain area.
    Ctrl+H Find and replace.
    Ctrl+I Puts italics on all cells in the highlighted section.
    Ctrl+K Inserts a hyperlink.
    Ctrl+P Print the current sheet.
    Ctrl+R Fill Right.
    Ctrl+S Saves the open worksheet.
    Ctrl+U Underlines all cells in the highlighted section.
    Ctrl+V Pastes everything copied onto the clipboard.
    Ctrl+W Closes the current workbook.
    Ctrl+X Cuts all cells within the highlighted section.
    Ctrl+Y Repeats the last entry.
    Ctrl+Z Undo the last action.

    Excel Shortcut Keys for Alt+

    Alt+’Allows formatting on a dialog box.
    Alt+=Creates a formula to sum all of the above cells.
    Alt+BackpspaceUndo.
    Alt+EnterWhile typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.
    Alt+F1Inserts a chart.
    Alt+F11Opens the Visual Basic editor.
    Alt+F2Save as.
    Alt+F4Exits Excel.
    Alt+F8Opens the macro dialog box.
    Alt+Shift+F1Creates a new worksheet.
    Alt+Shift+F2Saves the current worksheet.
    Alt+SpacebarOpens the system menu.
    Alt+TabCycles through applications.

    Excel Shortcut Keys for Ctrl + Numbers

    Ctrl+1Changes the format of the selected cells.
    Ctrl+2Bolds all cells in the highlighted section.
    Ctrl+3Puts italics on all cells in the highlighted section.
    Ctrl+4Underlines all cells in the highlighted section.
    Ctrl+5Puts a strikethrough all cells in the highlighted section.
    Ctrl+6Shows or hides objects.
    Ctrl+7Shows or hides the toolbar.
    Ctrl+8Toggles the outline symbols.
    Ctrl+9Hides rows.
    Ctrl+0Hides columns.

    Excel Shortcut Keys for Ctrl + Shift

    Ctrl+Shift+:Enters the current time.
    Ctrl+Shift+”Copies value from the cell above.
    Ctrl+Shift+=Inserts a new column or row.
    Ctrl+Shift+~Switches between showing Excel formulas or their values in cells.
    [email protected]Applies time formatting.
    Ctrl+Shift+!Applies comma formatting.
    Ctrl+Shift+$Applies currency formatting.
    Ctrl+Shift+#Applies date formatting.
    Ctrl+Shift+%Applies percentage formatting.
    Ctrl+Shift+^Applies exponential formatting.
    Ctrl+Shift+*Selects the current region around the active cell.
    Ctrl+Shift+&Places border around selected cells.
    Ctrl+Shift+_Removes a border.
    Ctrl+Shift+(Unhide rows.
    Ctrl+Shift+)Unhide columns.
    Ctrl+Shift+{Selects all cells directly or indirectly referenced by formulas in the highlighted section.
    Ctrl+Shift+}Selects cells that contain formulas that directly or indirectly reference the active cell.
    Ctrl+Shift+| (pipe)Selects the cells within a column that don’t match the formula or static value in the active cell.
    Ctrl+Shift+SpacebarSelects the entire worksheet.
    Ctrl+Shift+TabActivates the previous workbook.
    Ctrl+Shift+AInserts argument names into a formula.
    Ctrl+Shift+FOpens the drop-down menu for fonts.
    Ctrl+Shift+OSelects all of the cells that contain comments.
    Ctrl+Shift+POpens the drop-down menu for the point size.
    Ctrl+Shift+F6Previous workbook.
    Ctrl+Shift+F3Creates names by using those of either row or column labels.
    Ctrl+Shift+F6Moves to the previous worksheet window.
    Ctrl+Shift+F12Prints the current worksheet.

    Excel Shortcut Keys for Ctrl+

    Ctrl+-Deletes the selected column or row.
    Ctrl+-Delete.
    Ctrl+/Selects the array containing the active cell.
    Ctrl+;Enters the current date.
    Ctrl+[Selects all cells referenced by formulas in the highlighted section.
    Ctrl+\Selects the cells that have a static value or don’t match the formula in the active cell.
    Ctrl+]Selects cells that contain formulas that reference the active cell.
    Ctrl+`Changes between displaying cell values or formulas in the worksheet.
    Ctrl+’Copies a formula from the cell above.
    Ctrl++Insert.
    Ctrl+EndMove to the last cell on the worksheet.
    Ctrl+EnterFills the selected cells with the current entry.
    Ctrl+F10Maximize the currently selected window.
    Ctrl+F11Inserts a macro sheet.
    Ctrl+F12Opens a file.
    Ctrl+F3Open Excel Name Manager.
    Ctrl+F4Closes current Window.
    Ctrl+F5Restores window size.
    Ctrl+F6Next workbook.
    Ctrl+F7Moves the window.
    Ctrl+F8Resizes the window.
    Ctrl+F9Minimize the current window.
    Ctrl+HomeMove to cell A1.
    Ctrl+SpacebarSelects the entire column.
    Ctrl+TabMove between Two or more open Excel files.

    Excel Shortcut Keys for Shift+

    Alt+Shift+F1Creates a new worksheet.
    Alt+Shift+F2Saves the current worksheet.
    Shift +Right ArrowExtends the highlighted area right one character.
    Shift+Down ArrowExtends the highlighted area down one cell.
    Shift+EndHighlights all text to the right of the cursor.
    Shift+F1Opens the “What’s This?” window.
    Shift+F2Allows the user to edit a cell comment.
    Shift+F3Opens the Excel formula window.
    Shift+F5Brings up a search box.
    Shift+F6Move to the previous page.
    Shift+F8Add to selection.
    Shift+F9Performs calculate function on the active sheet.
    Shift+HomeHighlights all text to the left of the cursor.
    Shift+InsertPastes what is stored on the clipboard.
    Shift+Left ArrowExtends the highlighted area left one character.
    Shift+Page DownIn a single column, highlights all cells above that which are selected.
    Shift+Page UpIn a single column, highlights all cells above that which are selected.
    Shift+Up ArrowExtends the highlighted area up to one cell.

    No comments

    View My Stats