Exceljet

Quick, clean, and to the point

Display the Paste Special dialog box

Windows shortcut 
CtrlAltV
Mac shortcut 
V

Use this shortcut to display the Paste Special dialog box. Paste Special is the gateway into many powerful operations, including paste Values, which you probably use every day. Note that this shortcut only works when data has been copied to the clipboard.

On Windows, once you have the Paste Special Dialog open, you can type a letter to select the particular command you want, for example:

  • F = Formula
  • V = Values
  • T = Formats
  • C = Comments
  • N = Validation
  • H = All using source theme
  • X = All except borders
  • W = Column widths
  • R = Formulas and number formats
  • U = Values and number formats
  • D = Add
  • S = Subtract
  • M = Multiply
  • I = Divide
  • B = Skip blanks
  • E = Transpose

Related videos

Tip: 23 formula tips to save you time today
In this video, we run through more than 20 tips you can use to save time with Excel formulas today. We believe in making videos that are quick and to the point, so this is a rapid-fire list. We trust that you can rewind the video as needed :)
Tip: How to build a simple summary table
Although Pivot Tables are fantastic tools for summarizing data, sometimes you just want a simple, lightweight solution based on formulas. The good news is you can build your own summaries using functions like COUNTIF and SUMIF. See how in this 3 minute video.
Tip: How to clean text with TRIM and CLEAN
When you bring data into Excel you sometimes end up with extra spaces and line breaks. This short video shows you how to clean things up with TRIM and CLEAN.
Tip: How to copy a pivot table without the data
When you copy and paste a pivot table, a hidden data cache still remains. This video shows a simple way to copy a pivot table without the source data, while preserving all formatting.
Tip: How to generate random values
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and even random text values. This is a great way to create dummy data to test formulas and worksheets.
Tip: How to highlight approximate match lookups
In this video we show how to highlight approximate match lookups with conditional formatting and the LOOKUP function. Highlighting approximate matches is tricky, because you must replicate the original approximate match in the CF rule.
Tip: How to pick names out of a hat with Excel
In this video, we look at how to simulate a drawing and pick winners in a contest with Excel, using the RAND and RANK functions together.
Tip: How to quickly fill in missing data
An easy way to add missing values to data using a dead-simple relative formula and a few other tricks to select empty cells.
Tip: How to quickly fill in missing data - part 2
In this video, we look at a way to fill in missing data when the structure is not consistent, using formula created with IF and ISBLANK functions.
Tip: How to use VLOOKUP to merge tables
VLOOKUP is a great way to merge data in two tables based on a common ID. This video shows you how in 3 minutes. You can even use this technique to reorder the columns you retrieve.
Tip: Paste Special Shortcuts
Despite the boring name, Paste Special is actually a gateway into a hidden world of powerful features. This video shows how to access Paste Special features using keyboard shortcuts.
These tutorials are fantastic. People like me learn faster by following along with the steps in the video. -Tim
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course