Copy selected cells
Windows shortcut
CtrlC
Mac shortcut
⌘C
Copy puts everything on the clipboard: text, formulas, formatting, borders, fills, etc. Use Paste Special to selectively paste only parts of what was copied.
On the Mac, Ctrl + C also works
Related videos
In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart for dashboards and other reports.
Although Pivot Tables are fantastic tools for summarizing data, sometimes you just want a simple, lightweight solution based on formulas. The good news is you can build your own summaries using functions like COUNTIF and SUMIF. See how in this 3 minute video.
Once you have one pivot table set up, you might want to see a different view of the same data. In this video, I'll show you how to quickly base one pivot table on another.
When you copy and paste a pivot table, a hidden data cache still remains. This video shows a simple way to copy a pivot table without the source data, while preserving all formatting.
In this video, we look at how to configure a slicer to control more than one pivot table at once. This technique is often used when building dashboards.
In the video, we build one set of SUMIFS formulas with a table, and one set without. This makes it really easy to see the nice benefits you get when you combine tables and formulas.
VLOOKUP is a great way to merge data in two tables based on a common ID. This video shows you how in 3 minutes. You can even use this technique to reorder the columns you retrieve.
This video shows how to setup VLOOKUP with a table, and how to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns by name inside VLOOKUP, instead of hardcoding the column number. As a bonus, you can reorder the columns and the formula will keep working correctly.
Conditional formatting with formulas can be tricky because you can't see what happens to the formula when the rule is applied. Dummy formulas let you visualize how formulas will behave before you create a rule. This video shows you how to test with dummy formulas, for perfect conditional formatting, every time.
In this video, we'll look at how to build a two-way lookup with INDEX and MATCH, using approximate matching. This is a classic solution for non-exact lookups like income tax, shipping costs, material costs, etc.
