Home Tags Spreadsheet

Tag: Spreadsheet

Google Sheets Pivot Table with row and column groupings sorted by Grand Total (Sum of Sales)

How to Sort a Pivot Table by Value in Google Sheets

Prashanth K V 0
Google Sheets Pivot Table displaying rows in a custom order with a clean layout

How to Sort Pivot Table Rows in Custom Order in Google...

Prashanth K V 0
Google Sheets data validation using an absolute reference to allow data entry only when the master switch is set to Yes

How to Use Custom Formula in Data Validation in Google Sheets

Prashanth K V 0
Drop-down list in Google Sheets showing selectable options

How to Create a Drop-Down List in Google Sheets

Prashanth K V 0
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
123...120Page 1 of 120