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

From Apache OpenOffice Wiki
Jump to: navigation, search


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


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.


Personal tools