Another MS Excel Question.

[Taff]

I am preparing a table for a local group and want to include a sentence in 1 column with a number in the adjacent column. The sentence is approx 20 words long, which Excel will put in 1 "cell" - the trouble is that this looks daft as it puts it in one long line which goes off the page / screen.

So far I have split the sentence in 3 lines of approx 7 words per line and put them in 3 vertical cells (which looks a lot tidyer) but I wonder whether there is a way of doing this automatically eg marking the cells I need filled and just typing away? If there is a way, I'm sure someone on here will know how.

I suppose I could use MS Publisher, but as its years since I used that last I'm pretty rusty so it'll take me hours to familiarise myself with it before get anywhere. but I'm still reasonably competent at Excel.

 

[DaveGSCymro]

If i'm reading this correctly

right click on the cell, then format cells, then alignment, then there is a box saying text control, click merge cells

 

[WiiMW]

wrap text option will give you line breaks that match the width of the cell (format cell)

 

[Taff]

wrap text option will give you line breaks that match the width of the cell (format cell)

right click on the cell, then format cells, then alignment, then there is a box saying text control, click merge cells

All sorted. Excellent. You're bloody geniuses.

 

[Boxerboy55]

I prefer to use word wrap in the cell then make the column any width you need, rather than merge cells. I rarely merge cells as my sheets usually need clean rows and columns for sorting + analysing.

Also use Left, Right, Centre justify BOTH horizontally and vertically to place cell contents where you want them.

And I like ALT / RETURN to insert a new line inside the cell whenever I want.


I live in blllooooodddddyyyy Excel some days.

 

[AberdeenAngus]

a little bit off topic but.........
I had created an Excel spreadsheet and password protected it.
Have since forgotten the password.
Problem......how to solve !

Scratched my head, googled, downloaded freeware, excel password cracked.
Took, oooh, bout 3 minutes in total.
Bleeding heck - thought word/Excel password protection counted for summit.
I wuz wrang !

 

[Paul Wakefield]

Never ever assume passwords in Excel are secure. They are there to stop idle hands fiddling or an accidental cock up. If anybody wants to get into it, it is dead easy as you found out. The same also applies to the passwords on Excel VBA projects.

 

[turbine_2]

Another option if you want to split the lines is using ALT-Enter. That will put a carriage return in (handy if you're putting in paragraphs or lists within a cell)