To ask for Excel (on a Mac) help

[badlydrawnperson]

OK, I know I am BU, but I have been given a Mac after years as a windows user. Figured out most stuff - except a few things like when I want to highlight a few columns in a sheet and highlight right to the end so I can C&P somewhere else - shift and end (IIRC) in Windows. Seen various suggestions via Google of the Mach equivalent but none seems to work reliably - any pointers Mac fans?

Shift-command-arrow key will highlight to the end of a group of rows or columns .
Any others you’re struggling to find? I had the same issue last year. Annoyingly, there is some functionality that doesn’t exist on excel for Mac.

You might be better trying Google Sheets - not as much functionality, but works the same across platforms

Click on the first part then drag across to the last part & let go. Hold the "Apple key" marked cmd on my MacBook & press C then click where you want it to go & press Apple + V. Job done.

I loathe being forced to use Windows machines at school (teacher). Everything I need to teach a creative subject works so much better on a Mac. I use Numbers for spreadsheets then use the option to convert them to Excel. I do the same with Pages for anything typed and save them as pdfs or Word-format and Keynote for powerpoints. In fact, my students always comment on how much nicer my powerpoints are than everyone else's. Yes kids, I did them on a Mac

@Fortheloveofscience Thanks - that doesn't seem to work reliably on this Mac for some reason

@Malbecfan most of my spreadsheets are too long to make dragging to the end with the mouse practical - on windows it's just shift and end key to find the end of the data - is there a Mac equivalent that you know of?

Thanks folks, I appreciate it. I am not pro or anti Mac vs Windows - it is much better at some things and some things are just different I guess

I can't use numbers or Google as I am using stuff that others create and sometimes need back so I can't faff about converting between platforms.