Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.6 released

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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.