Blog Post

Excel Blog
1 MIN READ

New keyboard shortcuts in Excel for iPad

Atri_Roy's avatar
Atri_Roy
Icon for Microsoft rankMicrosoft
Jul 22, 2020

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.

 

 

 

Updated Aug 13, 2020
Version 2.0
  • Bajajshilpi0510's avatar
    Bajajshilpi0510
    Copper Contributor

    Hi, This was certainly helpful. Can you also share / add list of other common shortcuts such as paste special, insert / delete row/ columns, applying filter sorting data etc.

  • Katepww's avatar
    Katepww
    Copper Contributor

    Can you insert a page break in excel on an IPAD?