Search code examples
excel-formulagoogle-sheets-formulakeyboard-shortcutsspreadsheet

How do I get to the bottom of a column to apply a formuale other than dragging

I am dragging corner cell in spreadsheets to apply a formula to cells in a column, fine when there are only a few rows but, is there a way to quickly move to the bottom of a column to ap[ply the formula.

Solution

  • the proper way would be to use ARRAYFORMULA in the first cell which will auto-populate for the rest of the column

    otherwise:

    select the first cell and press

    CTRL + SHIFT + ARROW DOWN

    then press

    CTRL + ENTER