In a spreadsheet how do I instruct B2=A2-A1, B3=A3-A2 etc.?
In a spreadsheet column how do I instruct B2=A2-A1, B3=A3-A2 etc.?
First time here? Check out the FAQ!
In a spreadsheet column how do I instruct B2=A2-A1, B3=A3-A2 etc.?
Exactly! In cell B2, enter =A2-A1. Then Copy it. Now highlight all the cells below B2 in which you want the formula to apply, use menu Edit -> Paste Special. (Do not use simple Paste.) A dialog box appears. Now under Selection, uncheck all the checked boxes, and check only Formulas and Formats. Click OK. Presto!
If this answer helped to solve your problem, please click the check mark (✔) next to the answer so that others in the community will know.
Hello,
B2
and enter the formulaB2
B2
[Update] Changed left to right (thanks to @BigRAl )
Hope that helps.
Asked: 2020-06-17 17:29:52 +0100
Seen: 120 times
Last updated: Jun 18 '20
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]