In our recent poll, I have asked you to tell me which buttons you have on the quick access toolbar?
Finnur, one of our readers has configured the Excel 2007 quick access toolbar to make it look like Excel 2003 toolbar. See it below,
I think this is a very cool way to max up your productivity, it takes 5 minutes to make your quick access bar look like Excel 2003 toolbar and you could save countless hours of “searching-for-that-command-in-ribbon” time.
All you need to do for this is,
- Right click on “quick access toolbar” and select “customize” option.
- Add the all the commands required to make the your quick access toolbar look like Excel 2003 toolbar
- That is all.
See this video to understand how I did this for my Excel 2007 quick access toolbar.
Check out the video on youtube if you are not able to see it here.
Also, see how m-b, another reader, has implemented it here.
And if you are still bummed with Ribbon, check out our free excel ribbon learning guide.
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.