File, Print. 1 Turn the page sideways (Landscape). 2 Fit All Columns on One Page.
See it before you print
Click File, then Print. (Or press Ctrl+P.)
On the right, you see a preview of the page. Use the arrows under it to see the other pages.
Fit everything on one page
Click File, then Print.
Under Settings, find the last box. It says No Scaling.
Click it and choose Fit Sheet on One Page.
Other choices there: Fit All Columns on One Page is good for long lists, so nothing is cut off on the right.
Tip: To turn the page sideways, click Portrait Orientation in the same Settings list and pick Landscape. Wide lists fit better.
Print only part of the sheet
Select the cells you want to print.
Click the Page Layout tab.
Click Print Area, then Set Print Area.
Now only those cells print. To undo it: Page Layout, Print Area, Clear Print Area.
Repeat the headings on every page
Click Page Layout, then Print Titles.
Click in the box Rows to repeat at top, then click row 1 on the sheet.
Click OK. Now every printed page shows the headings.
Save it as a PDF
A PDF looks the same on every phone and computer, and nobody can change it by mistake.
Click File, then Export.
Click Create PDF/XPS.
Pick a folder, type a name, and click Publish.
You can also do File, Save As, and change Save as type to PDF.
Mac: On a Mac, click File, Save As, and pick PDF in the File Format list.
Web: In Excel on the web, click File, then Export, then Download as PDF.
Share a link
Save the file in OneDrive first (File, Save As, OneDrive).
Click Share at the top right of the window.
Type the person's email, or click Copy link.
Choose if they can edit or only view.
Tip: Or just attach the .xlsx file or the PDF to an email, like any other file.
Protect a sheet so nobody breaks it
Click the Review tab.
Click Protect Sheet.
Type a password if you want (write it down somewhere safe!). Click OK.
Now nobody can change the cells. To change them again: Review, Unprotect Sheet.
Tip: To let people type in some cells but not others, first select the cells they may change, press Ctrl+1, open the Protection tab, uncheck Locked, and click OK. Then protect the sheet.
Try it
Go to the sheet 8 Print Me. Open File, Print and look at the preview. Change it to Landscape and Fit All Columns on One Page. Set a print area for A1:E20 only. Set row 3 to repeat at the top. Then save the sheet as a PDF on your computer, and protect the sheet with no password. Try typing in a cell to see that it is locked, then unprotect it.