I use both the Mac(mainly) and sometimes Windows 10 PC. I would like to use Excel on both machines with one license.5 votes
If I want to select all the rows from a certain row, I can no long use command+shift+ [down arrow] to select rest of the rows. the selection does not move at all. (The purpose is that I want to hide all the rows below a certain row)
The same goes for column selection too.
Can you please tell me how to do it in Excel for mac?24 votes
Please find all the keyboard shortcuts here – https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd#bkmk_movescroll
Note that in some cases, a key combination may be used by Mac OS for some purpose and therefore not work as expected in Excel. An example is when you have more than one keyboard input source added to your Mac, and then press CTRL+Space, it may switch input sources rather than selecting the entire column. You can turn off this shortcut in the Keyboard preferences > Shortcuts > Input Sources of your Mac so that the key combination will work as expected in Excel.
- Don't see your idea?