Open multiple documents in Excel on iPadOS

Published Dec 09 2020 08:29 AM 7,879 Views
Microsoft

We are excited to share that you can now open multiple documents in Excel on iPadOS. With this update you can take advantage of split view for better multitasking on the iPad. This feature is also available in Word and PPT on iPadOS. 

 

Open Multiple Documents 

You can now open two Excel workbooks side-by-side and take advantage of the larger screen of your iPad. 

 

This feature can be accessed in the following ways: 

  • In the Excel app, swipe up from the bottom of the screen to open the dock. Then touch and hold the icon of the Excel app, on the dock, and drag it to the right or left edge of the screen. 
  • Touch, hold, and drag a file from the Recent, Shared, and Open file list to the right or left edge of the iPad screen to open it side-by-side 
  • In the Recent, Shared, and Open file list, tap the “…” menu for a file in the list, then tap Open in New Window 

 

Atri_Roy_0-1607436789820.jpeg

 

 

Drag and Drop Content 

You can drag and drop content between two files open which are open side-by-side. Simply select your cell or range in one document and long tap the selection to drag and drop it in the other document. 

 

Atri_Roy_1-1607436789822.jpeg

 

 

Prerequisites 

This feature requires iPadOS 13 and above. 

 

Feedback 

If you have any feedback or suggestions tap Settings > Help & Feedback, and then tap Tell Us What You Like, or Tell Us What Can Be Better.  

 

 

1 Comment
Occasional Visitor

It seems that this feature is not yet available on Microsoft Office app on iPadOS. It only works on Microsoft Excel app. Is that correct?

%3CLINGO-SUB%20id%3D%22lingo-sub-1967071%22%20slang%3D%22en-US%22%3EOpen%20multiple%20documents%20in%20Excel%20on%20iPadOS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1967071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWe%20are%20excited%20to%20share%20that%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eyou%20can%20now%20open%20multiple%20documents%20in%20Excel%20on%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EiPadOS%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWith%20this%20update%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eyou%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bcan%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Etake%20adva%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Entage%20of%20split%20view%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Efor%20better%20multitasking%20on%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ethe%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EiPad.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20feature%20is%20also%20available%20in%20Word%20and%20PPT%20on%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EiPadOS%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId--1181683295%22%20id%3D%22toc-hId--1180908911%22%20id%3D%22toc-hId--1180908911%22%20id%3D%22toc-hId--1180908911%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EOpen%20Multiple%20Documents%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A240%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EYou%20can%20now%20open%20two%20Excel%20workbooks%20side-by-side%20and%20take%20advantage%20of%20the%20larger%20screen%20of%20your%20iPad.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20feature%20can%20be%20accessed%20in%20the%20following%20ways%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIn%20the%20Excel%20app%2C%20swipe%20up%20from%20the%20bottom%20of%20the%20screen%20to%20open%20the%20dock.%20Then%20touch%20and%20hold%20the%20icon%20of%20the%20Excel%20app%2C%20on%20the%20dock%2C%20and%20drag%20it%20to%20the%20right%20or%20left%20edge%20of%20the%20screen.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%222%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3ETouch%2C%20hold%2C%20and%20drag%20a%20file%20from%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3ERecent%2C%20Shared%2C%20and%20Open%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bfile%20list%20to%20the%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eright%20or%20left%20edge%20of%20the%20iPad%20screen%20to%20open%20it%20side-by-side%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIn%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3ERecent%2C%20Shared%2C%20and%20Open%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bfile%20list%2C%20tap%20the%20%E2%80%9C%E2%80%A6%E2%80%9D%20menu%20for%20a%20file%20in%20the%20list%2C%20then%20tap%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3EOpen%20in%20New%20Window%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Atri_Roy_0-1607436789820.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238643i00591BAD665E4473%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Atri_Roy_0-1607436789820.jpeg%22%20alt%3D%22Atri_Roy_0-1607436789820.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1305829538%22%20id%3D%22toc-hId-1306603922%22%20id%3D%22toc-hId-1306603922%22%20id%3D%22toc-hId-1306603922%22%3E%26nbsp%3B%3C%2FH2%3E%0A%3CH2%20id%3D%22toc-hId--501624925%22%20id%3D%22toc-hId--500850541%22%20id%3D%22toc-hId--500850541%22%20id%3D%22toc-hId--500850541%22%3E%3CSPAN%20style%3D%22color%3A%20inherit%3B%20font-family%3A%20inherit%3B%20font-size%3A%2024px%3B%22%20data-contrast%3D%22none%22%3EDrag%20and%20Drop%20Content%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20inherit%3B%20font-family%3A%20inherit%3B%20font-size%3A%2024px%3B%22%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A240%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EYou%20can%20drag%20and%20drop%20content%20between%20two%20files%20open%20which%20are%20open%20side-by-side.%20Simply%20select%20your%20cell%20or%20range%20in%20one%20document%20and%20long%20tap%20the%20selection%20to%20drag%20and%20drop%20it%20in%20the%20other%20document.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Atri_Roy_1-1607436789822.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238644i718F20CEE739BDF5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Atri_Roy_1-1607436789822.jpeg%22%20alt%3D%22Atri_Roy_1-1607436789822.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1985887908%22%20id%3D%22toc-hId-1986662292%22%20id%3D%22toc-hId-1986662292%22%20id%3D%22toc-hId-1986662292%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EPrerequisites%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A240%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20feature%20requires%26nbsp%3BiPadOS%26nbsp%3B13%20and%20above.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId-178433445%22%20id%3D%22toc-hId-179207829%22%20id%3D%22toc-hId-179207829%22%20id%3D%22toc-hId-179207829%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EFeedback%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A240%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIf%20you%20have%20any%20feedback%20or%20suggestions%20tap%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3ESettings%E2%80%AF%26gt%3B%20Help%E2%80%AF%26amp%3B%20Feedback%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%20and%20then%20tap%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3ETell%20Us%20What%20You%20Like%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%20or%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3ETell%20Us%20What%20Can%20Be%20Better%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1967071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWe%20are%20excited%20to%20share%20that%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eyou%20can%20now%20open%20multiple%20documents%20in%20Excel%20on%26nbsp%3B%3C%2FSPAN%3EiPadOS%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1967071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20iPad%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EiPad%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EiPadOS%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2239061%22%20slang%3D%22en-US%22%3ERe%3A%20Open%20multiple%20documents%20in%20Excel%20on%20iPadOS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2239061%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20seems%20that%20this%20feature%20is%20not%20yet%20available%20on%20Microsoft%20Office%20app%20on%20iPadOS.%20It%20only%20works%20on%20Microsoft%20Excel%20app.%20Is%20that%20correct%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Dec 09 2020 08:29 AM
Updated by: