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.
|
Action |
Shortcut |
|
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+ Right parenthesis ()) Or Shift + + Right parenthesis ()) |
|
Hide Row(s) |
Control + 9 |
|
Unhide Row(s) |
Shift + Control+ Left parenthesis (() |
|
Toggle the formula reference style between absolute, relative, and mixed |
+ T
Or + 4 |
|
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.
Microsoft
