Hi All,
Today every professional person aware that how use Microsoft Excel for work in office.
So with using keyboard shortcut we can finish the work more speedy. So that here I am provide you the all keyboard shortcut used for Microsoft excel.
So with using keyboard shortcut we can finish the work more speedy. So that here I am provide you the all keyboard shortcut used for Microsoft excel.
- CTRL+A Selects the entire worksheet.
- CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
- CTRL+B Applies or removes bold formatting.
- CTRL+C Copies the selected cells.
- CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
- CTRL+PgUp Switches between worksheet tabs, from left-to-right.
- CTRL+PgDn Switches between worksheet tabs, from right-to-left.
- CTRL+SHIFT+( Unhides any hidden rows within the selection.
- CTRL+SHIFT+& Applies the outline border to the selected cells.
- CTRL+SHIFT_ Removes the outline border from the selected cells.
- CTRL+SHIFT+~ Applies the General number format.
- CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
- CTRL+SHIFT+% Applies the Percentage format with no decimal places.
- CTRL+SHIFT+^ Applies the Scientific number format with two decimal places.
- CTRL+SHIFT+# Applies the Date format with the day, month, and year.
- CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.
- CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
- CTRL+SHIFT+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).In a PivotTable, it selects the entire PivotTable report.
- CTRL+SHIFT+: Enters the current time.
- CTRL+SHIFT+" Copies the value from the cell above the active cell into the cell or the Formula Bar.
- CTRL+SHIFT+Plus (+) Displays the Insert dialog box to insert blank cells.
- CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells.
- CTRL+; Enters the current date.
- CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.
- CTRL+' Copies a formula from the cell above the active cell into the cell or the Formula Bar.
- CTRL+1 Displays the Format Cells dialog box.
- CTRL+2 Applies or removes bold formatting.
- CTRL+3 Applies or removes italic formatting.
- CTRL+4 Applies or removes underlining.
- CTRL+5 Applies or removes strikethrough.
- CTRL+6 Alternates between hiding and displaying objects.
- CTRL+8 Displays or hides the outline symbols.
- CTRL+9 Hides the selected rows.
- CTRL+0 Hides the selected columns.
- CTRL+F Displays the Find and Replace dialog box, with the Find tab selected.
- SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.
- CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
- CTRL+G Displays the Go To dialog box.
- F5 also displays this dialog box.
- CTRL+H Displays the Find and Replace dialog box, with the Replace tab selected.
- CTRL+I Applies or removes italic formatting.
- CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
- CTRL+L Displays the Create Table dialog box.
- CTRL+N Creates a new, blank workbook.
- CTRL+O Displays the Open dialog box to open or find a file.
- CTRL+SHIFT+O selects all cells that contain comments.
- CTRL+P Displays the Print tab in Microsoft Office Backstage view.
- CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
- CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
- CTRL+S Saves the active file with its current file name, location, and file format.
- CTRL+T Displays the Create Table dialog box.
- CTRL+U Applies or removes underlining.
- CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
- CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
- CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
- CTRL+W Closes the selected workbook window.
- CTRL+X Cuts the selected cells.
- CTRL+Y Repeats the last command or action, if possible.
- CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.
0 comments:
Post a Comment