Streamlining Excel’s Paste Special Values Feature

exceltips.jpg

Spreadsheets and graphs on a desk
xfgiro/istock
Share this content
0

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.

Replies

Please login or register to join the discussion.

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