How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Lock and Unlock Cells in Google Sheets: A Practical GuideTo lock cells in Google Sheets, open the spreadsheet in a web browser, select the cells, then choose Data > Protect sheets…
- How to Limit a Range in Google SheetsTo limit who can change cells in Google Sheets, select the cells, open Data > Protect sheets and ranges, and set editing…
- Google Sheets VLOOKUP: Link Two Sheets Step by StepTo look up a value in a different Google Sheets file, combine VLOOKUP with IMPORTRANGE: allow access to the source file, then…
- How to Join Two Cells in Google Sheets: Merge CellsTo join two adjacent cells in Google Sheets, select them, then choose Format > Merge cells and pick the appropriate merge option.…
- How to Join Two Columns in Google Sheets With a FormulaTo join two columns in Google Sheets, enter a formula such as =A2&" "&B2 in an empty column, replacing A2 and B2…
- How to Join Cells in Google Sheets: Merge or CombineTo join cells in Google Sheets by merging them, select the adjacent cells, then choose Format > Merge cells and pick a…
- Insert Time in Google Sheets: Entry, Shortcuts & FormulasTo insert a time in Google Sheets, select a cell and type a value such as 9:30 AM or 14:30, then press…
- How to Insert Track Changes in a Word DocumentTo insert tracked edits in a Word document, open the file and select Review > Track Changes > Track Changes in Word…
- How to Insert Citations in Word Using Mendeley CiteTo insert a Mendeley citation in Word, open your document, launch the Mendeley Cite add-in from the References tab, search for a…
- How to Insert a Dropdown in Google Sheets: A Quick GuideTo insert a dropdown in Google Sheets, select the cell or cells, choose Insert > Dropdown, add your choices in the side…
- How to Insert a Citation in Word OnlineTo insert a citation in Word Online, open the document and check the References tab for Insert Citation. If that command is…
- How to Insert Citations in Microsoft Word: A GuideTo insert a citation in Microsoft Word for Microsoft 365 on Windows, open the References tab, choose a citation style, select Insert…
- How to Insert a Citation in Microsoft Word: A GuideTo insert a citation in Word, place the cursor where the source should be cited, open References > Insert Citation > Add…
- Insert a Citation in Word from EndNote: Step-by-StepTo insert an EndNote citation in Word, open your EndNote library and Word document, place the cursor where the citation belongs, then…
- How to Insert a Checkbox in Word (Clickable or Printable)To insert a checkbox in Word, use Developer > Check Box Content Control for a box people can click, or add a…
- How to Insert and Use Checkboxes in Word for the WebTo add an interactive checkbox list in Word for the web, open the Home tab, choose Checklist in the Paragraph area, and…
- How to Insert a Citation in Microsoft Word CorrectlyTo insert a citation in Microsoft Word, place the cursor where the source should appear, open References > Insert Citation > Add…
- How to Insert a Checkbox in Word Online: Clickable or NotIn Word for the web, select the lines you want to turn into a list, then choose Home > Checklist to add…
- How to Insert a Table of Contents in a Word DocumentTo insert a table of contents in Word, apply built-in heading styles to your section titles, click where the contents should appear,…
- How to Insert a Table of Contents in Word for the WebTo insert a table of contents in Word for the web, first format your section titles with built-in heading styles, then place…
- How to Insert a Vertical Line in Word: 5 Easy MethodsTo add a vertical line in Word, choose Insert > Shapes > Line, then drag while holding Shift to keep it straight.…
- How to Insert a Table of Contents in Microsoft WordTo insert a table of contents in Microsoft Word, apply built-in heading styles to your section titles, place the cursor where the…
- How to Insert a Signature in Word on a Mac: 3 WaysTo insert a signature in Word on a Mac, add an image of your handwritten signature with Insert > Pictures > Picture…
- How to Insert a Signature Line in WordIn Word for Microsoft 365 on Windows, click where the signature should go, then choose Insert > Text > Signature Line >…
- How to Insert a Signature Line in a Word Document EasilyIn Word for Microsoft 365 on Windows, place the cursor where the signature should go, then select Insert > Text > Signature…
- How to Insert a Signature in Microsoft Word: StepsTo insert a signature in Microsoft Word, add a picture of your handwritten signature with Insert > Pictures > This Device, or…
- How to Insert a Signature in Word 365: Image, Line, or InkTo insert a handwritten signature in Word 365, scan or photograph it, save it as an image, then choose Insert > Pictures…
- How to Insert a Signature in Word on Windows and MacTo insert a signature in Word, add a picture of your handwritten signature, draw one with Word’s ink tools, or add a…
- How to Insert a Line Through a Word in ExcelTo put a line through just one word in an Excel cell, edit the cell, select the word’s characters, open Format Cells…
- How to Insert a Signature Block in Microsoft WordTo insert a signature block in Microsoft Word, type the name and contact details you want beneath your closing, format them, and—if…