As more people start using Apple’s iPad as one of their go-to computing devices, the Excel team is working to deliver a great experience on the Excel iPad app. One of the first steps towards this goal is to introduce new keyboard shortcuts to provide users a great authoring experience while using hardware keyboards.
These new keyboard shortcuts will bring the authoring experience on iPad closer to macOS, across different areas such as navigation, editing formulas, and format and edit data.
We will be introducing new shortcuts across multiple iterations over the next few months, starting with 13 new shortcuts in the July release . Here is a list of the new shortcuts – for the complete list please check Keyboard Shortcuts in Excel.
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
Shift + Control+ Right parenthesis ())
Shift + + Right parenthesis ())
Control + 9
Shift + Control+ Left parenthesis (()
Toggle the formula reference style between absolute, relative, and mixed
Insert the AutoSum formula
Shift + + T
Calculate open workbook
We will add more shortcuts in the coming months as we continue to focus on providing users a great experience while using Excel on the iPad. To start using these shortcuts, from the App Store.