[techtalk] Excel/G-Sheets - How to Easily Print "All On One Page"

Tue Oct 22 15:25:50 PDT 2024

Welcome to the latest issue of Tech-Talk!

Reminder: When accessing resources at the Tech-Talk website<https://www.tech-talk.com/login/oregon>,
use ORLIBTECH for both the username and password when prompted.

Tech-Talk is a paid subscription service for staff of Oregon libraries and is supported in whole by the Institute of Museum and Library Services (IMLS) through the Library Services and Technology Act (LSTA), administered by the State Library of Oregon.
See everything

[https://files.constantcontact.com/ee1208b4001/34916cb2-412f-43fa-8294-1f7ecb0e9a3d.png]

[House by a lake surrounded by autumn trees and a cloudy sky, with a button labeled View the Tech Tip Video Here.]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001b1sfySXqE2pQnWAlzZZ9lb9Zhq-uXScWLTS1lSAzWIjUfHPmOnTQuik43HTeHcVgTNcyIMuJfKbc09cl93s09ce3xNF13fQ4YH6S0mlFscLQ2A7-inooJWBfx9xV-jZgvY_Qz5cfiRj65ivlEMGeHGU9hSKh7GsVJNuclvrrrC85JeTGlTQkcBjGpCGXo0xuY6ekPwVwmiBo7P5w_APdkg==&c=L2r5YLrPpc6PYwWxVtz_bLJcl7HW4Umy-ADfbqSqQo8qHdgHBDQavw==&ch=fjb2Whnbd3S1lKrHJUx_KSU8Z9EZqKoJwirTSF1i_0IaKPx02-ksLg==>

Photo by Aryan R<https://opiayfbab.cc.rs6.net/tn.jsp?f=001b1sfySXqE2pQnWAlzZZ9lb9Zhq-uXScWLTS1lSAzWIjUfHPmOnTQuik43HTeHcVgPymml2UuiIfF4yHx89C8aC_pkCw4gIhhj58nADrdkOQRhyETcmBzwjqIhqApXpXSfyKTCX6pBgcT3Q-xKbel6C8Two-2KY4HN31tywvzN1Nl0FpE2LJXzec5x1R1DRqGXH1yo7_qGAxiL3Ey5HpPvuv-Mi3EE2vrH3P4w-Ky2nLFyp0NQkQ7HKVyvYOdKVAY-V27p7gzl4_BcwIQcc143A==&c=L2r5YLrPpc6PYwWxVtz_bLJcl7HW4Umy-ADfbqSqQo8qHdgHBDQavw==&ch=fjb2Whnbd3S1lKrHJUx_KSU8Z9EZqKoJwirTSF1i_0IaKPx02-ksLg==> on Unsplash<https://opiayfbab.cc.rs6.net/tn.jsp?f=001b1sfySXqE2pQnWAlzZZ9lb9Zhq-uXScWLTS1lSAzWIjUfHPmOnTQuik43HTeHcVgR6t32SUN-nXOqQBoyYlxhj1GVQNNQoYkn8_AAPqKXh4P2m4_Nsq3bWeift3n7LM0ivFx9Y-nbhxu7GaSFWj1JA4GaaYlPbwkIPqTJZTzal5IMUqacrUXbqdpY-YEZAkqK8XM_GyNPLBhZn0o5XeXrF5Ehrcldn-AzSyHE4XAUT5_GCeoM7zceACHPsEKiecrtUbl8qUNW_FothXXEzoMfh7Gj-YpBNzGAR5KpXSBGUjTFnIDIl0BicAbrdIl3_9Xm7w00ALPGWQcJ6_B9bR70JKh4A5Ogwcu0vicJfMWJ9c=&c=L2r5YLrPpc6PYwWxVtz_bLJcl7HW4Umy-ADfbqSqQo8qHdgHBDQavw==&ch=fjb2Whnbd3S1lKrHJUx_KSU8Z9EZqKoJwirTSF1i_0IaKPx02-ksLg==>

[https://files.constantcontact.com/ee1208b4001/e25f6bcf-26a8-4e59-91f2-cc248962042d.png]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001b1sfySXqE2pQnWAlzZZ9lb9Zhq-uXScWLTS1lSAzWIjUfHPmOnTQuknk_eZtarrkh02WAVtYi8pjp9RwjUqLmd7OMrutXQsrPCOiZ1v9dSZSUq8QUJOxe_biVhSWJSxJIRDyaSfo36o34UJ7CAFRwp0c11eHIjGZ&c=L2r5YLrPpc6PYwWxVtz_bLJcl7HW4Umy-ADfbqSqQo8qHdgHBDQavw==&ch=fjb2Whnbd3S1lKrHJUx_KSU8Z9EZqKoJwirTSF1i_0IaKPx02-ksLg==>

Webinars for You

NOTE: All webinars begin at 3 pm ET / 2 pm CT / 1 pm MT / 12 Noon PT and are one hour long.

Oct 23: [GRAPHICS] Use AI Tips and Strategies to Solve Problems and Craft Perfect Text. Why attend? It's simply AMAZING.

Nov 6: [INTERNET] Organizing Your Documents in Cloud Storage. Why attend? If you have trouble finding what you need.

Nov 20: [VIDEO] How to Pick the Perfect Video Creation Resource for Any Situation. Why attend? If you want to understand all your video options.

Dec 4: [GOOGLE] Navigating Google Drive - A "Getting Started" Webinar.

Why attend? You're new to Google or need better understanding.

View Webinars and Register Here<https://opiayfbab.cc.rs6.net/tn.jsp?f=001b1sfySXqE2pQnWAlzZZ9lb9Zhq-uXScWLTS1lSAzWIjUfHPmOnTQupSY_obznVN-feRsEz1M6A4QliQYW_4iv6j7h24sRF62rSUQoojNw308W2tXZOIwsqLAH_2oa22C3Y5KozzClsHOcOCo5LFriihFCcB15TyQUWxeIo661mI=&c=L2r5YLrPpc6PYwWxVtz_bLJcl7HW4Umy-ADfbqSqQo8qHdgHBDQavw==&ch=fjb2Whnbd3S1lKrHJUx_KSU8Z9EZqKoJwirTSF1i_0IaKPx02-ksLg==>

Excel/G-Sheets - How to Easily Print "All On One Page"

Intermediate

[A printer on a desk with glasses on top printing a page with green charts, next to a stack of white paper. Shelves in the background.]

Have you ever sent a spreadsheet to the printer expecting it to be printed on ONE page, but a second sheet came out of the printer with only one column in it? What a waste of paper!

Sometimes you want to squish your columns and rows to have one sheet. Maybe you've got some extra data that isn't fitting on the page… it's either too wide or too long. Or maybe you don't need all of the detail up close, but a bird's eye overview.

Well, there's a quick and easy way to make sure you print everything you need on one page, essentially shrinking the content in the spreadsheet to appear as you would like it.

We'll go through these steps and look at Excel Desktop software, Excel 365 Web, and Google Sheets.

NOTE: In each platform, you make changes to the Print options. These settings may stay intact the next time you print, so be sure to check.

EXCEL (Desktop) – Print on One Page

You can adjust this function in two different ways:

1. If this is a one-time selection, you can initiate it as needed when you go to Print.

2. If you're in a situation where you use this setting most of the time, and want to set the sheet up with the default settings for printing output going forward.

Let's look at how to do both.

1. Print on One Page Occasionally in Printer Settings

[Print window showing options for scaling, including "Fit Sheet on One Page," with a highlighted red arrow pointing at it.]

Typically, you'll want to use this setting occasionally. To print to one page as needed:

·     Go to File and select Print.

·     Towards the bottom of the Settings option, click the down arrow under No Scaling.

·     In the window that opens above it, select Fit Sheet on One Page.

·     You can also choose to Fit All Columns on One Page or Fit All Rows on One Page.

·     Consider changing the margins or the page orientation for the best fit.

2. Change the Default Print to One Page Setting for the Excel Worksheet.

To print all your Excel data on one page (every time):

·     Go to the Page Layout tab and then in the Page Setup group, click the downward arrow.

·     In the Page Setup window that opens, under Scaling choose Fit sheet: 1 page. This will shrink your entire spreadsheet to fit on a single page when printed.

·     You can also use the Fit to choice to adjust the Page Wide by and Page Tall by options.

·     Additionally, you can switch between portrait and landscape orientation or change the margins to make them wider.

TIP: Before printing, always use the Print Preview option to see how your data will look on a single page.

[Spreadsheet showing the "Page Layout" tab with "Page Setup" dialog box open, highlighting page scaling options with a red arrow.]

Excel 365 (WEB) - Print on One Page

When you need to adjust the pages printed in the Excel 365 web version, follow the directions outlined in #1 above for the Excel desktop option.

You can also go to Page Layout and select Page Setup, but it will lead you to the same options if you go to File, Print.

[A spreadsheet print preview showing various settings on the right, with a red arrow highlighting "Fit sheet on one page" under Scaling.]

Google Sheets – Print on One Page

To print a Google Sheet on one page, there is a "Fit to page" option in the Print process.

·     In your Google Sheet, select the cells you want to print, or choose to print the entire sheet.

·     In the menu, go to File, then Print.

·     In the Print Settings window, in the right panel, under Scale, select Fit to page.

·     Depending on your content, you can also choose Fit to height or Fit to width.

·     Additionally, you can adjust the print area, paper size, page orientation, and margins.

·     Click Next.

·     In the printer menu, select your printer and click Print.

[Screenshot of a print settings window showing a list view. An arrow points to the Fit to page scale option.]

[A series of smooth, dark stones arranged in a line, half-submerged in calm, reflective water with a soft, gray background.]

Communication: Handle Conflict

Show you've heard before disagreeing

Think back to a recent discussion you had with someone.

Whether you're going to counter the thought, or support it, indicating that you've heard what was said, is a good thing to do.

Withholding this kind of endorsement (because you think it's obvious ... or because you think differently) is a missed opportunity.

Even when you disagree with what was said, acknowledge the fact that you've heard the statement first, before launching into how you differ. This approach will make your conversations more productive.

Examples of supportive statements, even when you disagree.

·     "I hear you."
·      "Well, that's an idea."
·     "You bring up a good point."

[https://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001b1sfySXqE2pQnWAlzZZ9lb9Zhq-uXScWLTS1lSAzWIjUfHPmOnTQuuuQXCebrI3XcYT6TdKzIGMQtIIWaAeRy1CNd8HnN96t5fy8S9At3ljYPMIGnwyRsX27qvhy9dTIyctsMexc5UXi7VatVFA2nt1vOLHRFG7tIS84MYfA4bc=&c=L2r5YLrPpc6PYwWxVtz_bLJcl7HW4Umy-ADfbqSqQo8qHdgHBDQavw==&ch=fjb2Whnbd3S1lKrHJUx_KSU8Z9EZqKoJwirTSF1i_0IaKPx02-ksLg==>

[Ask a question]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001b1sfySXqE2pQnWAlzZZ9lb9Zhq-uXScWLTS1lSAzWIjUfHPmOnTQuoDLGZuRjOd0PHdymQPTAOM7F96EcGoFwXrZKFw0o4-FbqM0tMbCH5at9ukYFlPu2P5yHvGfItIbnGCE2tibZFM0BhvtU5jABfW2vRietUNAYWuM0csN6hM=&c=L2r5YLrPpc6PYwWxVtz_bLJcl7HW4Umy-ADfbqSqQo8qHdgHBDQavw==&ch=fjb2Whnbd3S1lKrHJUx_KSU8Z9EZqKoJwirTSF1i_0IaKPx02-ksLg==>

Copyright 1996-2024 Shared Results International. Published weekly. Distribution is limited by license. For information on how to include additional recipients, contact support at tech-talk.com<mailto:support at tech-talk.com> 585-615-7795.

Cheers,
Darci Hanning, MLIS (she/her/hers)
Public Library Consultant / CE Coordinator
Continuing Education Resources: https://libguides.osl.state.or.us/conted
State Library of Oregon | Library Support and Development Services
971-375-3491 | darci.hanning at slo.oregon.gov<mailto:darci.hanning at slo.oregon.gov> | www.oregon.gov/library<http://www.oregon.gov/library>

[State Library of Oregon (Logo)]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20241022/c150561b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 15548 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20241022/c150561b/attachment.png>