Documentation / User FAQ / Calc / Previous-Next
To quote from the Shortcut Keys for Spreadsheets page in Calc Help: Help > Contents > shortcut keys; in spreadsheets:
To fill a selected cell range with the formula that you entered on the Input line, press Alt+Enter. Hold down Alt+Enter+Shift to apply the cell format of the input cell to the entire cell range.
Documentation / User FAQ / Calc / Previous-Next