This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

What is the fastest way to copy a calculation to all rows?

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