Home Tags Spreadsheet

Tag: Spreadsheet

Google Sheets SHEET function verifying a list of worksheet names

How to Use the SHEET and SHEETS Functions in Google Sheets

Prashanth K V 0
Self-healing table of contents in Google Sheets with clickable hyperlinks to each worksheet

How to Create a Self-Healing Table of Contents in Google Sheets

Prashanth K V 0
Formula in cell B2 dynamically sorting a tab name list by workbook order in Google Sheets

Sort a Tab Name List Dynamically by Workbook Order in Google...

Prashanth K V 0
Google Sheets 10x10 nonogram puzzle with clues and uniqueness test result

How to Generate Unique 10×10 Nonogram Puzzles in Google Sheets

Prashanth K V 0
Google Sheets fuel cost split formula showing shared trip data and fuel cost allocation per passenger

How to Build a Road Trip Fuel Cost Splitter Formula in...

Prashanth K V 0
Zigzag numbering in Google Sheets example

How to Create Zigzag Numbering in Google Sheets

Prashanth K V 0
Dice roller in Google Sheets created with one formula

Create a Dice Roller in Google Sheets Using One Formula

Prashanth K V 0
Google Sheets calendar rotated by 90 degrees, 180 degrees, and 270 degrees using formulas

How to Rotate a Table in Google Sheets by 90°, 180°,...

Prashanth K V 0
How to delete hidden rows in Google Sheets using filters and helper column method

How to Delete Hidden Rows in Google Sheets Using a Helper...

Prashanth K V 0
Current and longest streaks calculated from dates with gaps in Google Sheets

Track Current and Longest Streaks from Dates in Google Sheets &...

Prashanth K V 0
Premium and fully automated free Google Sheets templates library

40+ Free Google Sheets Templates (Premium & Fully Automated)

Prashanth K V 2
Unpivot calendar in Google Sheets with different rows per week showing original layout and row-wise result

Unpivot a Calendar Grid in Google Sheets (Repeat Dates for Each...

Prashanth K V 0
123...119Page 1 of 119