I have a keyboard with a trackpad that's missing some of the normal keys available on a full-sized keyboard (among them Home and End).
Also, there are 30,000 rows in the sheet and dragging the corner of the cell down the length of the column takes too long. It scrolls for minutes, and I have to create many formulas.
Is it possible in the formula itself to say that it applies to the entire column?
I want to the formula for this new column to grab the first two characters of another column:
Is there a way to specify "column E" rather than Cell E1?