Excel

Resolved · Low Priority · Version 2016

Thu 28 Jan 2021, 16:03 Delegate 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:42 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Pivot table grouping

If 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.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips