excel-xp-training - Excel Introduction

The UK's most regular instructor-led training courses.
Training information: excel-xp-training · Excel/courses/london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel Introduction

Simon has attended:
Excel Introduction course

by - delegate Simon [2 posts] (2008 Jan 28 Mon, 14:04) Reply

How do I sum up all figures in cells in a row

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	6	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

Sum A Row of figures

by - trainer Carlos gold contributer [473 posts] (2008 Jan 29 Tue, 15:10) Reply

Hi Simon

To quickly add together all the numbers in a row do the following:

1. Select the cell immeadiately after the last number in the row

2. Click the AutoSum button

The total for the row appears in the cell.

Hope this helps

Carlos

· How Excel Training Can Improve Your Company's Sales Process
· How to check for and reduce errors in Microsoft Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Improve Performance Of Your Excel Macros

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips