data validation shortcut key for mac in excel

These can be handy if, like me, you sometimes struggle with your laptops built-in mouse controller and you dont have your external mouse handy.

And remember most keyboard shortcuts work in all versions of Excel.

You may be surprised to know that you cant use the AutoSum on a protected sheet.

This is different to the Wrap Text format which will change the line breaks as the column widens.

This makes it incredibly easy to perfectly line up your charts or images.

You can use this before you copy to ensure that what you are only copying the visible cells and not any hidden rows or columns.

If you have used Excels Data Subtotal feature and you only wish to only copy the Subtotals, you can use Data Grouping to hide the detail and display only the Subtotals and then select the range and press ALT; to the visible cells only and then copy and paste to paste the Subtotals only.

It is a shortcut to quickly access the first nine buttons on the Quick Access Toolbar (the toolbar above or below the ribbon).

So you can rearrange the buttons to allow you to quickly access them with the ALT key.

Once open ALT F11 allows you to toggle between Excel and VBE window.

There is a Quick Access Toolbar icon you can add to the toolbar if the keyboard shortcut doesnt work.

Data Validation Shortcut Key For Mac In Excel