Mastering Shortcuts in Excel

1. Introduction
2. Topics at a Glance 00:02:02
3. Please Ask Questions Today 00:04:02
4. Presenting with Microsoft 365 for Windows 00:05:45
5. Section 1: Navigating and Selecting 00:06:56
6. Navigating Worksheets with Keyboard Shortcuts 00:07:59
7. Selecting Cell Areas with Keyboard Shortcuts 00:15:56
8. ScrollLock Navigation Interference 00:17:03
9. Section 2: Editing and Data Entry 00:19:40
10. Copying and Pasting with Keyboard Shortcuts 00:22:28
11. Filling Data with Ctrl+R and Ctrl+D 00:32:22
12. Creating a Center Text Shortcut 00:35:44
13. Section 3: Auditing and Visibility 00:43:37
14. Showing All Worksheet Formulas 00:44:06
15. Auditing Formulas with Keyboard Shortcuts 00:49:02
16. Hiding and Unhiding Columns 00:53:27
17. Hiding and Unhiding Rows  00:59:08
18. Restoring Full Screen View 01:02:07
19. Section 4: Filtering and Autofill 01:07:55
20. Filtering Data with the AutoFilter Shortcut 01:08:12
21. Adding a Clear Filter Button to the Quick Access Toolbar 01:12:12
22. Section 5: Customizing The Experience  01:13:51
23. Using Menu Keyboard Shortcuts 01:14:44
24. Creating a Lock Cell Shortcut 01:16:16
25. Reorganizing the Quick Access Toolbar 01:19:25
26. Section 6: Creating Custom Shortcuts with Macros 01:21:07
27. Creating a Yellow Highlight Macro 01:24:32
28. Adding a Highlight Macro to the QAT 01:30:23
29. Testing the Yellow Highlight Macro 01:32:05
30. Creating an Alternate Highlight Macro Shortcut 01:37:45
31. Section 7: Saving and Closing Files 01:37:58
32. Keyboard Shortcuts for Save Prompt 01:38:03
33. Microsoft 365 Save As Dialog Box 01:38:40
34. Avoiding the File Close Trap 01:38:49
35. Section 8: Quick Reference Sheet 01:39:30
36. Exploring the 50 Excel Keyboard Shortcuts Template 01:39:39
37. What We Covered 01:41:35
38. Speaker Closing 01:41:49
39. Presentation Closing 01:42:32

• 

  David H. Ringstrom, CPA

  David H. Ringstrom, CPA, is a nationally recognized instructor who leads dozens of Excel webinars each year. He is the author of Microsoft 365 Excel for Dummies and several other books. With over 30 years of consulting and teaching experience he empowers users to work more efficiently in E [...]

  View Full Profile

• Alt Key 00:36:37, 01:14:47, 01:38:21
• AutoFill 00:03:08, 01:08:04
• Autofilter 01:08:29
• Cell 00:02:24, 00:07:05, 00:08:23, 00:32:59, 00:44:16, 01:16:49
• Cell Reference 00:50:04
• Clipboard 00:22:45, 00:28:38
• Column 00:09:33, 00:28:06, 00:43:55, 00:53:34
• Control Key (CTRL) 00:09:38
• Ctrl+A 00:16:04
• Ctrl+C 00:22:45
• Ctrl + Shift + End 00:16:50
• Ctrl+V 00:23:21, 00:28:30
• Ctrl-0 (zero) 00:53:39
• Ctrl-D 00:19:55, 00:32:46
• Ctrl-End 00:08:16
• Ctrl–R 00:19:54, 00:32:46
• Dialog Box 01:04:37, 01:38:47
• Fill Handle 00:33:12
• Filter 00:02:51, 01:08:03
• Format 00:07:16, 00:16:57, 00:37:18, 01:16:32
• Formula 00:02:17, 00:23:47, 00:43:49, 00:49:41
• Keyboard Shortcut 00:00:03, 00:01:15, 00:03:49, 00:07:03, 00:08:08, 00:20:09, 00:35:50, 00:44:31, 01:08:37, 01:14:52, 01:32:17
• Macro 00:03:28, 01:21:03, 01:30:35
• Macro Recorder 00:03:17, 01:24:51
• Microsoft 365 00:05:49, 00:23:38
• Name Box 01:04:40
• Pivot Table 01:36:08
• Quick Access Toolbar 00:03:15, 00:36:23, 01:07:55, 01:12:24, 01:19:30, 01:30:26
• Ribbon 00:35:56, 01:02:24, 01:08:24, 01:14:05
• Row 00:02:57, 00:12:36, 00:43:56, 00:59:10
• Scroll Bar 00:09:11, 00:09:23
• ScrollLock Key 00:07:45, 00:10:20, 00:17:12
• Spreadsheet 00:07:31, 00:15:49, 00:23:29, 01:15:48
• Worksheet 00:07:02, 00:08:04, 00:16:16, 01:02:28, 01:14:14

