OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.

Microsoft Excel Keyboard Shortcuts

A Comprehensive Guide

The ProductivityMe Company

A Brief Introduction to the Course

Come. Watch. Learn. Conquer. Excel. One Simple Lesson at a Time.

Hi and welcome.

Hi and welcome. My name is Tolan, and I am the co-founder of ProductivityMe.

I’d like to welcome you to Excel Keyboard Shortcuts, where through a series of awesome tips, tricks, and keyboard shortcuts you’ll learn to Master Microsoft Excel, one simple lesson at a time.

Through a comprehensive set of unique, fun, easy-to-follow video tutorials, you can learn to become a Microsoft Excel Power User in less than a week.

What is Included in This Course?

Read more

A Brief Introduction to the Course

Come. Watch. Learn. Conquer. Excel. One Simple Lesson at a Time.

Hi and welcome.

Hi and welcome. My name is Tolan, and I am the co-founder of ProductivityMe.

I’d like to welcome you to Excel Keyboard Shortcuts, where through a series of awesome tips, tricks, and keyboard shortcuts you’ll learn to Master Microsoft Excel, one simple lesson at a time.

Through a comprehensive set of unique, fun, easy-to-follow video tutorials, you can learn to become a Microsoft Excel Power User in less than a week.

What is Included in This Course?

  • 250+ individual lessons
  • Regular course updates
  • A dynamic, response Excel file listing all 233 keyboard shortcuts used in the course
  • A colored PDF reference guide of those 233 keyboard shortcuts
  • Instant access to course instructor

What is the Purpose of This Course?

Excel has become the industry standard for organizing, analyzing, manipulating, a storing both data and information in tabular form.

Thus, this course is designed to get you up and running as a highly-proficient Excel user by being able to use hundreds Excel's most common actions and functions in seconds.

By the end of this course, you’ll be able to use and deploy more than 230 keyboard shortcuts that will make you AWESOME at Microsoft Excel.

