How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Car Loan Amortization Schedule in Google SheetsYes. In Google Sheets, enter the amount financed, annual interest rate, and loan term, calculate the monthly payment with PMT, then use…
- Cannot Add a Shared Mailbox to Outlook? Fixes That WorkYes, you can add a shared mailbox to Outlook, but your account first needs permission to open it. If it still will…
- Can’t Add a Shared Mailbox to Outlook? Fixes That WorkYes, you can add a shared mailbox to Outlook, but your Microsoft 365 or Exchange administrator must first give your account permission…
- Can’t Block a Sender in Outlook? Fixes That WorkYes, you can usually block a sender in Outlook, but the option and its effect depend on which Outlook version and account…
- Can’t Create Rules in Outlook? Causes and FixesYes, you can create rules in most Outlook versions, but the steps and available options depend on whether you use classic Outlook…
- Can You Split a Column in Google Sheets? Here’s HowYes. In Google Sheets, select the cells you want to divide and choose Data > Split text to columns, then pick a…
- Power Query in Google Sheets: What Works and What Doesn’tNo, Google Sheets does not include Microsoft Power Query or a built-in Power Query Editor. You can still import and reshape data…
- Can You Split a Cell in Google Sheets?No—you can’t divide one Google Sheets cell into two or more independent cells. You can split the text inside a cell across…
- Can You Split a Cell in Google Sheets? Here’s HowYes, you can split the text in a Google Sheets cell into separate columns using Data > Split text to columns. You…
- Can You Sort Google Sheets by Color? Steps and WorkaroundsYes. In Google Sheets in a web browser, you can sort rows by a cell’s fill color or text color using a…
- Word Booklet: Can You Make One From a Document?Yes. Microsoft Word can arrange a document as a booklet: in the desktop app, set the pages option to Book fold, check…
- Can You Make One Page Landscape in Word?Yes. In Microsoft Word for Microsoft 365 on Windows, insert a Next Page section break before and after the page, then set…
- Can You Make Columns in a Text Box in Microsoft Word?Yes. In desktop Microsoft Word, select the text box and use Shape Format > Columns to divide its text into columns; if…
- Can You Insert a Horizontal Line in Word?Yes. In Microsoft Word for Microsoft 365 on Windows, you can insert a horizontal line from Home > Paragraph > Borders >…
- Can You Lock Certain Cells in Google Sheets? Here’s HowYes. In Google Sheets in a web browser, select the cells, choose Data > Protect sheets and ranges, and set who can…
- Find Duplicates in Google Sheets: Methods That WorkYes. In Google Sheets, you can highlight duplicate values with conditional formatting, count or list them with formulas, or remove repeated records…
- Can You Insert a Digital Signature in Word?Yes. In Word for Microsoft 365 on Windows, you can add a signature line and sign it with a digital certificate, or…
- Power Query in Google Sheets: What You Can Do InsteadNo—Google Sheets does not include Microsoft Excel’s Power Query editor, and it cannot run Power Query’s M language natively. You can still…
- Export Outlook Contacts to Excel: Steps and OptionsYes. You can export Outlook contacts to a comma-separated values (CSV) file and open that file in Excel; in classic Outlook for…
- Outlook Web Rules: How to Create and Manage ThemYes. You can create inbox rules in Outlook on the web to automatically sort, categorize, forward, mark, or delete incoming messages that…
- Can You Delete a Whole Page in Word? Here’s How to Do ItYes. In Word for Microsoft 365 on Windows, press Ctrl+G, enter \page in the Go To box, press Enter, close the dialog,…
- Can You Create Outlook Rules in OWA? Here’s HowYes. You can create and manage Outlook rules in Outlook on the web (OWA) to sort incoming email, move messages to folders,…
- Can You Create a Meeting Template in Outlook?Yes. You can reuse a meeting setup in Outlook, but the best method depends on what you want to preserve: copy a…
- Can You Block an Email Sender in Outlook? How It WorksYes. Outlook lets you block an email address, and many versions also let you block an entire sending domain; messages from blocked…
- Create a Calendar Template in Outlook: A Practical GuideYes. You can create a reusable calendar setup in Outlook, but the best method depends on what you mean by a template:…
- Can You Automatically Alphabetize Tabs in Google Sheets?Yes, you can alphabetize sheet tabs in Google Sheets, but there is no built-in command that sorts them automatically. In a browser,…
- Can You Auto Sort in Google Sheets? Setup and LimitsYes. Google Sheets can keep a separate, formula-generated view sorted as your data changes; to automatically reorder the original rows when someone…
- Can You Add an Image to a Header in Word?Yes. In Word for Microsoft 365 on Windows, open the header by choosing Insert > Header > Edit Header, then choose Insert…
- Can You Add a Watermark to a Word Document? Here’s HowYes. In Microsoft Word for Microsoft 365 on Windows, choose Design > Watermark to apply a built-in label, or open Custom Watermark…
- Can You Add Audio to a PowerPoint Slideshow? Here’s HowYes. In PowerPoint for Microsoft 365 on Windows, add a sound file with Insert > Audio > Audio on My PC, or…