如何指定方程是像 Gnumeric/Excel 这样的电子表格程序? [英] How to specify an equation is a spreadsheet program like Gnumeric/Excel?

问题描述

我正在对 A 列和 B 列中各自的行中的值进行相当重复的减法，并且我不想继续这样做，例如 =A1-B1.有没有办法为公式设置单元格，这样我就不必指定行，但它会在 A 列和 B 列之间进行减法?

I'm doing a rather repetitive subtraction of values from column A and column B, in their respective rows, and I don't want to keep on doing, for example, =A1-B1. Is there a way to set the cell for a formula such that I don't have to specify the row but it'll do the subtraction between column A and B?

推荐答案

Yes-- 在顶部的单元格中，比如说，第 c 行，输入=A1-B1"，然后将鼠标悬停在角落，直到获得加号并向下拖动.这会将您的方程应用到您拖动到的每个单元格.

Yes-- in the top cell in, say, row c, enter "=A1-B1" and then hover in the corner until you get the plus mark and drag down. That will apply your equation to every cell you drag to.

这篇关于如何指定方程是像 Gnumeric/Excel 这样的电子表格程序?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！