Difference between revisions of "Documentation/FAQ/Calc/Miscellaneous/What is the fastest way to copy a calculation to all rows?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Miscellaneous
(New page: {{DISPLAYTITLE: What is the fastest way to copy a calculation to all rows?}} <section begin=question/> '''What is the fastest way to copy a calculation to all rows?''' <section end=questi...) |
m |
||
| Line 6: | Line 6: | ||
<section begin=answer/> | <section begin=answer/> | ||
| − | To fill a selected cell range with the formula that you entered on the | + | To fill a selected cell range with the formula that you entered on the '''Input line''', press {{key|Alt|Enter}}. Hold down {{key|Alt|Shift|Enter}} to apply the cell format of the input cell to the entire cell range. |
<section end=answer/> | <section end=answer/> | ||
[[Category:Documentation/FAQ/Calc/Miscellaneous]] | [[Category:Documentation/FAQ/Calc/Miscellaneous]] | ||
Latest revision as of 14:46, 6 October 2021
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 + ⇧ Shift + ↵ Enter to apply the cell format of the input cell to the entire cell range.
