| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 72601 | 2006-09-19 01:23:00 | Word Processing in Excel? | GrahamB (750) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 485680 | 2006-09-19 01:23:00 | Is it possible to format cells in Excel in such a way as to be able to use paragraphs within a cell? Regards GrahamB |
GrahamB (750) | ||
| 485681 | 2006-09-19 02:33:00 | Use a text box (from the drawing toolbar I believe). | TGoddard (7263) | ||
| 485682 | 2006-09-21 09:12:00 | Now who looks like a complete idiot then? All the work I have done with Excel and I never knew you could do that. And it works a treat! Thanks you to TGoddard and to Parry for the same suggestion. TFYH Regards GrahamB |
GrahamB (750) | ||
| 485683 | 2006-09-21 19:56:00 | Hi Graham, if your meaning just putting lines in a cell then hold down ALT & ENTER to insert a line. To add the textbox automatically to the activesheet then use something like this where you are aligning the top left part of the textbox to cell D5. Change the values of 100 & 50 to make the box bigger or smaller as required. If Application.CommandBars("Drawing").Visible <> True Then Application.CommandBars("Drawing").Visible = True End If ActiveSheet.Shapes.AddTextbox(msoTextOrientationHo rizontal, _ Range("D5").Left, Range("D5").Top, 100, 50).Select |
Parry (5696) | ||
| 1 | |||||