Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
JonnyPoole
Former Employee
Former Employee

Designing Tabular Reports for PDF Output in Landscape vs. Portrait Orientations

Portrait vs. Landscape: how to control? 

Use the Excel Tabular Reports plugin with the Desktop Excel edition of Microsoft Office 365.  The web edition does not include an orientation drop down.

In Excel desktop, you will see this menu option. 

JonnyPoole_0-1719407676340.png

 

However in the browser, you only see this:

 

JonnyPoole_1-1719407767642.png

In Excel desktop, the page border will show up as hashed lines as below:

JonnyPoole_2-1719407858185.png

As you can see in the above screenshot, all columns fit inside the hashed lines so the current orientation will result in all columns appearing on a single page. 

Note:  if you don't see the hashed lines at first, try toggling the setting two times and it should show up. 

Lastly, if you have found a way in Excel web to visualize page borders, please share and improve the collective knowledge!  

-Jonny

 

 

Labels (3)
1 Reply
F_B
Specialist
Specialist

Thanks for sharing!