Excel Paste Special is one of my favorite features. So I was naturally thrilled when I discovered that you can use paste special to paste formatting from one chart to another.
When we have multiple charts, ensuring consistent color schemes, fonts etc. is very important. Often we individually format the charts because they have different chart types or source data. But instead, you can just use paste special to copy and paste chart formatting (formatting of labels, grid line settings, axis settings, colors, legends, titles) from one chart to another. See this small tutorial.
- To do this, Select the source chart, press Copy (or CTRL+C), now select the destination chart, go to Paste Special (or press ALT+ES). From the dialog select “Formats”.
One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”
Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.
I added a new sheet, and named the ranges for Sara and James.
Maybe something like:
B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))
Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.