[Libs-Or] Tech-Talk: EXCEL/G-Sheets - Print Titles and Headers on Every Page

Tue Jul 9 14:34:03 PDT 2024

Welcome to the latest issue of Tech-Talk!

Having trouble reading this email?
You can view the tech tip<https://www.tech-talk.com/excel-page-headers-on-every-printed-page.html> and the communication tip<https://www.tech-talk.com/how-committed-are-you.html> online instead at:
https://www.tech-talk.com/login/oregon

When prompted for a username and password, use ORLIBTECH for both.

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.
Make sure your page titles are visible when printing

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

[View from inside a tent looking out at mountainous terrain with green hills and wildflowers. A person is lying down with legs in view, and there is a blue button in the center of the image that reads, "View the Tech Tip Video Here.]<https://opiayfbab.cc.rs6.net/tn.jsp?f=00137BNGymgBofHOqBa0QsNsi212ODJ_Ar0gappmAxzWmTiSMOdJ05IrNqLQHp9YoY7_hKKqkb0u5L_rdaXikpvw-zg6DZoUxMaaZ9UkfehSV-jHf4Bo41if0pI7YGvxHaEhgWxTPkA3wQ6QRNaCt-Oct6VflCjiooyv5bBilUy1wBCIWMCR4iZcts--b_4uKGRCEBWqUiFTJWbt4OfzvwSHg==&c=_156of-9dv6_Yh4P2d5GScJLq5V8Hc1X9j3LRLPAOYLZSJRltUKKvg==&ch=9DOGhvC7msdQqNSIv5DBePWfeRMW9eosZFWLwo5VkvLDgL9UcnRrbQ==>

Photo by Dominik Jirovský<https://opiayfbab.cc.rs6.net/tn.jsp?f=00137BNGymgBofHOqBa0QsNsi212ODJ_Ar0gappmAxzWmTiSMOdJ05IrNqLQHp9YoY7kzrYaiRQwhYwKJA9OALnVsKpflvqRJDUjF2Zi1T39_uyBlG9LaagFclX0OR1AIcTMhOMVKU9xEUazbwOshufezJ1JHID90Dyo6iHEv4BM409F_1iWIDVxynmeGD6jGs4IfhSLZM3C5Hatd_OxLhqAonRw1lMXLZGo3sPmOv8Vjcnt72cOGE4mAK9SGLbCwdlOg3SI_VKtRwzPdtuQCmE4w==&c=_156of-9dv6_Yh4P2d5GScJLq5V8Hc1X9j3LRLPAOYLZSJRltUKKvg==&ch=9DOGhvC7msdQqNSIv5DBePWfeRMW9eosZFWLwo5VkvLDgL9UcnRrbQ==> on Unsplash<https://opiayfbab.cc.rs6.net/tn.jsp?f=00137BNGymgBofHOqBa0QsNsi212ODJ_Ar0gappmAxzWmTiSMOdJ05IrNqLQHp9YoY7EpAlHr_GNUaWcaoF-kIwaFYjLwkk7gecO8RCuVFMkeaXv6nBW6x_6T4XrUqIJehutO0LQbjacOyeDLH5jQpRKFRh98G0-3CGvbDy6J8TVQKfARlQSKXTHoK10eJ3pOzytVY3IdogQ7fC7PiP2txG4URyb57BRmDUHXOHqYZAoxLvPxSQs8-GCMVVM3Pfl-ES_pBglFynrKx0J5_5wtWtSXBnUAMQ1UaEqzOpeX8pIFcLq0y3g-baM_57by03QuDijMjYr6i2MsgkXbLgMVy6EJVKQM_65G2P&c=_156of-9dv6_Yh4P2d5GScJLq5V8Hc1X9j3LRLPAOYLZSJRltUKKvg==&ch=9DOGhvC7msdQqNSIv5DBePWfeRMW9eosZFWLwo5VkvLDgL9UcnRrbQ==>

[https://files.constantcontact.com/ee1208b4001/e25f6bcf-26a8-4e59-91f2-cc248962042d.png]<https://opiayfbab.cc.rs6.net/tn.jsp?f=00137BNGymgBofHOqBa0QsNsi212ODJ_Ar0gappmAxzWmTiSMOdJ05IrHe4T1g3lHGTFLp3kGLlD3IzSDtsEbcZ8P_aj1LmkkG3Cg-7O0BXuryedQeythWnK4eCtaGJo7f_VtmgPdqk7Kxh-dsvC3ss5psDr98oy3eJ&c=_156of-9dv6_Yh4P2d5GScJLq5V8Hc1X9j3LRLPAOYLZSJRltUKKvg==&ch=9DOGhvC7msdQqNSIv5DBePWfeRMW9eosZFWLwo5VkvLDgL9UcnRrbQ==>

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.

·    July 10: [VIDEO] Snagit Videos: From Screen Recording to Polished Productions

·    July 24: [EXCEL] Mastering Spreadsheet Magic: Typical Formula Techniques

·    August 7: [GRAPHICS] CANVA: A Beginner's Guide to Designing Graphics Like a Pro

·    August 21: [OFFICE] Unlocking the Power of Office 365 Web: Seamless Transition and Productivity

View Webinars and Register Here<https://opiayfbab.cc.rs6.net/tn.jsp?f=00137BNGymgBofHOqBa0QsNsi212ODJ_Ar0gappmAxzWmTiSMOdJ05IrJdrmnkJi_kGQXj-gcSqFfaUu0UiVzndEn2gMAsyVAslpXg8_x2-ACiWJuFpK2kBQDgK3N_kqxmbjSsP7w6_5vTcD2zhHFt_zf80XAkx-hTkiil2zD7lYN8=&c=_156of-9dv6_Yh4P2d5GScJLq5V8Hc1X9j3LRLPAOYLZSJRltUKKvg==&ch=9DOGhvC7msdQqNSIv5DBePWfeRMW9eosZFWLwo5VkvLDgL9UcnRrbQ==>

EXCEL/G-Sheets - Print Titles and Headers on Every Page

Intermediate

[Three overlapping sheets of paper filled with tables of data, with the top sheet prominently displaying multiple rows and columns of information. The text is small and primarily black, with a yellow highlighted header on the top sheet.]

Have you ever printed out a spreadsheet that has multiple pages, yet the Title row (the column names) shows up only on the first sheet? Without this type of information on the additional pages, it’s hard to keep track of your spreadsheet information.

For spreadsheet-lingo clarification within a spreadsheet, the letters at the top of the column (A, B, C…) and the numbers (1, 2, 3…) in front of the row are called "Headers."

And the labels or names that we type in to describe the column or row are called "Titles" in spreadsheet lingo.

For example, you may have a three-page Excel report that you want to provide to your team members. If you print it without the Title row on every page, your colleagues will have to keep referring back to the first page to figure out what the information on pages two and three represent.

However, if you know where you can tell Excel to print the Titles on each page, your problem is solved!

Alternatively, you can print the "Headers" (just the column letters and row numbers).

Print Titles on Each Page in Excel

As a way to easily remember where this function is located in Excel, think of printing headers on every page as part of your Page Layout and Setup. Then it will become intuitive each time you need to do this.

[A screenshot of the "Page Layout" tab in Microsoft Excel's ribbon, showing various options including Themes, Colors, Fonts, Effects, Margins, Orientation, Size, Print Area, Breaks, Background, and Print Titles, which is highlighted with a red border.]
·    With your spreadsheet open, select Page Layout Tab, go to the Page Setup section, and click on the Print Titles button.

·    A Page Setup window will open.

·    Select the Sheet tab and to the right of the Rows to repeat at top field, click on the tiny arrow in the lower right corner of the window.

[A screenshot of an Excel Page Setup dialog box under the "Sheet" tab. The "Rows to repeat at top" text box is highlighted and shows "$1:$1". Print options include gridlines, black and white, draft quality, and print order, with options to print, preview, and set up margins.]

·    This returns you to your spreadsheet and gives you another box at the top of your screen that says Page Setup – rows to repeat at top.

·    Click on the number (found on the left margin) of the row you want to repeat in the spreadsheet.

·    A dancing line will appear around the row you selected and the cell's code will appear into the box.

·    In the Page Setup – Rows to repeat at top box, click on the down arrow again and you will return to the full Page Setup box.

·    Click OK to complete the process.

NOTE: You can follow the same instructions if you would like the title ROW(s) to repeat (in other words the text you have in the first column to show up on each page) click on the box for "Columns to repeat at left".

When you scroll through your spreadsheet on the computer, you won't see the repeating header ROWS (unless you've also used Freeze Panes … see that tip here<https://opiayfbab.cc.rs6.net/tn.jsp?f=00137BNGymgBofHOqBa0QsNsi212ODJ_Ar0gappmAxzWmTiSMOdJ05IrMnP0b6BmWb6io4KPTu8f1lPzc_JijoJrZJii7R_9fOfcdrLAKDwDp6ZlPMbAa95TI55x6p6moZ9Jusdmkt60v2PqG34LSmGueux1RSfRLupljhtEK2Lk_6Tv7rbrHBVXQ==&c=_156of-9dv6_Yh4P2d5GScJLq5V8Hc1X9j3LRLPAOYLZSJRltUKKvg==&ch=9DOGhvC7msdQqNSIv5DBePWfeRMW9eosZFWLwo5VkvLDgL9UcnRrbQ==>), but they will be there on your printed version.

Print Headers in Your Excel Spreadsheet

If you want to print the Headers (A, B, C... across the top, or 1, 2, 3... in the rows to the left):

·    With your spreadsheet open, select the Page Layout Tab, go to the Sheet Options section.

·    Simply check the Print box under Headings.

[Screenshot of a Microsoft Excel toolbar with the "Page Layout" tab selected. Various options are shown, such as themes, colors, fonts, effects, margins, orientation, size, print area, breaks, background, print titles, and sheet options, with "Print" checked.]

Now when you print the spreadsheet the Header letters and numbers will be displayed:

[A spreadsheet displays multiple rows and columns with headers including First name, Last name, Email status, Email permission, Email update, Member ID, Tag, and Email Lists]

Print Titles on Each Page ... in Excel 365 WEB

Printing titles or row headers isn't possible in Excel ONLINE. However, there is a workaround.

If you can create the spreadsheet in the desktop version and set the titles (and headings) to print, when you upload it to your online account they will appear.

Print Titles on Each Page in Google Sheets

To make sure your TITLE row (text) is visible on each Google Sheet when printed:

·    First, select the View tab at the top of the window, click Freeze from the drop-down menu and select 1 row.

[A G-Sheets interface with the "View" menu open and the "Freeze" submenu visible. The "1 row" option is highlighted to freeze the first row of the sheet. A list titled "Expenses" is visible on the left side, perfect for organizing before you print the spreadsheet.]

[Dropdown menu in a spreadsheet application showing options for headers and footers. Options include checkboxes for Page numbers, Workbook title, Sheet name, Current date, and Current time. A highlighted section points to "Repeat frozen rows" at the bottom to assist when you print multiple pages.]
·    Then, to print, go to File and select Print.

·    In the right column, go to the Headers & footers section.

·    Check the Repeat frozen rows option.

·    Click the Next button, and Print.

NOTE: You are currently not able to print the HEADER Row (the numbers and column letters) at this time.

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

Communication

How committed are you?

Recently I read, "Commitment is the foundation of all great accomplishments." Well that seems obvious, so what do we do with that idea?

If commitment is a dedication, or a pledge, to consistently pursue a goal, how can we increase it?

Tony Robbins offered a solution with an interesting thought. He suggests that, "If you want to take the island, burn the boat." In other words, you can't have one foot in and one foot out ... a fallback where you can change your mind.

If you truly want to succeed you have to make a commitment and go all in. Persevere through challenges to reach meaningful goals. Burn the boat so you have no choice but to move forward.

[https://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png]<https://opiayfbab.cc.rs6.net/tn.jsp?f=00137BNGymgBofHOqBa0QsNsi212ODJ_Ar0gappmAxzWmTiSMOdJ05IrHqE6zCJfl9HDvJz42HJyoTgXbIFlmMcTZTmWbOT_i-eq0OHM7F1MOzB5g1Lpf83eLKvuez1q_7FgySdYY4HoIvhEnaL97x4Wmy7DgcEQ1Sp1sKSxyo-RaU=&c=_156of-9dv6_Yh4P2d5GScJLq5V8Hc1X9j3LRLPAOYLZSJRltUKKvg==&ch=9DOGhvC7msdQqNSIv5DBePWfeRMW9eosZFWLwo5VkvLDgL9UcnRrbQ==>

[Ask a question]<https://opiayfbab.cc.rs6.net/tn.jsp?f=00137BNGymgBofHOqBa0QsNsi212ODJ_Ar0gappmAxzWmTiSMOdJ05IrAGMmauivUjufnspGJlD33wIXl-TP26W6ylvTTMjaZVeJRX5gAgHrNucfgOXanRQMBaIC0AiK7fnk-ENLE0N6L-x0gM_ZfvhVh_7JWbQwGNGknvE9Pax4mM=&c=_156of-9dv6_Yh4P2d5GScJLq5V8Hc1X9j3LRLPAOYLZSJRltUKKvg==&ch=9DOGhvC7msdQqNSIv5DBePWfeRMW9eosZFWLwo5VkvLDgL9UcnRrbQ==>

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>
Follow @StateLibraryOR: Facebook<http://fb.me/StateLibraryOR> | Twitter<https://twitter.com/StateLibraryOR> | Instagram<https://www.instagram.com/statelibraryor/> | Pinterest<https://pinterest.com/statelibraryor/> | YouTube<https://www.youtube.com/channel/UC0-kU8Gu0jS_YcnXg-b_TRA/featured>

[cid:image001.png at 01DAD20A.8ECF30E0]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/libs-or/attachments/20240709/50097fc7/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/libs-or/attachments/20240709/50097fc7/attachment.png>