excel course in london - Spread sheets

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

Resolved · Low Priority · Version Standard

2 posts

ReplyMon 26 Mar 2007, 09:50Delegate Ben said...

Ben has attended:
Excel Introduction course
Excel Introduction course

Spread sheets

If i set up a spread sheet - how do I set it up in such away that that i can write more than one line in each box?

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Mon 2 Aug 2010	Bloomsbury	5		£210	£215	£235
2007	Wed 4 Aug 2010	Limehouse	6		£207	£212	£235
2003	Thu 5 Aug 2010	Limehouse	5		£198	£203	£235
2010	Thu 5 Aug 2010	Bloomsbury	7		£285	£290	£299
2003	Fri 6 Aug 2010	Southwark	0	FULL			£235
2007	Mon 9 Aug 2010	Bloomsbury	6		£207	£212	£235
Full Schedule: See all 163 Excel Intermediate course dates. Bookings currently available until 30th September 2011.

586 posts

ReplyMon 26 Mar 2007, 11:10Trainer Tracy said...

RE: spread sheets

Hi Ben,

Thank you for the question.

If you want to write more data in the cells you can choose to wrap the text which keeps the columns fixed but enables you to continue to type within the cell.

To do this you highlight the cells you wish to wrap text to, then go into the Format menu and down to Cells, pick the Alignment tab at the top and there is a tick box at the bottom of the dialog box on the left hand side which says Wrap text.

See if that helps, if not get back to me

Tracy

· The Importance of Data Backups
· Charting Another Dimension With Excel
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Save time with Microsoft Excel
· A Blinking Good Excel Tip

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips