A gateway to hidden and powerful features !

Spread the love

Do you use Paste Special every day?

If not, you could be wasting a lot of time in Excel.

Paste Special sounds boring, but it’s a gateway to many hidden and powerful features:

Powerful features of Paste Special here!

With paste special, we can easily:

  • Convert formulas to static values
  • Paste data without borders
  • Paste formulas without cell formatting
  • Paste values without any formatting at all
  • Copy column widths
  • Extend formatting down a large table
  • Copy and paste comments
  • Copy and paste data validation
  • Clone a pivot table (without source data or controls)

Not only that, we can use Paste Special to change values without formulas. This lets you do things like:

  • Add 30 days to column of dates
  • Subtract a penny from a sheet of prices
  • Increase sales projections by 10%

All without formulas.

If all that’s not enough, Paste Special lets us transpose vertical data to horizontal, and vice versa!

The bottom line: Paste Special is a killer feature we should use every day in Excel.

Any Question / Comments about Paste Special are appreciated

Author: wehelpf9

Leave a Reply