excel course in london - Spread sheets

Resolved · Low Priority · Version Standard

Spread sheets

Ben has attended:
Excel Introduction course

by - delegate Ben [1 post] (2007 Mar 26 Mon, 09:50) Reply

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:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: spread sheets

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 26 Mon, 11:10) Reply

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

· Interesting Lifestyle Applications for Microsoft Excel
· Microsoft Excel Training: Not Just for Newbies Anymore
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Excel Macros for the Non-Programmer
· How to Create Better Excel Spreadsheets: Part One

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

Rate this page: