Utilities

866 tools and guides in Utilities. Pick one and use it right away.

πŸ–οΈ

How to Highlight Text in Word

Select the text you want to emphasize, click the highlight icon on the Home tab, choose a color, and keep dragging to highlight multiple spots in a row.

Utilities β†’
πŸ”—

How to Link a Cell to Another Sheet in Excel

Turn any cell into a clickable button that jumps straight to another sheet using Insert > Link, so you never have to hunt through tabs again.

Utilities β†’
πŸ“Š

How to See Instant Sum, Average, and Count in Excel

Select a range of numbers and read the sum, average, and count instantly from the status bar at the bottom of the screen β€” no formula required.

Utilities β†’
πŸ“„

How to View Multiple Pages at Once in Word

Switch to the Multiple Pages view to see your entire document as small thumbnails side by side, so you can judge overall layout and length in one glance.

Utilities β†’
πŸ“‘

How to Duplicate a Sheet Within the Same Excel File

Hold Ctrl and drag a sheet tab to instantly create a copy inside the same workbook, keeping all formatting and formulas intact.

Utilities β†’
βœ‰οΈ

How to Print an Envelope in Word

Use the Envelopes tool under the Mailings tab to print a clean, properly formatted envelope with recipient and return addresses in the right spot.

Utilities β†’
πŸ–¨οΈ

How to Repeat Header Rows on Every Printed Page in Excel

Use Print Titles to repeat your header row automatically at the top of every printed page, so long tables stay readable across multiple sheets of paper.

Utilities β†’
πŸ“§

How to Send Personalized Bulk Email with Gmail Mail Merge

Connect a spreadsheet of recipients to Gmail's multi-send mode to send personalized emails with each person's name and details automatically filled in.

Utilities β†’
πŸ”’

How to Restart Numbering in a Word List

Right-click any list item and choose Restart at 1 to begin a fresh numbered sequence partway through a document, without disturbing earlier lists.

Utilities β†’
πŸ—‚οΈ

How to Group Sheets in Excel to Edit Them All at Once

Select multiple sheet tabs with Shift or Ctrl to group them, then apply formatting or enter data once and have it appear on every grouped sheet simultaneously.

Utilities β†’
🎨

How to Import Styles from Another Word Document

Use the Manage Styles dialog to import a consistent set of formatting styles from one document into another, without rebuilding them from scratch.

Utilities β†’
πŸ“‹

How to Create a Dropdown List from Another Sheet in Excel

Set up Data Validation to pull dropdown options from a range on a separate sheet, so the list updates everywhere automatically whenever you edit the source.

Utilities β†’
🚫

How to Turn Off Automatic Bulleted and Numbered Lists in Word

Stop Word from auto-converting a hyphen or "1." into a bulleted or numbered list by turning off AutoFormat As You Type β€” full steps included.

Utilities β†’
πŸ”’

How to Count Filtered Results in Excel

See exactly how many rows match your filter in Excel β€” using the status bar or the SUBTOTAL function β€” without counting them by hand.

Utilities β†’
🧹

How to Clear Cell Values in Excel Without Losing Formatting

Remove the data in a cell while keeping its background color, borders, and font formatting intact β€” a quick guide using the Clear Contents option.

Utilities β†’
πŸ”

How to Highlight Duplicate Values in Excel with Conditional Formatting

Spot duplicate entries visually before deleting anything, using Excel's built-in conditional formatting rule for duplicate values.

Utilities β†’
⭐

How to Customize the Quick Access Toolbar in Word

Pin your most-used commands to the top of the Word window so you never have to hunt through ribbon tabs for them again.

Utilities β†’
πŸ–¨οΈ

How to Print Multiple Sheets at Once in Excel

Select several sheet tabs together and print them in a single job, instead of opening and printing each sheet one by one.

Utilities β†’
πŸ“œ

How to Make Text Vertical in Word

Rotate text 90 or 270 degrees inside a text box to create vertical text for traditional-style documents or unique design layouts.

Utilities β†’
πŸ“§

How to Reply from a Different Email Address in Gmail

Register an alias address in Gmail and choose which address a reply is sent from, so you can manage multiple identities from one inbox.

Utilities β†’
πŸ“‹

How to Save Frequently Used Text as Quick Parts in Word

Save a signature, greeting, or any repeated phrase once, then insert it instantly later with just a few clicks β€” no more retyping the same text.

Utilities β†’
πŸ“„

How to Set a Different Print Orientation for Each Sheet in Excel

Set portrait or landscape orientation individually per sheet in Excel, so a wide data sheet and a narrow summary sheet each print correctly.

Utilities β†’
πŸ“₯

How to Import Mail From Another Account Into Gmail

Step-by-step guide to opening Gmail settings, finding the Accounts and Import tab, clicking Import mail and contacts, and entering another account's login to pull its messages into one Gmail inbox.

Utilities β†’
🎨

How to Change Gridline Color in Excel

How to open File β†’ Options, go to Advanced, find the worksheet display options, and change the gridline color to something other than the default gray.

Utilities β†’
πŸ–¨οΈ

How to Print Only Odd or Even Pages in Word

How to open File β†’ Print, click the page range dropdown, choose to print only odd pages or only even pages, and use that to manually create double-sided prints.

Utilities β†’
πŸ“

How to Wrap Text Automatically in Excel Cells

How to select the cells you want, click Wrap Text in the Home tab, let the row height adjust automatically, and optionally insert a manual line break with Alt+Enter instead.

Utilities β†’
πŸ”

How to Set a Custom Print Scale Percentage in Excel

How to open the Page Layout tab, find the scale input in the Scale to Fit group, type in an exact percentage like 90% or 120%, and preview the result before printing.

Utilities β†’
✏️

How to Add Strikethrough Text in Word

How to select text, find the strikethrough icon in the Home tab's Font group, click it to apply the line through the text, and use the Font dialog or Ctrl+D as a shortcut.

Utilities β†’
πŸ”Ž

How to Find All Cells With Conditional Formatting in Excel

How to click Find & Select in the Home tab, choose Go To Special, select Conditional Formats, and instantly see every cell in the sheet that has a conditional formatting rule applied.

Utilities β†’
πŸ”’

How to Count How Many Times a Word Appears in Word

How to open the Find dialog with Ctrl+F, type in the word or phrase you're searching for, and read the total match count shown at the top of the navigation pane, or use Advanced Find as an alternative.

Utilities β†’
🚫

How to Hide Error Values When Printing an Excel Sheet

How to open the Page Layout tab, click Print Titles, go to the Sheet tab, and change the cell error display setting so formula errors print as blank instead of showing on the page.

Utilities β†’
πŸ—’οΈ

How to Print PowerPoint Slides With Speaker Notes

How to click File then Print, open the Full Page Slides dropdown, select Notes Pages, and preview the result so each printed page shows a slide image along with its speaker notes.

Utilities β†’
πŸ“Œ

How to Pin a Folder to Quick Access in Windows File Explorer

How to open File Explorer, navigate to the folder you use often, right-click it and choose Pin to Quick Access, and confirm it now appears in the Quick Access list in the sidebar.

Utilities β†’
πŸ”’

How to Protect a Worksheet in Excel

Lock the cells you want, turn on sheet protection, set an optional password, choose which actions to still allow, and unprotect it later β€” the full walkthrough for protecting an Excel worksheet.

Utilities β†’
πŸŒ™

How to Turn On Dark Mode in Windows

Open Settings, go to Personalization, open the Colors menu, and switch to Dark β€” the full walkthrough for turning on dark mode in Windows.

Utilities β†’
πŸ“‹

How to Use Clipboard History in Windows

Press the shortcut, turn the feature on, copy several items, paste from the list, and pin favorites β€” the full walkthrough for using Windows clipboard history.

Utilities β†’
πŸ”€

How to Sort by a Custom List in Excel

Select the range, open the sort dialog, pick a custom list, define your own order, and apply it β€” the full walkthrough for sorting by a custom list in Excel.

Utilities β†’
πŸ“°

How to Split a Word Document Into Columns

Select your text, open the Layout tab, choose a column count, and adjust the width β€” the full walkthrough for splitting a Word document into multiple columns.

Utilities β†’
βš™οΈ

How to Save an Excel File as a Macro-Enabled Workbook

Use Save As, open the file format dropdown, choose the .xlsm format, and confirm the extension β€” the full walkthrough for saving a macro-enabled Excel workbook.

Utilities β†’
πŸ–ΌοΈ

How to Change Where Windows Saves Screenshots

Find the Screenshots folder, open its properties, go to the Location tab, and move it β€” the full walkthrough for changing where Windows saves screenshots.

Utilities β†’
β˜‘οΈ

How to Insert Checkboxes in Google Sheets

Select a cell range, open the Insert menu, add checkboxes, and count how many are checked β€” the full walkthrough for using checkboxes in Google Sheets.

Utilities β†’
βž•

How to Sum Values Across Multiple Sheets in Excel

Check that sheets share the same layout, start a SUM formula, select the range of sheet tabs, and click a cell to finish β€” the full walkthrough for summing across multiple Excel sheets with a 3-D reference.

Utilities β†’
🧩

How to Manage and Remove Chrome Extensions

Click the puzzle-piece icon, open extension management, disable or delete extensions, and check their permissions β€” the full walkthrough for managing Chrome extensions.

Utilities β†’
πŸ“„

How to Use Different Page Orientations Within One Word Document

Place your cursor, insert a section break, change the orientation for just that section, and confirm the rest is unaffected β€” the full walkthrough for mixing portrait and landscape pages in Word.

Utilities β†’
πŸ“Š

How to Add or Delete Multiple Excel Sheets at Once

How to select several sheet tabs together and add or delete them all in a single click, instead of repeating the process one sheet at a time.

Utilities β†’
πŸ–¨οΈ

How to Repeat Header Rows on Every Printed Excel Page

How to use Excel's Print Titles feature so a header row automatically repeats at the top of every printed page in a long spreadsheet.

Utilities β†’
βœ‰οΈ

How to Reply All in Gmail

How to find the Reply All option in Gmail so everyone on an email thread receives your response, not just the original sender.

Utilities β†’
πŸ–ΌοΈ

How to Remove a Picture's Background in PowerPoint

How to use PowerPoint's built-in Remove Background tool to cut a photo's background out directly inside a presentation, without a separate photo editor.

Utilities β†’
πŸ—‚οΈ

How to Show File Extensions in Windows

How to turn on file name extensions in File Explorer so every file clearly shows what type it is, and why leaving them hidden is a security risk.

Utilities β†’
πŸ“

How to Compare Two Word Documents

How to use Word's built-in Compare tool to automatically generate a marked-up document showing every difference between two versions, even without tracked changes.

Utilities β†’
🎞️

How to Add Slide Transitions in PowerPoint

How to apply a transition effect between PowerPoint slides so the presentation moves smoothly from one slide to the next instead of switching abruptly.

Utilities β†’
πŸ’€

How to Set the Sleep Timer in Windows

How to adjust how long a Windows PC waits before turning off the screen or going to sleep, and how to set separate timers for battery and plugged-in power.

Utilities β†’
⭐

How to Star Important Emails in Gmail

How to mark an email with a star in Gmail so it's easy to find again later, and how to use multiple star icons to distinguish different levels of importance.

Utilities β†’
πŸ”˜

How to Create Custom Bullet Points in Word

How to replace Word's default bullet symbol with a custom character, symbol, or even your own image for a list that stands out.

Utilities β†’
βœ‚οΈ

How to Remove a Hyperlink in Word

From right-clicking a link to removing every hyperlink in a document at once with a keyboard shortcut, here is how to strip hyperlinks out of a Word document while keeping the text intact.

Utilities β†’
πŸ‘οΈ

How to Check Whether Gmail Read Receipts Are Available

From the limits of a free personal account to the "Request read receipt" option on Workspace accounts and third-party tracking tools, here is how read receipts work in Gmail depending on your account type.

Utilities β†’
#️⃣

How to Add Slide Numbers in PowerPoint

From opening the Insert tab to checking the Slide Number box, excluding the title slide, and applying it to every slide, here is how to add slide numbers in PowerPoint.

Utilities β†’
πŸš€

How to Manage Startup Programs in Windows

From opening Task Manager with a shortcut to checking the Startup Impact column and disabling unneeded programs, here is how to manage startup programs in Windows to speed up boot time.

Utilities β†’
πŸ“…

How to Auto-Insert Today's Date with TODAY and NOW in Excel

From the TODAY function to the NOW function, a shortcut for a fixed date, and formatting the display, here is how to automatically insert the current date in Excel.

Utilities β†’
πŸ”’

How to Password Protect a Word Document

From opening File > Info to Protect Document, encrypting with a password, and confirming it, here is how to set a password on a Word document.

Utilities β†’