Layout View - Displaying Multiple pages

%3CLINGO-SUB%20id%3D%22lingo-sub-1692497%22%20slang%3D%22en-US%22%3ELayout%20View%20-%20Displaying%20Multiple%20pages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1692497%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20-%20I%20apologize%20if%20this%20is%20a%20double%20post%2C%20but%20I%20can't%20find%20the%20post%20I%20made%20yesterday%20and%20I%20have%20not%20had%20any%20responses%20(which%20is%20unusual).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20this%20is%20a%20basic%20question%20-%20but%20I%20have%20spent%20HOURS%20and%20HOURS%20researching%20this%20on%20the%20Community%20and%20Internet%20-%20and%20it%20is%20driving%20me%20crazy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20of%20my%20spread%20sheets%20are%20displaying%20multiple%20pages%20in%20the%20Layout%20View.%26nbsp%3B%20I%20did%20a%20Copy%20and%20Paste%20of%20a%20spread%20sheet%20(screen%20clips%20following)%20-%20and%20I%20cannot%20figure%20out%20why%20the%20copied%20version%20is%20displaying%20multiple%20spread%20sheets%2C%20with%20everything%20else%20(zoom%20setting%2C%20etc.)%20set%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22roninkansas_1-1600703221385.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F220199i4D3A7ECE4596EB72%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22roninkansas_1-1600703221385.png%22%20alt%3D%22roninkansas_1-1600703221385.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ELayout%20View%20of%20the%20sheet%20I%20am%20working%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22roninkansas_0-1600703177354.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F220196i623AC6CBA61B484E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22roninkansas_0-1600703177354.png%22%20alt%3D%22roninkansas_0-1600703177354.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ELayout%20View%20of%20the%20same%20sheet%2C%20information%20(Copy%20%26amp%3B%20Paste)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20for%20the%20small%20Snips%2C%20but%20I%20think%20you%20can%20see%20the%20differences.%3C%2FP%3E%3CP%3E(Zoom%20setting%2C%20not%20shown%2C%20on%20both%20is%2071%25)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20am%20I%20seeing%20essentially%204%20pages%20in%20the%20Layout%20view%20in%20the%202nd%20Layout%20view%20above.%26nbsp%3B%20I%20have%20looked%20at%20every%20option%20and%20settings%20that%20I%20can%20think%20of%20(switching%20between%20views)%20and%20they%20all%20appear%20identical.%26nbsp%3B%20My%20guess%20is%20that%20it%20is%20something%20simple%20that%20I%20am%20overlooking%2C%20but%20like%20I%20said%2C%20it%20is%20driving%20me%20crazy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eron%20in%20shawnee%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1692497%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1693247%22%20slang%3D%22de-DE%22%3ESubject%3A%20Layout%20View%20-%20Displaying%20Multiple%20pages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1693247%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F569754%22%20target%3D%22_blank%22%3E%40roninkansas%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22ocpExpandoHeadTitleContainer%22%3E%3CSTRONG%3EView%20two%20worksheets%20in%20the%20same%20workbook%20side%20by%20side%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%20class%3D%22ocpebw%22%3E%3CDIV%20class%3D%22ocpExpandoBody%22%3E%3COL%3E%3CLI%3E%3CP%3EOn%20the%20%3CSTRONG%3EView%3C%2FSTRONG%3E%20tab%2C%20in%20the%20%3CSTRONG%3EWindow%3C%2FSTRONG%3E%20group%2C%20click%20%3CSTRONG%3ENew%20Window%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EOn%20the%20%3CSTRONG%3EView%3C%2FSTRONG%3E%20tab%2C%20in%20the%20%3CSTRONG%3EWindow%3C%2FSTRONG%3E%20group%2C%20click%20%3CSTRONG%3EView%20Side%20by%20Side%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EIn%20each%20workbook%20window%2C%20click%20the%20sheet%20that%20you%20want%20to%20compare.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ETo%20scroll%20both%20worksheets%20at%20the%20same%20time%2C%20click%20%3CSTRONG%3ESynchronous%20Scrolling%3C%2FSTRONG%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3Ein%20the%20%3CSTRONG%3EWindow%3C%2FSTRONG%3E%20group%20on%20the%20%3CSTRONG%3EView%3C%2FSTRONG%3E%20tab.%3C%2FP%3E%3CDIV%20class%3D%22ocpAlert%22%3E%3CP%20class%3D%22ocpAlertSection%22%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%26nbsp%3BThis%20option%20is%20available%20only%20when%20%3CSTRONG%3EView%20Side%20by%20Side%3C%2FSTRONG%3E%20is%20turned%20on%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%22%3EMicrosoft%20Link%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcompare-two-or-more-worksheets-at-the-same-time-1deed3da-a297-4260-98aa-a7b2d90c81ab%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcompare-two-or-more-worksheets-at-the-same-time-1deed3da-a297-4260-98aa-a7b2d90c81ab%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22ocpAlertSection%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

HI - I apologize if this is a double post, but I can't find the post I made yesterday and I have not had any responses (which is unusual).

 

I know this is a basic question - but I have spent HOURS and HOURS researching this on the Community and Internet - and it is driving me crazy.

 

Some of my spread sheets are displaying multiple pages in the Layout View.  I did a Copy and Paste of a spread sheet (screen clips following) - and I cannot figure out why the copied version is displaying multiple spread sheets, with everything else (zoom setting, etc.) set the same.

 

roninkansas_1-1600703221385.png

Layout View of the sheet I am working on

 

 

roninkansas_0-1600703177354.png

Layout View of the same sheet, information (Copy & Paste)

 

Sorry for the small Snips, but I think you can see the differences.

(Zoom setting, not shown, on both is 71%)

 

Why am I seeing essentially 4 pages in the Layout view in the 2nd Layout view above.  I have looked at every option and settings that I can think of (switching between views) and they all appear identical.  My guess is that it is something simple that I am overlooking, but like I said, it is driving me crazy.

 

ron in shawnee

 

 

1 Reply
Highlighted

@roninkansas

 

View two worksheets in the same workbook side by side
  1. On the View tab, in the Window group, click New Window.

  2. On the View tab, in the Window group, click View Side by Side

  3. In each workbook window, click the sheet that you want to compare.

  4. To scroll both worksheets at the same time, click Synchronous Scrolling

     

    in the Window group on the View tab.

    Note: This option is available only when View Side by Side is turned on

     

    Microsoft Link: https://support.microsoft.com/en-gb/office/compare-two-or-more-worksheets-at-the-same-time-1deed3da-...

     

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.