How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- How to Make a Booklet in Word: Print and Format ItTo make a booklet in Microsoft Word, open the Page Setup dialog, choose Book fold under Multiple pages, format your document in…
- How to Make a Booklet in Word 2016: Setup and PrintTo make a booklet in Word 2016, open Layout > Margins > Custom Margins, set Multiple pages to Book fold, format your…
- How to Make a Booklet in Microsoft Word, Step by StepTo make a booklet in Microsoft Word, set the document’s page layout to Book fold, write and format your pages in normal…
- How to Make a Booklet in Word 365 and Print It CorrectlyTo make a booklet in Word 365, open Layout > Margins > Custom Margins, choose Book fold from the Multiple pages menu,…
- How to Make a Booklet in Microsoft Word 365To make a booklet in Word 365, open the desktop app, go to Layout > Margins > Custom Margins, set Multiple pages…
- How to Make 2 Columns in Word for Part of a PageTo make only part of a page two columns in Word, select the text, then choose Layout > Columns > Two. Word…
- How to Make a Block Schedule in Google Sheets Step by StepTo make a block schedule in Google Sheets, set up a grid with days across the top and time slots down the…
- Mail Merge in Word: A Step-by-Step Guide for LettersTo mail merge in Word, prepare a recipient list, connect it to a Word document, insert fields such as names or addresses,…
- How to Mail Merge in Word UK: Step-by-Step InstructionsTo mail merge in Word, prepare a recipient list in Excel, connect it through Word’s Mailings tab, insert merge fields, preview the…
- Mail Merge in Word, Excel & Outlook: A Step-by-Step GuideTo mail merge in Word with an Excel list and Outlook, prepare a spreadsheet with one recipient per row, connect it in…
- Mail Merge in Word From Excel: Step-by-Step GuideTo mail merge in Word from an Excel file, prepare a clean list with one recipient per row, then in Word choose…
- How to Mail Merge in Word: A Practical Step-by-Step GuideTo mail merge in Word, prepare a spreadsheet or contact list with one person per row, choose a merge type on the…
- How to Mail Merge in Word for Personalized Email MessagesTo mail merge in Word for email, prepare a recipient list in Excel, connect it to a Word email message, insert fields…
- Mail Merge in Word Browser: What Works and What Doesn’tYou can prepare a mail-merge document and recipient list in a browser, but Word for the web cannot run the merge. To…
- How to Mail Merge in Word: Step-by-Step GuideTo mail merge in Word, prepare a recipient list in Excel, open Word and choose Mailings > Start Mail Merge, connect the…
- How to Mail Merge in Word: A Complete Step-by-Step GuideTo mail merge in Word, prepare a recipient list—usually an Excel workbook—then use the Mailings tab to connect it to a letter,…
- How to Mail Merge in Word 365: A Step-by-Step GuideTo mail merge in Word 365, create or open a recipient list, choose a merge type from the Mailings tab, connect the…
- Mail Merge in Word and Outlook: A Step-by-Step GuideTo mail merge in Word and Outlook, prepare a contact list in Excel, create an email in Word, connect the list, add…
- How to Mail Merge in Word 2010: A Step-by-Step GuideTo mail merge in Word 2010, open the Mailings tab, choose Start Mail Merge or Step-by-Step Mail Merge Wizard, connect a recipient…
- Google Sheets Duplicates: How to Find Repeated ValuesTo look up duplicates in Google Sheets, add a helper column and use =IF(A2="","",IF(COUNTIF($A$2:$A$1000,A2)>1,"Duplicate","Unique")); fill it down to label repeated values. You…
- How to Lock Specific Cells in Google Sheets for EditingTo lock specific cells in Google Sheets, select the cells, open Data > Protect sheets and ranges, add a range protection, and…
- Lock Track Changes in Word Online: What You Can DoYou can’t password-lock Track Changes directly in Word for the web. To make sure collaborators can’t turn tracking off, open the document…
- Google Sheets Filter View: How to Lock ItGoogle Sheets has no separate lock switch for a filter view. To keep people from changing a saved view, create and name…
- How to Lock Selected Cells in Google Sheets EasilyTo lock selected cells in Google Sheets, select the cells, open Data > Protect sheets and ranges, add a range, and restrict…
- Lock Cells in Google Sheets: Protect a RangeTo lock cells in Google Sheets, select the cells, choose Data > Protect sheets and ranges, then set who is allowed to…
- Lock Cells Together in Google Sheets: Step-by-StepTo lock cells together in Google Sheets, select the range, choose Data > Protect sheets and ranges, and set who is allowed…
- Lock Cells in Google Sheets: Step-by-Step GuideTo lock specific cells in Google Sheets, select the cells, choose Data > Protect sheets and ranges, then set who is allowed…
- Lock Cells in Excel and Google Sheets: Step-by-StepTo lock cells, first decide which cells people should still be able to edit, then protect the sheet or range. In Excel,…
- Lock Cells in Google Sheets: Protect Formulas from EditsTo stop editors changing formula cells in Google Sheets, select the cells, choose Data > Protect sheets and ranges, then set who…
- How to Locate Duplicates in Google Sheets: A WalkthroughTo locate duplicates in Google Sheets, select the cells you want to check, choose Format > Conditional formatting, and use a custom…