SUBTOTAL Function
SUBTOTAL is a little-known function in spreadsheet programs. Despite its robustness, it is far less...
Tutorials
How to Use the Primary Column
Every spreadsheet created in spreadsheet.com has a primary column. Even though it always exists, using...
PARENTCELL Function
In a typical spreadsheet, there is no need for the PARENTCELL function. However, parent-child relationships...
Use Forms to Collect User Data
If you collect data from multiple people but don’t want them to access your spreadsheet,...
Use Related Rows to Link Spreadsheets
Related rows have long been an elusive concept in spreadsheets. If you have tables that...
How Dates and Times Work
When doing any data processing work, it’s almost inevitable that you will at some point...
Dropdown Lists in your Spreadsheet
Spreadsheet creators may want to use a dropdown list to limit the choice of values...
How to use the Header Row
Older spreadsheets start as an empty grid with no apparent header row. For better or...