Hello Howard,
You can change the numbers of columns that will be displayed before saving your spreadsheet within excel. Follow these directions to format the page layout in Excel.
In Excel
- Navigate to the Page Layout tab.
- Select "Print Area" and choose "Clear Print Area".
- Navigate to View tab.
- Select Page Break View.
- Drag delineation lines to break up spreadsheet into desired number of pages.
- Save changes.
In Digital Workplace
- Navigate to spreadsheet you are changing.
- Click the actions button (depicted by "...")
- Select versions.
- Upload spreadsheet with formatting edits
- Save
There is one caveat to consider. Though altering the formatting of the spreadsheet made the view larger, this will sacrifice quality since we have an enlarged view represented within the same resolution prior. In order to properly view data within the spreadsheet you will most likely need to download it.
Regards,
Andrew
5 Replies
I had this exact issue just a few minutes ago - thank you for posting the question! I did find that when the document was downloaded it looked as it should. Sorry I can't help but also looking forward to an answer!
Christina Peschong I was getting frustrated and kept trying different things and what I figured out does help tremendously. If you set the height and width in Excel before saving to 1 page, it renders nicely.
That makes sense – thanks for the tip and all of the work that went into figuring that out. Thanks!
Christina Peschong
Internal Communications
cpeschong@varde.com
+1 (952) 646-2752 direct
Hello Howard,
You can change the numbers of columns that will be displayed before saving your spreadsheet within excel. Follow these directions to format the page layout in Excel.
In Excel
In Digital Workplace
There is one caveat to consider. Though altering the formatting of the spreadsheet made the view larger, this will sacrifice quality since we have an enlarged view represented within the same resolution prior. In order to properly view data within the spreadsheet you will most likely need to download it.
Regards,
Andrew
As a long time Excel ‘jockey’ I can offer up a few comments.
I have found viewing Excel is a challenge for any display application e.g. Google, Adobe, Igloo. The variable and dynamic nature of row and column formats along with tabs looks great on the screen. When you try and translate that into a view with a fixed format through a print process, the results can be unpredictable.
The quickest fix I have found is to makes sure the print set aligns to how you want to display the content For each tab I usually set the orientation to landscape and fit to a page. When the spreadsheet is rendered, it appears as I want it to.
The other fix I have applied is to ‘design’ the spreadsheet knowing it will be published and shared. Many times I will create and publish a summary sheet that looks good and will resonate with the target audience.