Copy two columns in Calc (OpenOffice)

We have columns A and B, and we want to get a column C, which is the sum of A values and B values (C1=A1+B1, C2=A2+B2, etc…)In C1 insert a formula: =A1+B1. Then click in the cell C1, ctrl+c, and click in the corner right-down of cell C1. Then drag until the end of the column. A1+B1 will be automatically changed to A2+B2, A3+B3… in each case.

This entry was posted in Uncategorized and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s