About This Shortcut
Pressing the escape key while editing a cell aborts the operation and leaves the cell in it's original state.
Demo
Cancel selection
Related videos
FILTER with boolean logic
In this video we'll look how to use the FILTER function with Boolean logic to apply multiple criteria.
In this worksheet we have some sample order data in a table called "data".
Let's use the FILTER function to find all "blue" orders in June.
To visualize how this works I'm going to set up the logic …
FILTER data between two dates
In this video, we’ll look at a couple ways to use the FILTER function to extract data between dates.
In this worksheet, we have sample order data that contains a date field.
Let's set up the FILTER function to extract data between two dates.
Before we begin, I want to remind you that Excel dates are …
How to perform a random sort
In this video, we’ll look at how to perform a random sort with the SORTBY function, with help from the RANDARRAY function.
In this worksheet, we have the first 10 letters in the alphabet in the range B5:B14.
How can we sort this data in random order?
One way to do this is to add a helper column and …
How to count unique values
In this video, we'll look at how to count the unique values returned by the UNIQUE function.
Before dynamic array formulas, counting unique values in Excel involved complex array formulas, especially if you needed to count values based on one or more conditions.
Now that dynamic array formulas, and …
How to set a default custom table style
In this video, we'll look at how to make a custom table style the default table style in new workbooks.
Setting a custom table style as the default table style is a little tricky.
You need to create an Excel template that contains the custom style, and then make sure Excel uses the template when it …
How to make a histogram chart
In this video, we'll look at how to create a histogram chart.
A histogram chart displays the count of items grouped into bins using columns.
Starting in Excel 2016, the histogram chart is a built-in option.
In this worksheet, I've got a list of 100 names and ages.
Let's plot this data in a histogram …
How to add a secondary axis to a chart
In this video, we'll look at how to add a secondary axis to chart.
Here we have some website data that includes orders and the conversion rates for five different channels.
Let me first insert a column chart to plot orders per channel.
Now, let's say I'd like to also add the conversion rate into …
How to move data in Excel
In this lesson, we'll look at how to move data from one place to another in Excel. The most common way to move information is to use cut and paste. We'll cover three options: using buttons on the ribbon, using keyboard shortcuts, and using the right-click menu.
Let's take a look.
The most basic way …
How to duplicate data in Excel
In this lesson, we'll look at how to duplicate information in Excel. The most common way to duplicate information is to use copy and paste. We'll look at three options: using the buttons on the ribbon, using keyboard shortcuts, and using the right-click menu.
Let's take a look.
The most basic way to …
How to enter data in Excel
In this lesson, we'll look at the most basic way to enter data in an Excel worksheet—by typing. In future lessons, we'll look at a number of shortcuts for entering data faster.
To enter data in Excel, just select a cell and begin typing. You'll see the text appear both in the cell and in the formula …
Author
Dave Bruns
Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
Your website is not only simply the best but my #1 site to go if I have any Excel questions. I am working on a rather complex dashboard and I know what I wanted to do but forgot how to do it. Rank without ties...wonderful ...straight to the point...very clear and user friendly.
Ekki
Get Training
Quick, clean, and to the point training
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.
View Paid Training & Bundles
