怎么打印一页最后总计_一键创建Excel总计

怎么打印一页最后总计

I hope you had a wonderful Christmas, and with any luck, you're taking this entire week off. You might still be full of turkey and eggnog, so I'll just give you a small Excel tip today – something that's easy to digest.

我希望您度过了一个愉快的圣诞节，并且祝您好运，这整整一周假期都在进行。 您可能仍然充满了火鸡和蛋酒，所以今天我只给您提供一个小Excel技巧-易于消化的知识。

创建快速Excel总计 (Create Quick Excel Grand Totals)

Instead of entering each SUM function individually, you can use the AutoSum feature to create all the grand totals with one click.

您可以使用“自动求和”功能一键创建所有总计，而不必单独输入每个SUM函数。

1. Select all the cells with numbers, and the blank cells below and to the right, where you want the grand totals
   选择所有带有数字的单元格，然后选择想要总计的下方和右侧的空白单元格
2. On the Excel Ribbon, click the Home tab
   在Excel功能区上，单击“主页”选项卡
3. Click the AutoSum button, to insert the Grand totals.
   单击自动求和按钮，以插入总计。

The SUM function is added to each grand total cell, to sum the cells above, or to the left.

将SUM函数添加到每个总计单元格，以求和上方或左侧的单元格。

观看视频 (Watch the Video)

To see the steps for creating Grand Totals in Excel with one click, you can watch this short Excel video.

要一键查看在Excel中创建总计的步骤，您可以观看这段简短的Excel视频。

演示地址

______________ P.S.: For more Excel SUM tips visit the Contexture Excel SUM Functions page. ________________

________________ PS：有关更多Excel SUM技巧，请访问Contexture Excel SUM函数页面。 ________________

翻译自: https://contexturesblog.com/archives/2009/12/28/create-excel-grand-totals-with-one-click/

怎么打印一页最后总计