Vlookup for excel 2016 on mac

[dnlcstnn]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #000000}</style>need a faster way to vlookup instead of having to manually scroll down all your data. on PC you can hit ctrl,shift,down and it will highlight all your columns to your last field with data. is there a way to do this on mac?

 

[KevCarter]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #000000}</style>need a faster way to vlookup instead of having to manually scroll down all your data. on PC you can hit ctrl,shift,down and it will highlight all your columns to your last field with data. is there a way to do this on mac?

The same shortcut works on the mac.

Here is a web page with all the keyboard shortcuts for both mac & windows.


https://corporatefinanceinstitute.com/resources/excel/shortcuts/excel-shortcuts-pc-mac/

Hope this helps!

 

[dnlcstnn]

this does not work during vlookup (table array) when you are retrieving your range of data to reference. Please try for yourself and let me know.

 

[KevCarter]

It works for me. I'm using Excel 365 on an older MacBook Pro.