31 Spreadsheet Shortcuts in Microsoft Excel

Learning Objectives

• To identify the command that you use to activate Quick Access Toolbar shortcuts.
• To state which keyboard shortcut displays the Format Cells dialog box.
• To recall the keyboard shortcut for selecting the current region within an Excel worksheet.

Course Description

Are you working on Excel? Or is it working for you? In this online CPE webinar Excel expert David H. Ringstrom, CPA shares nearly three dozen different shortcuts for reclaiming your day in Excel. David will cover keyboard shortcuts, and mouse techniques, and will show you how to unearth hidden features within Microsoft Excel. He also offers an open forum for questions, so feel free to share what’s slowing you down in Excel.

David demonstrates every technique at least twice in this continuing education course: first, on a PowerPoint slide with numbered steps, and second, in the Microsoft 365 (formerly known as Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the online webinar as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the online continuing education course.

Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Highlights of the online CPE Excel webinar :

• Applying formatting to multiple locations within a worksheet by way of the Format Painter feature.
• Avoid frustration by understanding the nuances between the Enter and Edit modes.
• Capitalizing on keyboard shortcuts to make navigating within a table easier.
• Creating a shortcut to allow you to clear the decks in Excel by closing all open documents at once.
• Enabling a hidden keyboard shortcut for toggling the Freeze Panes feature on or off.
• Leveraging Excel’s Quick Access Toolbar to create a shortcut that enables you to filter lists with a keystroke instead of multiple mouse actions.
• Restoring “classic” Print Preview functionality in Excel 2010 and later.
• Simplifying repetitive tasks by creating your keyboard shortcuts.
• Streamlining redundant data entry with a handy keyboard shortcut.
• Streamlining repetitive tasks by way of Excel’s Quick Access Toolbar.
• Streamlining the process of printing spreadsheets. PDF format.
• Striking through list items with a custom shortcut.
• Toggling the locked status of a worksheet cell on or off by way of a custom shortcut.
• Using keyboard shortcuts to enter the current date or time.
• Utilizing keyboard shortcuts to identify precedent and dependent worksheet cells.

Overview

• Excel Versions

  4 mins
• Creating a Freeze Sheet Panes Shortcut

  14 mins
• Restoring Classic Print Preview

  16 mins
• Filtering Keyboard Shortcut

  25 mins
• Formula Auditing Keyboard Shortcut

  36 mins
• One-click Access for Creating PDF Files

  61 mins