I'm working with a language file, with columns for different languages. My first row is the language names.
Is it possible to have the "A", "B", "C", etc as language names instead. That way, when I scroll I can still identify each column.
MacOS – How to rename the columns in Numbers
macosnumbers
Related Solutions
In practice, you could sum each column and then sum just the the sum row.
That way, you can delete the sum of the column to be skipped when needed and it should be clear about which of the columns is ignored.
A more general solution will be tricky since it's programming in conditional values or conditional functions that are much harder to maintain, debug and be confident your math is correct as you use the tool over time.
So, this is easy to solve in Excel... I don't have access to Numbers at the moment, but I'll give you the solution I'm aware of and you can confirm whether it works in Numbers like it does Excel.
You can create a column with the following formula:
=Row() - 1
This will always give you one less than the "default" row number, which is what you are looking for. It also won't be affected by sorting.
A complete reference of functions that are available in Numbers can be found HERE, including the ROW function.
Best Answer
As often happens, a couple of minutes after posting the question, I found a way to do this.
In the Inspector, (opt-cmd-i), in the Table Inspector tab click on the middle button of Headers and Footers. Select the option Freeze Header Rows and the first row will stick to the top.