Related rows have long been an elusive concept in spreadsheets. If you have tables that should be connected, your options have been limited to functions such as VLOOKUP or INDEX/MATCH. These functions can pull data in from other sources, but they don’t develop a built-in two-way link. However, related rows are built into Spreadsheet.com from… Continue reading Use Related Rows to Link Spreadsheets
Category: Tutorials
How to use the header row
Older spreadsheets start as an empty grid with no apparent header row. For better or worse, you can enter your data wherever you would like, starting in row 12 and column D if the fancy strikes you. This flexibility allows spreadsheets to have extra information such as summary data, formulas, or headers anywhere in the… Continue reading How to use the header row