The sheets supports cell ranges C2:C7, column ranges C:E and row ranges in 3:7. And it does support also partial column/row ranges like C2:E or C2:5. I love this since it's really handy when creating forms that keeps expanding overtime.

But these partial ranges are not visualized correctly, the autocomplete tries to suggest functions and any place validating the formula (e.g. conditional formatting) fails to save it (properly).