Microsoft Excel Keyboard Shortcut Keys
 |
Shortcut Keys of MS Excel
|
shortcut keys list of computer
Keyboard Shortcut keys play a crucial role while working, it saves time and helps to settle on related actions quickly and simply.
Here are MS Excel Keyboard Shortcut keys which can help in choosing related actions quickly and can also make your work easy.
Shortcut Keys of MS Excel
F2: To edit the active cell.
F3: To display the paste name dialog box.
F4: To repeat the last action if possible.
F5: To display the go-to box.
F7: To open the spelling panel to see a specific range.
F11: to make a chart of knowledge within the current home in a separate sheet.
Alt+Shift+F1: To insert a new worksheet.
Alt+ F1: To create a chart of the data in the current page.
Shift+ F2: to feature or edit the cell comment.
Shift+ F3: To insert function dialog box.
Shift+ F5: To open the find and replace the panel.
Shift+ F6: to modify between the worksheet, Zoom controls, task panel, and ribbon.
Shift+ Space Bar: to pick a whole row during a worksheet.
Ctr l + Shift+ (:): To enter the present time.
Ctr l+ (;): To enter the current date.
Ctr l+ A: To select all content in the current worksheet.
Shortcut Keys of Keyboard
Ctr l+ B: To make the text Bold.
Ctr l+ C: To copy the selected cell text.
Ctr l+ I: To make the text Italic.
Ctr l+ K: To open the insert hyperlink dialog box.
Ctr l+ U: To underline the text.
Ctr l+ V: To paste the selected cell text.
Ctr l+ X: To cut the selected cell text.
Ctr l+ P: To open the print dialog box.
Ctr l+ Z: To undo the last action.
Ctr l+ 5: To apply the strikethrough formatting.
Ctr l+ 6: To alternate between hiding, displaying objects placeholders.
Ctr l+ 8: To display or hide the outlines symbols.
Ctr l+ 9: To hide the selected rows.
Ctr l+ 0: To hide the selected columns.
Shortcut Keys MS Excel |
Ctr l+ F2: To display the print preview window.
Ctr l+ F4: To close the selected workbook window.
Ctr l+ F5: To restore the window size of the selected workbook.
Ctr l+ F6: To Switch the next workbook when multiple windows are open.
Ctr l+ F9: To minimize a workbook window to an icon.
Ctr l+ F10: To maximize a selected workbook window.
Ctr l+ Page Up: To move the previous sheet in a workbook.
Ctr l+ Page Down: To move to the next sheet in a workbook.
Ctr l+ Tab: To switch to the next tab in the dialog box.
Ctr l+Shift+('): Apostrophe: To insert the value of the above cell into the selected cell.
Ctr l+Shift+(&): To apply the outline border to the selected cells.
Ctr l+Shift+(~): To apply the Number format.
Ctr l+ Shift+($): To apply the Currency format.
Ctr l+Shift+(#): To apply the Date format.
Ctr l+Shift+(%): To apply the percentage format.
Ctr l+Shift+(^): To apply the Exponential format.
Ctr l+Shift+(@): To apply the Time format.
Ctr l+ Arrow Keys: To move to the edges of the current region in a worksheet.
Ctr l+ Space Bar: to pick a whole column during a worksheet.
| shortcut keys
keyboard without using mouse Microsoft Excel Shortcut Keys ms excel shortcut keys ms excel short keys Shortcut Keys of Keyboard Shortcut Keys of MS Excel shortcut keys keyboard without using mouse MS Office |
