98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2016
Thu 28 Jan 2021, 16:03Delegate Rekha said...
Rekha has attended:
Office 365 End User course
Excel Intermediate course
Excel
I’m just working on pages bundles and I have a few excel spreadsheets that I need to send alongside the s16 bundles. Do you know how we work out the equivalent page count for spreadsheets? I have tried converting them to PDFs but just end up with dozens of pages that have one or two columns on them so they don’t really make much sense!
Thu 28 Jan 2021, 16:59
Edited on Thu 28 Jan 2021, 17:42Trainer Jens said...
RE: excel
Hi Rekha,
Thank you for the forum question.
PDF file created from worksheet will look the same as if you print the worksheet.
Look at you print preview (File tab -> Print). Decide how you want the PDF file to look like.
If you on the Page Layout tab in the Scale to Fit group tell Excel how many pages wide and tall you want. Your PDF file will have the same amount of pages.
In the Page Setup group you also have many options to do changes for the PDF output and on the View tab in Page break view you can change where you want the page breaks in your PDF file.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 4 Feb 2021: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Pivot table groupingIf you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other. |
