Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2016

Rekha has attended:
Excel Intermediate course
Office 365 End User 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!

Edited on Thu 28 Jan 2021, 17:42

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.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.