It is good convention to name your columns, to put some kind of description in cell 1.

However, this really bugs me, because then all my values are indexed starting at 2, so I think I'm dealing with the 14th item, when really it's the 13th item.

Does anyone else find this frustrating? What are possible solutions? Is it possible to have a cell index of 0 (eg A0) so that you can put column titles there?

  • 2
    No, you can't do that. Spreadsheets have always been like this. Certainly Microsoft Excel does. – ale Jun 27 '14 at 1:26

I'll ignore "Does anyone else find this frustrating?" (see 5th bullet point in first set).

"What are possible solutions?" Add an index column (A is best for this) say containing =row() copied down (and then convert to values or sorting could cause problems). Maybe format that column to make the index values more prominent than the headings for rows.

"Is it possible to have a cell index of 0 (eg A0)" As mentioned by @Al.E it is not possible. Any attempt at such a reference will give rise to an error.

However, given a mixture of zero- and 1-based indexing for the functions used in spreadsheets (provides training in awareness of the starting point!) it can be fairly easy to acclimatise to ignoring row numbers as a guide to number of items. Control totals and formulae to do the counting are almost as good as what you propose. There may also be the option to add say Item1 anywhere in the sheet and copy down to automatically number each item, regardless of the start row.

Given that column labels are so often required and even when not are almost always advisable, it does sound as though 0:0 would be an excellent idea but my surmise is that this is a carry-over from the earliest spreadsheeting software (Wikipedia for example actually describes VisiCalc as "The first widely used normal spreadsheet with A1 notation") and that the power of the sheer numbercruching but lack of power of the processors on which it was performed meant that labels were hardly considered at that time. From what I can now recall, 1-2-3 had no requirement for labels (whereas some aspects of Excel for example will not work without them, and Google Sheets seems deliberately to copy Excel in many features).

| improve this answer | |
  • 1
    I had thought as much... I currently use a column of index values, but it does seem a bit superfluous, because it's right next to another column of numbers only different by 1 (the row numbers). – Mirror318 Jun 29 '14 at 8:00

Applying meaning to the row which your data is in is simply a bad idea. I know it's tempting, but it leads to problems long term.

If you need to know how many rows you have in a particular block of data, then add a helper-column on one side of your data, call it ID or Number or something meaningful in your context, and put the row number in there.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.