Facebook Pinterest Twitter
  • Google Sheets
  • Forms
  • Docs
  • Excel
  • Sheets Vs. Excel
Search
InfoInspired InfoInspired InfoInspired
  • Google Sheets
    • Example showing custom sort order of QUERY pivot headers with multiple aggregation columns in Google Sheets

      Custom Order for QUERY Pivot Headers in Google Sheets

      Calculating trip duration by month from a list of start and end dates in Google Sheets

      Calculate Trip Days by Month (Start, End, and Full Days) in…

      Mode of Comma-Separated Numbers in Google Sheets

      How to Find Mode of Comma-Separated Numbers in Google Sheets

      Example showing the count of merged cells in a column in Google Sheets using a formula

      How to Count Merged Cells in Google Sheets (and Get Their…

      Count consecutive workday absences in Google Sheets using a formula that skips weekends and holidays

      Count Consecutive Workday Absences in Google Sheets

  • Forms
    • Automatically Pre-fill Google Forms from Google Sheets: A Step-by-Step Guide

      Automatically Pre-fill Google Forms from Google Sheets: A Step-by-Step Guide

      How to Set Up Google Docs Forms: A Comprehensive Guide

  • Docs
    • How to Insert Drop-downs in Google Docs Documents

      How to Create a Table and Pin and Unpin Header Rows…

      Docs Section Break - Margin, Header/Footer, and Page Numbering

      How to Use Section Break in Google Docs

      google docs doc writer table

      How to Split a Table in Google Docs

      How to Create First Line Indent and Hanging Indent in Google…

  • Excel
    • Mode of Comma-Separated Numbers in Excel (Dynamic Array)

      Example showing how to sort each row individually in Excel using a LAMBDA formula

      Sort Each Row Individually in Excel Using a LAMBDA Formula

      Sort data by field label selected from a drop-down list in Excel

      Sort by Field Labels Using the SORT and XMATCH Combo in…

      Example of inserting two blank rows in a table in Excel

      Dynamic Way to Insert Blank Rows in a Table in Excel

      Example of inserting empty cells between values in a column in Excel using a dynamic array formula

      Insert N Empty Cells Between Values in Excel (Dynamic Array)

  • Sheets Vs. Excel
    • Running total resets by category using SCAN

      Reset SCAN by Another Column in Google Sheets and Excel

      Spreadsheet example of maximum drawdown calculation

      How to Calculate Maximum Drawdown in Excel and Google Sheets

      Lookup previous values dynamically in Excel or Google Sheets

      Lookup Previous Values Dynamically in Excel and Google Sheets

      Formula example for sorting data while keeping blank rows intact (Excel and Google Sheets)

      Sort Data but Keep Blank Rows in Excel and Google Sheets

      Example of looking up values under categories in Excel using XLOOKUP and VLOOKUP functions

      Lookup Values Under Categories in Excel and Google Sheets

Home Tags How to Guides

Tag: How to Guides

Not Acceptable! This Error was Generated by Mod_Security, Solve WordPress Login...

Prashanth KV 2
Emptied Yahoo Mail In-box

How to Delete More Than 50 Messages at a Time in...

Prashanth KV 11
mark your location

Mark the Position Where You Are in on Your Phone and...

Prashanth KV 0
WhatsApp Profile Picture in Full Size

How to Set Your WhatsApp Profile Picture in Full Size

Prashanth KV 7
language settings 2

How to Change the Android Language Settings from Chinese to English

Prashanth KV 0
table of contents

How to Create a Clickable Custom Table of Contents in Microsoft...

Prashanth KV 0
shrink pdf files

How to Compress PDF Files Without Losing its Quality

Prashanth KV 0
Remove Facebook Messenger and Camera Icons

How to Permanently Remove Facebook Chat History or Messages

Prashanth KV 3
Delete Files on Google Drive on My PC

How to Delete Files on Google Drive on My PC Without...

Prashanth KV 10
Mail to multiple recipients without sharing each other email address

How to Send a Mail to Multiple Recipients without Sharing Each...

Prashanth KV 0
12Page 1 of 2
  1. Prashanth KV on Multiple-Selection Dependent Drop-Downs in Google SheetsMay 30, 2025
  2. Quan on Multiple-Selection Dependent Drop-Downs in Google SheetsMay 29, 2025
  3. adam potolsky on How to Return Nth Occurrence of a Day in a Month in Google SheetsMay 25, 2025
  4. Tuukka on Relative Cell Reference in Importrange in Google SheetsMay 19, 2025
  5. celes on Hyperlink to Jump to Current Date Cell in Google SheetsMay 14, 2025