![]() ![]() ![]() Ctrl + Shift + F4: Find the next instance of the value that you searched for.Shift + F4: Repeat the last find action.Ctrl + F4: Close the selected workbook window.F4: Display the properties of the selected object.Ctrl + F8: Turn on/off the watch window.Ctrl + Shift + F8: Turn on extend mode when a breakpoint is reached.F8: Toggle the breakpoint on the current line. ![]() Alt + F8: Open the Macro dialog box to run, edit, or delete a macro.Alt + W, U: Open the Print Preview dialog box.Alt + W, P: Open the Page Setup dialog box.Alt + W, I: Switch to the Page Break Preview view.Alt + W, F: Switch to the Page Layout view.Ctrl + `: Display the Formula Builder after you type a valid function name in a formula.Alt + F11: Open the Visual Basic Editor.Ctrl + Shift + F9: Recalculate all worksheets even if they haven't changed.Shift + F9: Calculate the active worksheet.F9: Calculate all worksheets in all open workbooks.Ctrl + Shift + ~: Apply or remove cell formatting.Ctrl + Shift + *: Apply or remove outline borders.Ctrl + Shift + Format a number as time.Ctrl + Shift + ^: Format a number as exponential.Ctrl + Shift + %: Format a number as percentage.Ctrl + Shift + #: Format a number as date.Ctrl + ': Copy the value from the cell to the left of the active cell.Ctrl + Shift + ': Copy the value from the cell above the active cell.Ctrl + End: Move to the last cell on a worksheet, in the bottom-most used row of the right-most used column.Ctrl + Home: Move to the beginning of a worksheet.Alt + Page Down: Move one screen to the right in a worksheet.Alt + Page Up: Move one screen to the left in a worksheet.Ctrl + Page Down: Move one sheet to the right in a workbook.Ctrl + Page Up: Move one sheet to the left in a workbook.Ctrl + Arrow key: Move to the edge of the current data region in a worksheet.Shift + F3: Open the Paste Name dialog box.Ctrl + Shift + F3: Create a named range using the Create Names dialog box.Just click on a category below to jump to that section. We've organized the shortcut keys by category to make it easy for you to find the ones you need. That's why we've created this cheat sheet of the most important and commonly used Excel shortcut keys. But with so many shortcut keys to remember, it can be tough to keep them all straight. If you're an Excel power user, you know that using shortcut keys can help you work faster and more efficiently. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |