Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017calculation copy fastest rows

0

Posted

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

1 Answer

0

Posted

To quote from Calc “Help” => “Shortcut Keys for Spreadsheet” : 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.