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

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Miscellaneous
Revision as of 14:56, 4 November 2008 by Ufi (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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