microsoft excel keyboard shortcuts cheat sheet

When End mode is on: (1) Use arrow keys to go to edge of current data area (2) Use Home to go to last cell (cell in lowest used row and right-most used column) of worksheet (3) Use Enter to go to last non-blank cell to the right. Check out the cheat sheet below for all the essential Excel shortcuts you should be using on Windows. At first glance, you might have a little trouble making sense of the Excel 2019 worksheet window with its many components. Excel Keyboard Shortcuts: Navigation And Selection. ALT+B: If the Bcc box is displayed, opens the Address Book. ALT B: Apply or remove the bottom border in Microsoft Excel.

Adds interactivity to the range or sheet being sent. ALT+ the underlined letter in an optn: Select an option, or select or clear a. And when you're building spreadsheet after spreadsheet every day, all of those seconds can add up. Microsoft Excel 2002 Keyboard Shortcuts: ALT+ (apostrophe) Display the Style dialog box. With these shortcuts, actions like deleting and inserting rows, which normally require multiple scrolls and clicks, can be done in a fraction of a second. Filling out spreadsheets has become synonymous with the more tedious aspects of office life, and while you may never be able to completely rid your day of Microsoft Excel, you can spend far less time in it with the help of some keyboard shortcuts.

Microsoft excel keyboard shortcuts cheat sheet