For large ranges, if you don't want to apply the formula for the whole row/column, you can select the start of the range, then use the slider to go to the end of the range. Press SHIFT and select the end of the range. This selects the whole range. Then you can press CTRL + ENTER to apply the formula.