Streamlining Excel’s Paste Special Values Feature

Spreadsheets and graphs on a desk
Share this content

During my recent High Impact Excel: Macro Edition webinar—which we've posted online for free viewing—an attendee asked if it’s possible to use the Macro Recorder to automate Excel’s Paste Special Values feature. I replied that yes, that is possible, but that there are other alternatives that are likely more suitable than creating a macro. As with many aspects of Excel, useful keyboard shortcuts and icons lurk in the periphery, out of sight from most users. In this article I’ll demonstrate a couple of ways that you can streamline Paste Special Values actions without relying on a macro.

Virtually every spreadsheet user is familiar with Excel’s Paste command, which allows you to paste one or more cells that you’ve copied to the clipboard. For instance, Figure 1 shows a simple payroll calculation...

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.


Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.