Read the affiliate disclosure page to find out how can you help MSPoweruser effortlessly and without spending any money. Read more
Thanks to native keyboard support, more people are now using Apple iPad as their go-to computing device. In order to deliver a great experience for these users, Microsoft yesterday announced new keyboard shortcuts on the Excel iPad app. These new keyboard shortcuts will bring the Excel authoring experience on iPad closer to macOS. Keyboard shortcuts are now available for navigation, editing formulas, and format and edit data.
Microsoft is introducing these 13 new shortcuts in the July release.
|Move to the next sheet in the workbook||Option + Right Arrow|
|Move to the previous sheet in the workbook||Option + Left Arrow|
|Apply outline border||+ Option + 0|
|Remove outline borders||+ Option + Hyphen|
|Hide Column(s)||+ 0|
|Unhide Column(s)||Shift + Control+ Left parenthesis ())
Shift + + Left parenthesis ())
|Hide Row(s)||Control + 9|
|Unhide Row(s)||Shift + Control+ Right parenthesis ())|
|Toggle the formula reference style between absolute, relative, and mixed|| + TOr
|Insert the AutoSum formula||Shift + + T|
|Calculate open workbook||+ =|
Microsoft will add more shortcuts in the coming months. You can download the latest Excel app from App Store.