Alt Key: The Alt key Alt (pronounced /ɔːlt/ AWLT or /ʌlt/ ULT) on a computer keyboard is used to change (alternate) the function of other pressed keys. Thus, the Alt key is a modifier key, used in a similar fashion to the Shift key.

AutoFill: Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.

Cell: In spreadsheet applications, a cell is a box in which you can enter a single piece of data. The data is usually text, a numeric value, or a formula. The entire spreadsheet is composed of rows and columns of cells.

Cell Reference: A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. There are three types: Relative, Absolute, and Mixed

Clipboard: A clipboard is a temporary storage area for data that the user wants to copy from one place to another. In a word processor application, for example, the user might want to cut text from one part of a document and paste it in another part of the document or somewhere else.

Column: A column is a vertical series of cells in a chart, table, or spreadsheet in Excel.

Control Key (CTRL): A Control key is a modifier key which, when pressed in conjunction with another key, performs a special operation (for example, Ctrl+C)

Ctrl + Shift + End: CTRL+SHIFT+END Extends the selection to the last used cell on the worksheet.

Ctrl+A: Selects all items in a document or window

Ctrl+C: Copies the selection to the clipboard

Ctrl-0 (zero): In Microsoft Excel, pressing Ctrl + 0 hides the column containing the active cell or multiple columns if more than one is selected.

Ctrl-End: To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press Ctrl-End.

Ctrl-R: In Microsoft Excel and other spreadsheet programs, pressing Ctrl + R fills the row cell(s) to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl + Shift + Right arrow to select additional ones.

Ctrl-V: Pastes the clipboard contents

Dialog Box: A dialog box in Excel is a screen where you input information and make choices about different aspects of the current worksheet or its content, such as data, charts, and graphic images.

Fill Handle: The little notch in the bottom right-hand corner of the selected cell or block of cells. You can drag the fill handle to copy the contents to other cells, double-click to copy contents down a column, or right-drag to reveal a hidden context menu.

Filter: The Filter feature in Excel allows you to show or hide rows within a list of data by making selections from drop-down lists. The Filter feature is available on the Data tab of all versions of Excel as well under the Sort & Filter command on the Home menu.

Format: When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc). By default, Excel uses the General format (no specific number format) for numbers.

Formula: A formula is an expression which calculates the value of a cell.

Keyboard Shortcut: A keyboard shortcut is a series of one or several keys that invoke a software program to perform a preprogrammed action. This action may be part of the standard functionality of the operating system or application program, or it may have been written by the user in a scripting language.

Macro: One or more lines of programming code that automate tasks. The Macro Recorder allows users to automate tasks without seeing the underlying programming code.

Macro Recorder: A feature in Excel that allows you to transcribe actions you take in Excel into programming code.

Microsoft 365: Microsoft 365, formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.

Name Box: The Name Box is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet. If a name is defined for a cell that is selected, the Name Box displays the name of the cell. You can use the Name Box to define a name for a selected cell as well.

Pivot Table: A report creation tool in Excel that enables you to quickly summarize lists of data into summary reports by clicking checkboxes and dragging fields onscreen.

Quick Access Toolbar: A customizable shortcut toolbar that appears above the ribbon in Office 2007 and later.

Ribbon: The "ribbon" is the strip of buttons and icons located above the work area that was first introduced in Excel 2007. The ribbon replaces the menus and toolbars found in earlier versions of Excel. Above the ribbon are a number of tabs, such as Home, Insert, and Page Layout.

Row: A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. Rows are identified by numbers e.g. row 1, row 5. Examples of use. A row might contain the headings of a table e.g. product ID, product name, price, number sold.

Scroll Bar: A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area up, down, left, or right. Scrolls through a range of values when you click the scroll arrows or when you drag the scroll box. You can move through a page (a preset interval) of values by clicking the region between the scroll box and either scroll arrow.

ScrollLock Key: The ScrollLock feature in Excel allows you to quickly alter how you can navigate your Excel workbooks

Spreadsheet: Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.

Table: A table is an arrangement of data in rows and columns, or possibly in a more complex structure. Tables are widely used in communication, research, and data analysis. Tables appear in print media, handwritten notes, computer software, architectural ornamentation, traffic signs, and many other places.

Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.