For example, you’ll learn shortcuts like:

  • Shift + F11 Inserting a New Worksheet (Lesson 04.01)
  • Ctrl + Shift + "=" Inserting Rows or Columns (Lesson 05.02 or Lesson 05.03)
  • Shift + Spacebar Selecting an Entire Row (Lesson 07.01)
  • Ctrl + Spacebar Selecting an Entire Column (Lesson 07.02)
  • Ctrl + Enter Entering the Same Data in Multiple Cells (Lesson 11.06)
  • Ctrl + Alt + V Displaying the Paste Special Dialog Box (Lesson 14.10)
  • Ctrl + Shift + ~ Applying General Format (Lesson 17.01)
  • Alt + = Autosumming Selected Cells (Lesson 18.04)
  • Ctrl + ` Toggling Formulas On and Off (Lesson 18.05)
  • F11 Creating a Chart in New Worksheet (Lesson 19.10)
  • Alt + F8 Opening the Macro Dialog Box (Lesson 20.06)

More generally, you'll be able to apply keyboard shortcuts for actions such as:

  • Autosumming cell values & instantly changing their formatting
  • Adding, formatting, and removing cell borders in a flash
  • Hiding, grouping, adding, deleting columns and rows
  • Moving to the next cell, worksheet, or workbook
  • Copying, moving, or deleting a cell, a selection, or a worksheet in Excel
  • Expanding or reducing your active selection by one or more cells, columns, or rows
  • Instantly creating new tables, filters, charts, and PivotTables
  • Launching macros & the VBA Editor with two simple clicks
  • And much, much more

Consistent Lesson Structure:

  1. First, we'll provide an introduction to what we’ll cover in the lesson
  2. Then we'll show you the keyboard shortcut
  3. Next we'll show you how to achieve the same result without using the specific shortcut
  4. Then. we'll review what we covered in the lesson
  5. And lastly, we'll discuss what is coming up in the next lesson

See you in a few.

Cheers,

Tolan & RyanCourse Instructors & ProductivityMe Co-Founders

Enroll now

What's inside

Syllabus

Course Basics
Welcome to the Course!
DOWNLOAD: Referenceable PDF and Excel File
OPTIONAL LECTURE: Long Discussion Course Structure & Design
Read more
OPTIONAL LECTURE: Long Discussion on What's in the Course
Using the File Menu (01.00) Using the Ribbon (02.00)
01.00 - (Section 1) - Introduction to Using the File Menu
01.01 - (Ctrl + N) - Creating a New Workbook
01.02 - (Ctrl + O) - Opening a Workbook
01.03 - (Ctrl + S) - Saving a Workbook
01.04 - (F12) - Using the "Save-As" Feature
01.05 - (Ctrl + P) - Printing a File
01.06 - (Ctrl + F2) - Opening the Print Preview Window
01.07 - (Win + ↓) - Restoring Down a Maximized Excel Window
01.08 - (Win + ↓) - Minimizing a Non-Full Sized Excel Window
01.09 - (Win + ↑) - Maximizing a Non-Full Sized Excel Window
01.10 - (Ctrl + F4) - Closing the Current Workbook
01.11 - (Alt + F4) - Closing the Excel Application Entirely
02.00 - (Section 2) - Introduction to Using the Ribbon in Excel
02.01 - (Ctrl + F1) - Expanding or Collapsing Ribbon Commands
02.02 - (Ctrl + Shift + F1) - Expanding or Collapsing Ribbon Commands & Tabs
02.03 - (Alt) - Activating the Access Keys
02.04 - (Tab) - Moving to the Next Ribbon Control on a Tab
02.05 - (Shift + Tab) - Moving to the Previous Ribbon Control on a Tab
02.06 - (Esc) - Moving Up One Level within Ribbon Menu's Hierarchy
02.07 - (Spacebar) - Activating or Opening Selected Control(s)
02.08 - (Enter) - Confirming a Control Change
02.09 - (F1) - Getting Help on Selected Control(s)
02.10 - (Customize Q.A.T.) - Customizing the Ribbon in Excel
02.11 - (Customize Q.A.T.) - Customizing the Quick Access Toolbar (Q.A.T.)
Using Menus & Dialog Boxes (03.00)
03.00 - (Section 3) - Introduction to Using Menus & Dialog Boxes
03.01 - (Shift + F10) - Displaying the Shortcut Menu
03.02 - (Alt + Spacebar) - Displaying the Control Menu
03.03 - (Tab) - Moving to Next Control
03.04 - (Shift + Tab) - Moving to Previous Control
03.05 - (Ctrl + Tab) - Moving to Next Tab
03.06 - (Ctrl + Shift + Tab) - Moving to Previous Tab
03.07 - (Spacebar) - Checking or Unchecking a Box
03.08 - (Enter) - Choosing to Accept and Apply Changes
03.09 - (Esc) - Canceling and Closing a Dialog Box
03.10 - (Alt + ') - Displaying the Modify Cell Style Dialog Box
Using Workbooks (04.00)
04.00 - (Section 4) - Introduction to Using Workbooks
04.01 - (Shift + F11) - Inserting a New Worksheet
04.02 - (Ctrl + Page Down) - Going to Next Worksheet
04.03 - (Ctrl + Page Up) - Going to Previous Worksheet
04.04 - (F6) - Moving to Next Pane
04.05 - (Shift + F6) - Moving to Previous Pane
04.06 - (Ctrl + Tab) - Going to Next Workbook
04.07 - (Ctrl + Shift + Tab) - Going to Previous Workbook
04.08 - (Ctrl + F9) - Minimizing Current Workbook Window
04.09 - (Shift + Left Click) - Selecting Adjacent Worksheet(s)
04.10 - (Ctrl + Left Click) - Selecting Non-Adjacent Worksheet(s)
04.11 - (Customize Q.A.T.) - Hiding a Worksheet
04.12 - (Customize Q.A.T.) - Unhiding a Worksheet
04.13 - (Alt ... O ... HR) - Renaming a Worksheet
04.14 - (Alt ... E ... M) - Moving a Worksheet
04.15 - (Alt ... E ... M) - Copying a Worksheet
04.16 - (Alt ... E ... L) - Deleting a Worksheet
Modifying Columns & Rows (05.00)
05.00 - (Section 5) - Introduction to Modifying Columns & Rows
05.01 - (Ctrl + Shift + "=") - Displaying the Insert Dialog Box
05.02 - (Ctrl + Shift + "=") - Inserting Rows
05.03 - (Ctrl + Shift + "=") - Inserting Columns
05.04 - (Ctrl + "-") - Displaying the Delete Dialog Box
05.05 - (Ctrl + "-") - Deleting Rows
05.06 - (Ctrl + "-") - Deleting Columns
05.07 - (Ctrl + "-") - Deleting Cells
05.08 - (Delete) - Deleting Contents of Selected Cells
05.09 - (Ctrl + 0) - Hiding Columns
05.10 - (Ctrl + Shift + 0) - Unhide Columns
05.11 - (Ctrl + 9) - Hiding Rows
05.12 - (Ctrl + Shift + 9) - Unhide Rows
05.13 - (Alt + Shift + →) - Grouping Columns or Rows
05.14 - (Alt + Shift + ←) - Ungrouping Columns or Rows
05.15 - (Alt + Shift + →) - Opening the Group Dialog Box
05.16 - (Alt + Shift + ←) - Opening the Ungroup Dialog Box
05.17 - (Ctrl + 8) - Hiding or Showing the Outline Symbols for Groups
Navigating within Excel (06.00)
06.00 - (Section 6) - Introduction to Navigating within Excel
06.01 - (→) - Moving One Cell to the Right
06.02 - (←) - Moving One Cell to the Left
06.03 - (↑) - Moving One Cell Up
06.04 - (↓) - Moving One Cell Down
06.05 - (Alt + Page Down) - Moving One Screen to the Right
06.06 - (Alt + Page Up) - Moving One Screen to the Left
06.07 - (Page Down) - Moving One Screen Down
06.08 - (Page Up) - Moving One Screen Up
06.09 - (Ctrl + →) - Moving to the Right Edge of Data Region
06.10 - (Ctrl + ←) - Moving to the Left Edge of Data Region
06.11 - (Ctrl + ↑) - Moving to the Top Edge of Data Region
06.12 - (Ctrl + ↓) - Moving to the Bottom Edge of Data Region
06.13 - (Home) - Moving to the Beginning of a Row
06.14 - (End) - Turning “End Mode” On or Off
06.15 - (Ctrl + End) - Moving to the Last Cell in a Worksheet
06.16 - (Ctrl + Home) - Moving to the First Cell in a Worksheet
Making a Selection (08.00)
07.00 - (Section 7) - Introduction to Making a Selection
07.01 - (Shift + Spacebar) - Selecting an Entire Row

Save this course

Save Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide with these activities:
Review Basic Excel Functions
Strengthen your understanding of fundamental Excel functions. This will provide a solid base for efficiently using keyboard shortcuts to manipulate these functions.
Browse courses on SUM
Show steps
  • Identify the most common Excel functions you use.
  • Practice using these functions with sample data.
  • Review the syntax and purpose of each function.
Shortcut Flashcards
Memorize keyboard shortcuts through spaced repetition. This will improve recall speed and muscle memory.
Show steps
  • Create flashcards with the shortcut on one side and the action on the other.
  • Review the flashcards regularly, focusing on the ones you struggle with.
  • Use the shortcuts in Excel while reviewing to reinforce learning.
Create a Cheat Sheet
Compile a personalized cheat sheet of the most useful shortcuts. This will serve as a quick reference guide and reinforce learning.
Show steps
  • Identify the shortcuts you use most frequently.
  • Organize the shortcuts by category (e.g., formatting, navigation).
  • Design a visually appealing and easy-to-read cheat sheet.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Read 'Excel 2019 Bible'
Expand your knowledge of Excel features and functions. This will help you understand the context and purpose of various keyboard shortcuts.
View Putting Knowledge to Work on Amazon
Show steps
  • Browse the table of contents to identify relevant sections.
  • Read the sections related to the Excel features covered in the course.
  • Experiment with the features and shortcuts in Excel.
Automate a Task with Shortcuts
Apply learned shortcuts to automate a repetitive Excel task. This will demonstrate practical application and improve efficiency.
Show steps
  • Identify a repetitive task you perform in Excel.
  • Determine which shortcuts can be used to automate the task.
  • Create a step-by-step guide using the shortcuts.
  • Test and refine the automated process.
Read 'Microsoft Excel Functions & Formulas'
Deepen your understanding of Excel functions and formulas. This will allow you to use shortcuts more effectively to create complex calculations.
View Microsoft Excel Functions and Formulas with... on Amazon
Show steps
  • Review the chapters on the functions you use most often.
  • Practice using the functions and formulas with sample data.
  • Explore the advanced functions and formulas to expand your knowledge.
Help Others with Excel Shortcuts
Reinforce your knowledge by teaching Excel shortcuts to others. This will solidify your understanding and identify any gaps in your knowledge.
Show steps
  • Offer to help colleagues or friends with Excel tasks.
  • Explain the relevant shortcuts and demonstrate their use.
  • Answer questions and provide guidance as needed.

Career center

Learners who complete Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide will develop knowledge and skills that may be useful to these careers:
Accountant
An accountant prepares and examines financial records. They ensure accuracy of financial information. Accountants utilize Excel to manage financial data, reconcile accounts, and create financial reports. This course on Excel keyboard shortcuts helps the accountant streamline their workflow and improve accuracy. The ability to quickly navigate spreadsheets, format data, and perform calculations is invaluable for day-to-day tasks. By using shortcuts for actions, such as autosumming cell values and instantly changing their formatting, an accountant can save time and reduce errors.
See salaries and explore the career path for Accountant
Budget Analyst
A budget analyst assists organizations in planning and managing their finances. They develop budgets, monitor spending, and analyze financial data to ensure efficient resource allocation. This course on Excel keyboard shortcuts helps the budget analyst to speed up their work with spreadsheets and financial models. Mastery of these shortcuts helps the budget analyst to create and manipulate budgets, forecast expenses, and analyze variances quickly. The shortcuts for actions, such as autosumming cell values and instantly changing their formatting, are particularly valuable.
See salaries and explore the career path for Budget Analyst
Data Analyst
A data analyst examines and interprets data to identify trends and insights. This work often involves using tools like Excel to clean, organize, and analyze datasets. This course on Excel keyboard shortcuts helps the data analyst to significantly improve their efficiency and speed while working with large datasets. Mastering these shortcuts allows the data analyst to perform complex operations quickly, such as data manipulation, formatting, and creating charts, which are essential for presenting findings. Being able to use more than 230 keyboard shortcuts is an asset to any data analyst.
See salaries and explore the career path for Data Analyst
Financial Analyst
A financial analyst uses Excel extensively for financial modeling, forecasting, and data analysis. They evaluate past and current financial data to make predictions about future performance. This course on Excel keyboard shortcuts helps the financial analyst to streamline their workflow and improve accuracy. The time-saving shortcuts covered help the financial analyst to manage large spreadsheets, create complex formulas, and generate reports efficiently. Skills such as autosumming cell values and instantly changing their formatting are vital to the financial analyst.
See salaries and explore the career path for Financial Analyst
Auditor
An auditor reviews financial records to ensure compliance and accuracy. They use Excel extensively to analyze financial data, identify discrepancies, and prepare audit reports. This course on Excel keyboard shortcuts helps the auditor to improve their efficiency when reviewing large datasets. The ability to navigate spreadsheets, select data, and perform calculations quickly facilitates the audit process. Auditors can deploy keyboard shortcuts for actions, such as adding, formatting, and removing cell borders in a flash, which ensure efficient data validation and analysis.
See salaries and explore the career path for Auditor
Business Intelligence Analyst
A business intelligence analyst leverages data to provide insights that inform business decisions. They are often tasked with creating dashboards and reports to visualize data trends. This course on Excel keyboard shortcuts helps the business intelligence analyst to quickly manipulate data, create visuals, and generate reports. Excel is an indispensable tool for them. The ability to navigate spreadsheets and select data quickly makes them more productive. The quick creation of new tables, filters, charts, and pivot tables is of enormous utility.
See salaries and explore the career path for Business Intelligence Analyst
Operations Analyst
An operations analyst works to improve an organization's efficiency and effectiveness by analyzing processes and data. They use Excel to create models, analyze data, and develop reports that drive operational improvements. This course on Excel keyboard shortcuts helps the operations analyst to enhance their data analysis and modeling skills. Being able to use more than 230 keyboard shortcuts helps perform common actions and functions quickly. Excel keyboard shortcuts will streamline work.
See salaries and explore the career path for Operations Analyst
Data Entry Clerk
A data entry clerk inputs and updates data into computer systems and databases. They use Excel for organizing and managing data. This course on Excel keyboard shortcuts helps the data entry clerk to improve speed and accuracy in data entry tasks. The ability to quickly navigate spreadsheets, select data, and perform basic data manipulation helps streamline the data entry process. The shortcuts for actions, such as copying, moving, or deleting a cell, a selection, or a worksheet in Excel, are extremely helpful.
See salaries and explore the career path for Data Entry Clerk
Research Assistant
A research assistant supports researchers by collecting, organizing, and analyzing data. They help to manage data to create reports. This course on Excel keyboard shortcuts helps the research assistant to improve efficiency in these tasks. The ability to use shortcuts for data manipulation, formatting, and analysis helps them contribute more effectively to research projects. Skills such as autosumming cell values and instantly changing their formatting are helpful to the research assistant.
See salaries and explore the career path for Research Assistant
Project Manager
A project manager uses Excel for task management, resource allocation, and project tracking. They rely upon spreadsheets to organize project data, monitor progress, and generate reports. This course on Excel keyboard shortcuts helps the project manager to streamline their project management processes. The ability to quickly navigate spreadsheets, update task statuses, and generate reports helps in efficient project monitoring. They can deploy shortcuts for actions, such as hiding, grouping, adding, and deleting columns and rows.
See salaries and explore the career path for Project Manager
Administrative Assistant
An administrative assistant provides support to ensure efficient office operations. They use Excel for various tasks, including data entry, organizing information, and creating reports. This course on Excel keyboard shortcuts helps the administrative assistant to improve their productivity and accuracy. The ability to quickly navigate spreadsheets, format data, and perform calculations streamlines many administrative tasks. Shortcuts such as copying, moving, or deleting a cell, a selection, or a worksheet in Excel, are useful.
See salaries and explore the career path for Administrative Assistant
Actuary
An actuary assesses and manages financial risks, often in the insurance and finance industries. They analyze statistical data to estimate probabilities of events such as death, sickness, injury, disability, or loss of property. Actuaries frequently use very large spreadsheets. Skills such as autosumming cell values and instantly changing their formatting are very useful. An actuary typically has an advanced degree (master's or phd, for example).
See salaries and explore the career path for Actuary
Statistician
A statistician collects, analyzes, and interprets numerical data to identify significant trends and relationships. While statisticians may use more specialized statistical software, Excel often serves as a preliminary tool for data exploration and manipulation. This course on Excel keyboard shortcuts may be useful for statisticians, helping them to quickly clean, organize, and explore datasets. This course will help statisticians to manipulate data, such as expanding or reducing your active selection by one or more cells, columns, or rows.
See salaries and explore the career path for Statistician
Market Research Analyst
A market research analyst studies market conditions to examine potential sales of a product or service. They collect and analyze data on consumer demographics, preferences, needs, and buying habits. This course on Excel keyboard shortcuts may be useful for market research analysts, helping them to efficiently manage and analyze large sets of survey data and consumer information. The ability to use shortcuts for filtering data and creating charts quickly aids in identifying market trends. An analyst can use the shortcut training to speed up data processing and analysis.
See salaries and explore the career path for Market Research Analyst
Management Consultant
A management consultant advises organizations on how to improve their efficiency and effectiveness. This often involves analyzing data and creating reports to support recommendations; Excel is often a key tool. This course on Excel keyboard shortcuts may be useful for the management consultant, helping them to quickly process and analyze data. The skills learned help them to manipulate data efficiently. The ability to instantly create new tables, filters, charts, and PivotTables can be helpful in preparing presentations.
See salaries and explore the career path for Management Consultant

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide.
Cover image
Microsoft Excel Functions and Formulas
Save
Provides a comprehensive overview of Excel functions and formulas. It is helpful for understanding the underlying logic and syntax of these functions, which can be manipulated more efficiently using keyboard shortcuts. This book is particularly useful for those who want to deepen their understanding of Excel's capabilities. It is more valuable as additional reading than as a current reference.
Microsoft Excel Functions and Formulas with Excel...
Perfect Paperback
$$$
Microsoft Excel Functions and Formulas
Perfect Paperback
$$
Microsoft Excel Functions and Formulas: With Excel...
Kindle Edition
$$
Cover image
Putting Knowledge to Work
Save
The 'Excel 2019 Bible' comprehensive guide to all things Excel. While it covers a broad range of topics, it provides in-depth explanations of Excel's features and functions, including those that can be accessed and manipulated using keyboard shortcuts. useful reference for understanding the underlying functionality behind the shortcuts taught in the course. It is more valuable as additional reading to deepen understanding.
Putting Knowledge to Work
Paperback
Check
Putting Knowledge to Work
Kindle Edition
Check

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Similar courses are unavailable at this time. Please try again later.
Effort
17 total hours
Via
Udemy
Instructor
The ProductivityMe Company
Language
English
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser