How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- How to Use Styles in Word for Clear, Consistent DocumentsTo use styles in Word, select the text or place your cursor in a paragraph, then choose a style from Home >…
- Add a Header to a Word Document in Microsoft 365To add a header in Word for Microsoft 365 on Windows, open the document and choose Insert > Header, then select a…
- How to Split a Cell in Google Sheets: Text and DataTo split text in a Google Sheets cell into separate columns, select the cell or range, then choose Data > Split text…
- How to Sum a Column in Google Sheets: Formulas and TipsTo sum a column in Google Sheets, enter =SUM(B2:B12) in an empty cell, replacing B2:B12 with the range that contains your numbers,…
- How to Use COUNTIF in Google SheetsTo count cells that meet one condition in Google Sheets, use =COUNTIF(B2:B100,"Paid"); this example assumes payment statuses are in B2:B100 and returns…
- How to Set Up Automatic Email Forwarding in OutlookTo forward every incoming message automatically, open Outlook on the web or new Outlook, go to Settings > Mail > Forwarding, turn…
- Google Sheets: How to Share With OthersTo share a Google Sheet, open it in a web browser, click Share in the top-right corner, add people by email or…
- How to Sort in Google Sheets: A Practical Sorting GuideTo sort in Google Sheets, select the data you want to organize, open Data, and choose a sort command: use Sort range…
- How to Schedule an Email in Outlook on Any DeviceTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send or Send later, then select…
- How to Remove Duplicates in Google Sheets: A Safe GuideTo remove duplicate rows in Google Sheets, select your data, then choose Data > Data cleanup > Remove duplicates. Confirm whether the…
- How to Remove Formatting in Word: Text and StylesTo remove formatting in Word, select the text, then choose Home > Clear All Formatting in the ribbon. For a narrower reset,…
- How to Remove a Section Break in Word and Keep FormattingTo remove a section break in Word, show formatting marks, select the break, and press Delete (or place the cursor just after…
- How to Add a Checkbox in Google Sheets and Make It WorkTo add a checkbox in Google Sheets, select the cell or range where you want it, then choose Insert > Checkbox. Click…
- How to Merge Cells in Google SheetsTo merge cells in Google Sheets in a web browser, select the adjacent cells, then choose Format > Merge cells and pick…
- How to Present PowerPoint and See Your Speaker NotesTo present PowerPoint while reading your notes, connect a second display, set it to extend your desktop, then select Slide Show >…
- One Page Landscape in Word: Steps for Windows and MacTo make just one page landscape in Word, isolate it in its own section: insert a Next Page section break before and…
- How to Merge Cells in Google Sheets and Keep Data SafeTo merge cells in Google Sheets in a web browser, select the adjacent cells, then choose Format > Merge cells and pick…
- How to Make a Trifold Brochure in Microsoft WordTo make a trifold brochure in Word, set a page to landscape, divide it into three columns, and arrange content across the…
- Word Document Fillable Form: Create One Step by StepTo make a Word document a fillable form, turn on the Developer tab, insert content controls where people should enter information, and…
- How to Make a 4-Page Brochure in Word: Step by StepTo make a four-page folded brochure in Microsoft Word, open Layout > Margins > Custom Margins, choose Book fold under Multiple pages,…
- How to Make a Brochure in Word: Design, Layout, and PrintTo make a brochure in Microsoft Word, choose a brochure template from File > New, or set a blank page to landscape…
- How to Insert Citations in WordTo insert a citation in Word for Microsoft 365 on Windows, open the References tab, choose a citation style, select Insert Citation,…
- How to Lock Cells in Google Sheets and Protect RangesTo lock cells in Google Sheets, select the cells, choose Data > Protect sheets and ranges, then set who is allowed to…
- How to Sort by Date in Google SheetsTo sort dates in Google Sheets, select the entire table, choose Data > Sort range > Advanced range sorting options, select the…
- How to Wrap Text in Google Sheets: Settings and TipsTo wrap text in Google Sheets in a web browser, select the cell or range, then choose Format > Wrapping > Wrap.…
- How to Insert a Checkbox in Google Sheets and Use ItTo insert a checkbox in Google Sheets in a web browser, select the cell or range where you want it, then choose…
- How to Freeze Rows in Google Sheets: A Quick GuideTo freeze rows in Google Sheets in a web browser, open View > Freeze and choose 1 row or 2 rows. To…
- How to Create Rules in New OutlookTo create a rule in New Outlook, select Settings (the gear icon) > Mail > Rules > Add new rule, name it,…
- How to Create a Checkbox in Google Sheets (and Use It)To create a checkbox in Google Sheets in a web browser, select the cell or range where you want it, then choose…
- How to Create a Distribution List in OutlookTo create a personal distribution list in Outlook, open People, choose New Contact Group in classic Outlook or New contact list in…