SOLVED

Page display issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1493982%22%20slang%3D%22en-US%22%3EPage%20display%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493982%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20Excel%202019.%20When%20I%20open%20my%20spread%20sheet%20it%20is%20displaying%202%20pages%20side%20by%20side%20and%200.5%20page%20that%20is%20not%20populated.%20It%20displays%20pages%20beyond%207%20populated%20pages...%20ad%20infinitum.%20So%207%20pages%20altogether%2C%20display%20goes%20like%3C%2FP%3E%3CP%3E1-5%3C%2FP%3E%3CP%3E2-6%3C%2FP%3E%3CP%3E3-7%2C%3C%2FP%3E%3CP%3E4%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20it%20to%20go%26nbsp%3B%3C%2FP%3E%3CP%3E1%3C%2FP%3E%3CP%3E2%3C%2FP%3E%3CP%3E3%3C%2FP%3E%3CP%3E4%3C%2FP%3E%3CP%3E5%3C%2FP%3E%3CP%3E6%3C%2FP%3E%3CP%3E7%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20print%20view%20it%20shows%20as%20I%20want%20to%20see%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1493982%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493986%22%20slang%3D%22en-US%22%3ERe%3A%20Page%20display%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493986%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712118%22%20target%3D%22_blank%22%3E%40prav216%3C%2FA%3E%26nbsp%3BHey%20can%20you%20show%20me%20the%20file%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494006%22%20slang%3D%22en-US%22%3ERe%3A%20Page%20display%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494006%22%20slang%3D%22en-US%22%3ESorry%2C%20that's%20confidential%20for%20the%20company%20I%20am%20contracted%20to.%20What%20they%20say%20is%20that%20it%20used%20to%20display%201%20page%20scrolling%20down%20like%20list%20view%20and%20not%20multiple%20pages%20like%20icon%20view.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494157%22%20slang%3D%22en-US%22%3ERe%3A%20Page%20display%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712118%22%20target%3D%22_blank%22%3E%40prav216%3C%2FA%3E%26nbsp%3BHey%20I%20have%20just%20seen%20your%20file...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20can%20do%20is%20cut%20all%20data%20of%20page%205%2C6%2Cand%207%20and%20then%26nbsp%3B%20paste%20it%20below%20page%204%20because%20excel%20recognises%20pages%20vertically%20and%20not%20horizantally%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20made%20it%20clear%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494180%22%20slang%3D%22en-US%22%3ERe%3A%20Page%20display%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494180%22%20slang%3D%22en-US%22%3EHave%20you%20checked%20the%20Page%20Order%20settings%3F%3CBR%20%2F%3EDown%2C%20Then%20Over%3CBR%20%2F%3EOver%2C%20Then%20Down%3CBR%20%2F%3E%3CBR%20%2F%3EFound%20in%3A%20Page%20Layout%20ribbon%2C%20Page%20Setup%20group%20extender%20arrow%20-%20bottom%20right%20of%20%22Page%20Setup%22%20group%2C%20then%20%22Sheet%22%20tab.%20bottom%20of%20dialog%20box%20-%20Page%20order%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Using Excel 2019. When I open my spread sheet it is displaying 2 pages side by side and 0.5 page that is not populated. It displays pages beyond 7 populated pages... ad infinitum. So 7 pages altogether, display goes like

1-5

2-6

3-7,

4

 

I want it to go 

1

2

3

4

5

6

7

 

How do I do that?

 

In print view it shows as I want to see it.

 

4 Replies

@prav216 Hey can you show me the file

 

Sorry, that's confidential for the company I am contracted to. What they say is that it used to display 1 page scrolling down like list view and not multiple pages like icon view.
Best Response confirmed by prav216 (New Contributor)
Solution

@prav216 Hey I have just seen your file...

 

What you can do is cut all data of page 5,6,and 7 and then  paste it below page 4 because excel recognises pages vertically and not horizantally

 

Hope I made it clear

Have you checked the Page Order settings?
Down, Then Over
Over, Then Down

Found in: Page Layout ribbon, Page Setup group extender arrow - bottom right of "Page Setup" group, then "Sheet" tab. bottom of dialog box - Page order?