excel xp training - Wrap Text

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

Resolved · Low Priority · Version Standard

Wrap Text

Vivienne has attended:
Excel Intermediate course

by - delegate Vivienne [2 posts] (2007 Feb 13 Tue, 16:35) Reply

What function does wrap text does?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	0	FULL
2003	2008 Oct 23 Thu + 24 Fri	Southwark	0	FULL
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Nov 3 Mon + 4 Tue	Bayswater	4	book now	£475	£485
2003	2008 Nov 17 Mon + 18 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 40 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Wrap Text

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 14 Wed, 11:15) Reply

This function lets the words drop down to the next line when they reach the end of the cell. Similar to Word, when you just keep typing the words transfer to the next line down. Wrapping the text stops the words going outside of the cell itself.

Hope that helps

Tracy

· Features of Microsoft Excel that assist in Analysis of Financial Data
· A Beginners Guide To Formulas In Excel
· Microsoft Excel Training: Essential for Today's Employees
· Identifying Suitable Candidates For VBA For Excel Training
· How to Create Better Excel Spreadsheets: Part Two

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.