Useful Excel Commands for Mac OS

Select from bottom to top:

press shift + command + arrow up 

Select from top to last non blank cell:

press shift + command + arrow down

Move from bottom to top:

command + arrow

Move from top to last cell:

control + fn + right arrow

Replace formula with values:

select data range
press copy
goto Home-> paste
click arrow down
Select "values"

Be the first to comment

Leave a Reply

Your email address will not be published.