Developed by iConnect Solution. Home Training Syllabus About Contact. MS Excel Shortcuts Using shortcuts saves a lot of time and it shows your proficiency in application usage. Selects the entire column. Selects the entire worksheet. Move to cell A1. Move to the last cell on a worksheet. Move between Two or more open Excel files. Activates the previous workbook.
Inserts argument names into a formula. Selects all of the cells that contain comments. Opens the drop-down menu for the point size. Pastes what is stored on the clipboard. In a single column, highlights all cells above that which are selected. Highlights all text to the right of the cursor. Extends the highlighted area up to one cell. Extends the highlighted area down one cell. Extends the highlighted area left one character.
Extends the highlighted area right one character. Cycles through applications. Opens the system menu. It creates a formula to sum all of the above cells. Allows formatting on a dialog box. Opens the Help menu. Repeats the last action. For example, if you changed the color of the text in another cell, pressing F4 will change the text in a cell to the same color. Goes to a specific cell.
For example, C6. Spell check selected text or document. Enters Extend Mode. Recalculates every workbook. Save as. It allows the user to edit a cell comment. Brings up a search box. Move to the previous pane. Add to selection. Performs calculate function on the active sheet. Closes current Window. Restores window size. Next workbook. Previous workbook. Moves the window. Resizes the window. Minimize the current window. Maximize the currently selected window.
Inserts a macro sheet. Opens a file. Creates names by using those of either row or column labels. Moves to the previous worksheet window. Prints the current worksheet. Inserts a chart. Exits Excel. Opens the macro dialog box. Opens the Visual Basic editor. Creates a new worksheet. There must be data in the Clipboard for command to be available. Within Formula Bar or cell in cell-editing mode , deletes 1 character to the right or deletes the selection if any.
Positions the insertion point at the end of cell contents. When Allow editing directly in cells is turned off, moves the insertion point to the Formula Bar. Within cell of Formula Bar, complete cell entry and by default go to the cell above. Tab is also under the Navigation and Selection and Formulas and Functions categories. Toggle between 1 displaying cell values and 2 displaying formulas in worksheet. The Paste all merging conditional formats option is only enabled when copying a range that contains conditional formatting.
Display the Format Cells dialog box with the Number tab and the Accounting category selected. Display the Merge Styles dialog box to merge copy cell styles from another workbook.
Expand the menu to set a conditional formatting rule using data bars with gradient or solid fill. Display the New Conditional Formatting Rule dialog box, with the Format all cells based on their values rule type selected. Display the A Data Occurring dialog box to conditionally format cells whose date occurs within the time period set in the rule. Display the Between dialog box to conditionally format cells whose value is between the values set in the rule.
Display the Duplicate Values dialog box to conditionally format cells with duplicate or unique values in the selected cell range. Display the Equal To dialog box to conditionally format cells whose value is equal to the value set in the rule. Display the Greater Than dialog box to conditionally format cells whose value is greater than the value set in the rule.