List of Microsoft Excel Sheet Shortcut Keys

blog

List of Microsoft Excel Sheet Shortcut Keys

 

Learn the most useful Microsoft Excel keyboard shortcuts to manage workbooks. Excel shortcuts are a fundamental component of efficient financial modeling.  Below some most useful list of Microsoft excel shortcut keys.

Ctrl+A = Select all Content
Ctrl+B = Bold all Content
Ctrl+C = Copy
Ctrl+D = Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.
Ctrl+F = Search
Ctrl+G = Go to a certain area.
Ctrl+H=  Replace & Find
Ctrl+I = Italics Content
Ctrl+K = Inserts a hyperlink.
Ctrl+N = New workbook.
Ctrl+O = Opens a workbook.
Ctrl+P = Print Sheet
Ctrl+R = Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
Ctrl+S = Saves Workbook
Ctrl+U = Underlines Content
Ctrl+V=  Pastes
Ctrl+W = Closes the current workbook
Ctrl+X = Cut
Ctrl+Y = Repeats the last entry.
Ctrl+Z = Undo the last action.
Ctrl+1 = Changes the format of the selected cells.
Ctrl+2 = Bolds all cells in the highlighted section.
Ctrl+3 = Puts italics all cells in the highlighted section.
Ctrl+4 = Underlines all cells in highlighted section.
Ctrl+5 = Puts a strikethrough all cells in the highlighted section.
Ctrl+6 = Shows or hides objects.
Ctrl+7 = Shows or hides the toolbar.
Ctrl+8 = Toggles the outline symbols.
Ctrl+9 = Hides rows.
Ctrl+0 = Hides columns.
Ctrl+Shift+: = Enters the current time.
Ctrl+; = Enters the current date.
Ctrl+` = Changes between displaying cell values or formulas in the worksheet.
Ctrl+’ = Copies a formula from the cell above.
Ctrl+Shift+” =Copies value from cell above.
Ctrl+- Deletes = the selected column or row.
Ctrl+Shift+= Inserts a new column or row.
Ctrl+Shift+~ = Switches between showing Excel formulas or their values in cells.
Ctrl+Shift+@ = 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++ =Insert.
Ctrl+- =Delete.
Ctrl+Shift+( =Unhide rows.
Ctrl+Shift+) =Unhide columns.
Ctrl+/ =Selects the array containing the active cell.
Ctrl+\ =Selects the cells that have a static value or don’t match the formula in the active cell.
Ctrl+[ =Selects all cells referenced by formulas in the highlighted section.
Ctrl+] =Selects cells that contain formulas that reference the active cell.
Ctrl+Shift+{ =Selects all cells directly or indirectly referenced by formulas in the highlighted section.
Ctrl+Shift+} =Selects cells which 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+Enter= Fills the selected cells with the current entry.
Ctrl+Spacebar =Selects the entire column.
Ctrl+Shift+Spacebar= Selects the entire worksheet.
Ctrl+Home= Move to cell A1.
Ctrl+End =Move to last cell on worksheet.
Ctrl+Tab =Move between Two or more open Excel files.
Ctrl+Shift+Tab= Activates the previous workbook.
Ctrl+Shift+A =Inserts argument names into a formula.
Ctrl+Shift+F =Opens the drop-down menu for fonts.
Ctrl+Shift+O =Selects all of the cells that contain comments.
Ctrl+Shift+P =Opens the drop-down menu for point size.
Shift+Insert =Pastes what is stored on the clipboard.
Shift+Page Up= In a single column, highlights all cells above that are selected.
Shift+Page Down= In a single column, highlights all cells above that are selected.
Shift+Home =Highlights all text to the left of the cursor.
Shift+End =Highlights all text to the right of the cursor.
Shift+Up Arrow =Extends the highlighted area up one cell.
Shift+Down Arrow = Extends the highlighted area down one cell.
Shift+Left Arrow =Extends the highlighted area left one character.
Shift +Right Arrow =Extends the highlighted area right one character.
Alt+Tab =Cycles through applications.
Alt+Spacebar =Opens the system menu.
Alt+Backpspace =Undo.
Alt+Enter =While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.
Alt+= = =Creates a formula to sum all of the above cells.
Alt+’ =Allows formatting on a dialog box.
F1 =Help
F2 =Edits the selected cell.
F3 =After a name has been created, F3 will paste names.
F4 =Repeats last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in 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 option.
Shift+F1= Opens the “What’s This?” window.
Shift+F2 =Allows the user to edit a cell comment.
Shift+F3 =Opens the Excel formula window.
Shift+F5 =Brings up a search box.
Shift+F6 =Move to previous pane.
Shift+F8 =Add to selection.
Shift+F9 =Performs calculate function on active sheet.
Ctrl+F3 =Open Excel Name Manager.
Ctrl+F4 =Closes current Window.
Ctrl+F5 =Restores window size.
Ctrl+F6 =Next workbook.
Ctrl+Shift+F6= Previous workbook.
Ctrl+F7 =Moves the window.
Ctrl+F8 =Resizes the window.
Ctrl+F9 =Minimize current window.
Ctrl+F10= Maximize currently selected window.
Ctrl+F11 =Inserts a macro sheet.
Ctrl+F12 =Opens a file.
Ctrl+Shift+F3= Creates names by using those of either row or column labels.
Ctrl+Shift+F6 =Moves to the previous worksheet window.
Ctrl+Shift+F12 =Prints
Alt+F1 =Inserts a chart.
Alt+F2 =Save As option.
Alt+F4 =Exits Excel.
Alt+F8 =Opens the macro dialog box.
Alt+F11 =Opens the Visual Basic editor.
Alt+Shift+F1= New worksheet.
Alt+Shift+=F2 Saves
Alt+h+fg =Increase Font Size

Comments

leave a comment

Your email address will not be published. Required fields are marked *

Recent Post