Excel

Resolved · Low Priority · Version 2007

Tue 29 Apr 2008, 16:10 Delegate Andrew said...

Andrew has attended:
Excel Intermediate course
Excel Advanced course

Excel

How do I create a totals row at the bottom of a table?

Sun 4 May 2008, 15:52 Trainer Cress said...

RE: Excel

In the cell under the data type =SUM(C2:C3) and substitute C2:C3 for the actual data you want to sum. You can drag this formula into other column cells

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Edit and format multiple worksheets in one operation