Windows Mac
CtrlV ⌘V

About This Shortcut 

Paste will paste everything on the clipboard, both content and formatting. Use Paste Special to selectively paste only parts of what was copied. On the Mac, Ctrl + V also works.

You can also use Enter in Windows, and fn + Return on a Mac to paste from the clipboard.

Related videos

Excel Boolean algebra in Excel

Boolean algebra in Excel

In this video, we’ll look at how boolean algebra is used for AND and OR logic in formulas. In Boolean algebra, there are only two possible results for a math operation: 1 or 0, which, as we know, correspond to the logical values TRUE and FALSE. AND logic corresponds to multiplication. Anything …
Excel Boolean operations in array formulas

Boolean operations in array formulas

In this video, we'll look at why boolean operations are important in array formulas. Boolean operations are a key building block in the world of dynamic array formulas. To illustrate, let's look at some simple order data. Given the data shown, how can we total orders from Texas using an array …
Excel How to use INDEX and MATCH with a table

How to use INDEX and MATCH with a table

In this video, we'll look at how to use INDEX and MATCH with an Excel Table. Using INDEX and MATCH with an Excel Table is wonderfully straightforward. To illustrate, I'll build INDEX and MATCH formulas that do the same thing as the VLOOKUP formulas already on this worksheet. First, to recap, these …
Excel How to set a default custom table style

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 …
Excel How to use SUMIFS with an Excel Table

How to use SUMIFS with an Excel Table

In this video, we'll look at how to use the SUMIFS function with an Excel Table. On this worksheet, I have two identical sets of order data. I'm going to walk through the process of constructing a summary of sales by item for both sets of data. With the data on the left, I'll use standard formulas …
Excel Introduction to structured references

Introduction to structured references

In this video, I'll give a brief introduction to structured references. A structured reference is a term for using a table name in a formula instead of a normal cell reference. Structured references are optional, and can be used with formulas both inside or outside an Excel table. Let's take a look …
Excel Formulas to query a table

Formulas to query a table

In this video, we'll look at some formulas you can use to query a table. Because tables support structured references, you can learn a lot about a table with basic formulas. On this sheet, Table1 contains employee data. Let's run through some examples. To start off, you can use the ROWS function to …
Excel How to group values with VLOOKUP

How to group values with VLOOKUP

In this video we'll look at how to use VLOOKUP to group data into specific categories. Let's take a look. Sometimes you need to group values into discreet categories that don't exist in your data. For example, in this case, we have a list of employees and each employee is in one department. What if …
Excel Why you should use a table for your pivot table

Why you should use a table for your pivot table

When you're building a pivot table based on data in an Excel worksheet, you should use a Table. A table offers important advantages and makes working with pivot tables a lot easier. Let's take a look. Here we have a worksheet that contains property listings. Let's quickly build a pivot table without …
Excel How to use absolute references - example 2

How to use absolute references - example 2

In simple cases, we either want our references to be absolute or relative, but there are times when we need both. Sometimes you want to copy a formula and have the column for the reference be fixed while the row changes, and vice versa. Excel has an easy way of handling this situation. Let's take a …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

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.