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...
About David Ringstrom, CPA
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.