Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Paste Special
You might be surprised how much time is lost flipping between Excel workbooks trying to find information – especially if you have a lot to sort through. Learning how to merge Excel files will make finding information easier, faster, and more user-friendly (especially if you’re sharing workbooks). While you can use VBA to combine files,…
Read MoreIn addition to the standard Copy and Paste commands, Excel offers a variety of options for pasting values and formulas. In this post, I’ll chat about one of those options … Paste Special Add. It works with values AND formulas. Let’s dig in. Overview Before we get into the details, let’s zoom out for a…
Read More